是否可以对Google SQL使用自动定标器，因为计算引擎可以使用 [英] Is it possible to use autoscaler for google SQL as it is possible for compute engine

问题描述

让我解释一下这个问题.我有一个magento项目，其中包含300万种产品和超过600万个网址.因为有这么多产品，所以问题只存在于数据库中.我只想自动缩放Google Cloud SQL数据库.这样一来，它始终会做出适当的响应.我知道它可能适用于Google计算引擎，并且还包括数据库.谷歌或其他云SQL提供商有可能吗?

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?

推荐答案

您不能以相同的方式扩展数据库有状态的.您可以使用读取复制来扩展Cloud SQL.只读副本实例允许将来自主实例的数据复制到一个或多个从属实例.此设置可以提供更高的读取吞吐量.访问此文章以了解不同的只读副本方案.

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.

这篇关于是否可以对Google SQL使用自动定标器，因为计算引擎可以使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！