How many posts can a Ghost instance store?

I’m thinking of using Ghost as the CMS for a service I’m building. The service needs to be able to hold probably (at the high end, to be clear) 1,000,000 pages / posts per Ghost instance. Yes, you read that right.

Is this viable in Ghost? Does it just depend on the limits that MySQL has (aka “millions of rows is probably fine”)?