Can somebody read this and tell me if it is possible or I can't see something and it's a misconception?
I have sites running on Wordpress. ~20 right now, but this number will grow - local businesses, low traffic - biggest site has 2000 sessions per month (0.0007 per second).
Following this tutorial http://googlecloudplatform.github.io/appengine-php-wordpress-starter-project/
I want to create CloudSQL and open new project for every site. Each one connected to the same CloudSQL instance with billing enabled.
First limit I guess I'll meet is max concurrent connections limit (for D0 I want to start with it is 25). And it is my first doubt. Will CloudSQL upscale automatically when this limit is exceeded or all of my websites may become unavailible? Is automatic downscale possible (D0 -> D1 -> D0)?
Is there a limit of applications that can use one CloudSQL instance? And last question - do you think it is good idea or old-fashioned Debian on Compute Engine would do better?