Technology

Google I/O: AlloyDB merges PostgreSQL with GCP

Choice is always a good thing, and starting today, businesses facing data overflow issues (which affects almost all businesses) will have a new cloud storage option for their files, data, metadata, and logs.

That choice comes from Google Cloud Platform, which unveiled at the Google I/O 2022 virtual conference today a new parallel database, AlloyDB, built on top of the popular open source PostgreSQL database, which has been the standard choice for developers for over three decades. Thus, a new database can be both familiar and completely new to many of its users.

According to Gartner Research, 75% of all global databases are expected to run in the cloud this year. Google AlloyDB should be able to support much of the data load caused by the explosive growth of the e-commerce and social media sectors, as well as all the new applications and data that will fill digital storage in preparation for the environment.

What AlloyDB Offers to the Market

The two main hallmarks of AlloyDB are speed and more predictable pricing, Andy Gutmans, Google’s vice president of databases, told .

“In fact, we can run analytic queries 100 times faster than the free Postgres software,” Gutmans said. “In terms of transactions, according to our tests, we are about four times faster than open source Postgres and about two times faster than the equivalent offering from Amazon (Aurora), so we work hard to ensure optimal performance as on the transactional and analytical sides. This means customers who want real-time fraud detection, real-time recommendations, real-time inventory management, they can do a lot of this right in their live store.”

When it comes to pricing, storing data in the cloud has always been an inexact science. Most cloud providers such as Microsoft Azure, AWS, Dell, Oracle, and others charge users for outgoing data, compute, IOPS, and other services.

So Google decided to take a risk and simplify the pricing model itself, Gutmans said. There will be no access or IOPS charges for AlloyDB, he said.

“From the beginning, customers pay for the compute and storage they use, they pay for the IOPS they use,” Gutmans said. “This has actually been one of the biggest concerns we’ve heard from some clients – that it was about 60% of their bill. When it comes to IOPS, they didn’t feel like it was really hard to manage because customers can’t actually predict the cost depending on how much data is in memory, how much data is in storage, etc. So we removed this fee.

“Our goal was to make this computer experience as easy as autopilot.”

Expected use cases for AlloyDB

AlloyDB is designed for DBAs with code stacks that use the complete database, offering options such as ACID-compliant transactions and stored procedures (atomicity, consistency, isolation, and durability). Gutmans told he expects AlloyDB to hit the market quickly and compete directly with regular databases from Oracle, IBM or Microsoft, offering the functionality you need in a packaged, native cloud that’s easier to manage. CFOs will also appreciate this part.

Here is how AlloyDB differs from its competitors, according to Mr. Gutmans:

  • Unlike Oracle, AlloyDB supports PostgreSQL.. In addition, AlloyDB supports both the Postgres implementation and automation features such as autoscaling. According to Gutmans, it delivers four times the performance of standard PostgreSQL for transactional workloads and delivers high SLAs of up to 99.99%.
  • AlloyDB delivers more than twice as fast processing than Amazon Aurora, Gutmans said. Also, AlloyDB has a more convenient pricing model as shown above. Unlike Amazon Aurora, AlloyDB does not charge for I/O operations, which can be a significant source of unpredictable and hard to control costs – up to 60% of your total transactional workload billing.
  • AlloyDB – new option for businesses looking to move away from proprietary databases, and for PostgreSQL users with demanding high performance applications. This allows users to cost-effectively upgrade their proprietary databases and scale mission-critical workloads, Gutmans says.

From a technical standpoint, says Gutmans, AlloyDB:

  • intelligent, database-optimized storage service;

  • optimized database engine, 100% compatible with PostgreSQL; and

  • a service with built-in autopilot capabilities, including built-in Vertex AI integration that allows users to call models directly in a query or transaction.

According to Gutmans, AlloyDB also has a built-in column accelerator that can run analytical queries faster than standard PostgreSQL. It is a flexible tool for developers thanks to the combination of PostgreSQL and Google Cloud’s open infrastructure. Developers will be able to use AlloyDB to quickly build and scale applications using their existing open source skills, Gutmans said.

All about Google I/O 2022

Source: “.com”

Back to top button