10

PostgreSQL-Compatible AlloyDB Now Generally Available on Google Cloud

 1 year ago
source link: https://www.infoq.com/news/2022/12/google-cloud-alloydb-postgresql/?itm_source=infoq&itm_medium=popular_widget&itm_campaign=popular_content_list&itm_content=
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

PostgreSQL-Compatible AlloyDB Now Generally Available on Google Cloud

Dec 22, 2022 2 min read

Recently Google announced the general availability (GA) of AlloyDB for PostgreSQL, a fully-managed, PostgreSQL-compatible database service providing scale-out compute and storage, integrated analytics, and AI/ML-powered management.

Earlier, the company released a preview of the service at Google I/O and since added new features such as customer-managed encryption keys (CMEK) and VPC Service Controls, a preview of cross-region replication, new two vCPU /16 GB RAM machine type, and support for additional PostgreSQL extensions like pgRouting, PLV8, and amcheck. In addition, the company introduced the preview of an index advisor and, more recently, new fleet-wide monitoring to improve manageability.

Andi Gutmans, a VP of engineering databases at Google, tweeted:

I am excited to see the AlloyDB fleet health monitoring launch in public preview. This feature will enable customers to view summary information at a project level for areas like CPU utilization, replication lag, and more...!

1AlloyDB-1671281196132.png

One of the key features of AlloyDB is its ability to improve the performance of PostgreSQL databases. It provides optimized indexing and query processing, automatic query optimization, and parallel query execution. These features can significantly improve the speed and efficiency of database operations, making it easier for users to work with large and complex databases.

Ravi Murthy, an engineering director AlloyDB at Google, claims in a Google Cloud blog post:

Based on our performance tests, AlloyDB is more than four times faster for transactional workloads and up to 100 times faster for analytical queries than standard PostgreSQL. It’s also two times faster for transactional workloads than Amazon’s comparable PostgreSQL-compatible service.

Other public cloud providers Microsoft and AWS also host PostgreSQL-compatible database services like AlloyDB. Microsoft offers Azure Database for PostgreSQL and even recently released Cosmos DB for PostgreSQL, which combines the Postgres-based scale-out database technology the company acquired from Citus Data with its globally-distributed Azure Cosmos DB database service. And AWS offers PostgreSQL-compatible database services like Amazon RDS for PostgreSQL and Babelfish for Aurora PostgreSQL.

Andrew Brown, CEO at ExamPro, tweeted:

I love watching this game of cloud tennis. ☁️
AWS: Hey, use Babelfish and move MSSQL servs to Postgres us
GCP: Hey, we made this supercharged version of Postgres called AlloyDB; migrate to us
Azure: Hey, we now support Postgres on CosmoDB; no need to move

With the GA release, Google also announced the expansion of the AlloyDB partner ecosystem with several new partnerships for over 50 technology and service partners to support customers with AlloyDB-based deployments.

Lastly, compute resources for AlloyDB are priced per vCPU, and GB of memory and storage prices depend on the region.

About the Author

Steef-Jan Wiggers

Steef-Jan Wiggers is one of InfoQ's senior cloud editors and works as a Technical Integration Architect at HSO in The Netherlands. His current technical expertise focuses on integration platform implementations, Azure DevOps, and Azure Platform Solution Architectures. Steef-Jan is a board member of the Dutch Azure User Group, a regular speaker at conferences and user groups, writes for InfoQ, and Serverless Notes. Furthermore, Microsoft has recognized him as Microsoft Azure MVP for the past eleven years.

Show more

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK