CODEWITHSUNDEEP
sql-servergoogle-app-enginemagento
Flex Texmex
Flex Texmex

Reputation: 1084

Is it possible to use autoscaler for google SQL as it is possible for compute engine

Let me explain the problem. I have a magento project with 3 million products and more than 6 million urls. The problem ist only the database because of this much products. I would like to only autoscale the google cloud sql database. Then it would always respond adequate. I know its possible for google compute engine and that also includes the database. So is it possible with google or another cloud sql provider?

Upvotes: 2

Views: 7434

Answers (1)

Kamran
Kamran

Reputation: 3537

You cannot scale databases the same way Autoscaler is doing for Compute Engine managed instances. Autoscaling capabilities of Compute Engine works for stateless VMs. Databases are stateful. You can use read replications to scale Cloud SQL. Read Replica instances allow data from the master instance to be replicated to one or more slaves. This setup can provide increased read throughput. Visit this artcile for different read replica scenarios.

Upvotes: 3

Related Questions