![translation](https://cdn.durumis.com/common/trans.png)
This is an AI translated post.
Select Language
Summarized by durumis AI
- Cloud SQL offers MySQL and PostgreSQL without license fees, providing additional features and automatic failover capabilities through HA configurations and Enterprise Plus options.
- AlloyDB is a database developed based on Google's storage technology, offering up to 4x faster performance than Cloud SQL, along with HA configurations and high SLAs.
- As service scales grow, AlloyDB may be more cost-effective than Cloud SQL. Cloud SQL, along with AlloyDB and Cloud Spanner, forms Google's database service hierarchy.
Cloud SQL
Google's most basic SQL service. MySQL and PostgreSQL are basically free of license fees, but MS SQL has a huge additional license fee.
Cloud SQL's pricing structure can be made up of four main combinations.
Whether to use HA configuration or not & Enterprise vs Enterprise Plus
If you use HA configuration, automatic failover is possible when a problem occurs,
and if you choose Enterprise Plus, you get a variety of additional features.
Looking at the price,
( The price order is the basic monthly price / 1 year contract / 3 year contract )
vCPU
- Basic: 39.201 $ / 29.40075 $ / 18.81648 $
- Basic + HA: 78.402 $ / 58.8015 $ / 37.63296 $
- Plus: 50.954 $ / 38.2155 $ / 24.45792 $
- Plus + HA: 101.908 $ / 76.431 $ / 48.91584 $
Memory
- Basic: 6.643 $ / 4.98225 $ / 3.18864 $
- Basic + HA: 13.286 $ / 9.9645 $ / 6.37728 $
- Plus: 8.614 $ / 6.4605 $ / 4.13472 $
- Plus + HA: 17.301 $ / 12.97575 $ / 8.30448 $
Storage ( SSD )
- Basic: 0.221 $ / GB, monthly
- HA: 0.442 $ / GB, monthly
Storage ( HDD )
- Basic: 0.117 $ / GB, monthly
- HA: 0.234 $ / GB, monthly
Maximum Size
- Enterprise: 96 vCPU / 624 GB Memory
- Enterprise Plus: 128 vCPU / 864 GB Memory
AlloyDB
A database developed using Google's proprietary storage technology.
As of now, the price is as follows for the Seoul region ( asia-northeast3 ).
- vCPU: 61.7434 $ / 46.3112 $ / 29.638 $
- Memory: 10.4682 $ / 7.8548 $ / 5.0224 $
- Storage: 0.38398 $ / GB, monthly
- Maximum Size: 128 vCPU / 864 GB Memory
Overall, HDD is included, but it is difficult to use in actual services except for data backup.
( The performance is so low, and there are clear limitations in reading and writing data. However, why even HDD HA ... )
Even AlloyDB supports HA configuration, but the SLA is so good by default.
Calculate the price based on the table above according to your situation ( it is well explained in the Google Home, but it is a little scattered.. )
If you just raise the specs according to the performance, you can provide a high-performance service at a good price. However, changing it every time is a bit of a hassle..
By the way, AlloyDB is said to be up to 4 times faster than the existing Cloud SQL, but I haven't tested that part yet. It's not a service that big yet, ( You guys make it that big.. )
And Cloud SQL has relatively more limitations than AlloyDB, so if the service grows in size, AlloyDB can be much more cost-effective than Cloud SQL.
In fact, when AlloyDB was first released, I thought, "They're releasing this at this price?" Before that, the Enterprise product was Cloud Spanner. Now you can think of AlloyDB as the higher tier of Cloud SQL, and Cloud Spanner above that.