I am building a CRM that will potentially be used by hundreds of companies and need on-demand scalability.
I have found Google App Engine provides this however I am confused with regard to their database support.
I am only familiar with MySQL and although I see they support this (Google Cloud SQL), their initial limit is 500MB (approval needed beyond this). Two companies using my CRM can easily use 500MB of SQL storage. Will they keep allowing me to upgrade storage space?
Also, how would one suggest I design the database so I don't run into issues later on?
The CRM will have approximately 20 tables and I'd like to keep all the companies records (table rows) together so I can easily make improvements/fixes but the number of rows per company will easily grow by 500K every 6 months.
A year down the road, I don't want to run into any bottlenecks because I have 50 companies having 50,000,000 rows total.
How can I plan ahead for this?
Please advise, thanks.