Google I/O: AlloyDB integrates PostgreSQL with GCP

Choice is always a good thing, and from now on, businesses faced with data overflow issues – and affecting almost every business – will have a new cloud -based option for storing their files. , data, metadata and logs.

This option is offered by the Google Cloud Platform, which today announced at the Google I/O 2022 virtual conference a new parallel database, the AlloyDB, built on top of the popular open-source PostgreSQL database, which is a standard option for to developers for over three decades. The new database may be both familiar and 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 most of the data load created by the explosion of the e-commerce and social media sectors, as well as all the new applications and data that will fill digital vaults in preparation for the environment. . Web3.

What AlloyDB brings to the market

Two of the key variations that AlloyDB brings are speed and more predictable pricing, Andi Gutmans, Google’s vice president of databases, told ZDNet.

“We can actually run analytic queries up to 100 times faster than the free Postgres software,” Gutmans said. “On the transaction side, based on our benchmarks, we’re almost four times faster than open-source Postgres, and about twice as fast than Amazon’s (Aurora) equivalent offering, so We strive to ensure good performance on both the transactional and analytical side.This means that customers who want to make real-time fraud detection, real-time recommendations, real-time inventory management- they can actually do much of it directly in their operational store. ”

As for pricing, storing data in the cloud has always been an inaccurate science. Most cloud computing providers, such as Microsoft Azure, AWS, Dell, Oracle, and others, charge users for data egress, computing, IOPS, and other services.

So Google decided to take the risk itself and simplify the pricing model, Gutmans said. No access or IOPS fees will be charged for AlloyDB, he said.

“From the beginning, customers pay for the computing and for the storage they use, they pay for the use of IOPS,” Gutmans said. “That’s really one of the biggest pain points we’ve heard from some customers – that it’s about 60% of their bill. When it comes to IOPS, they don’t feel like It’s really hard to manage because customers are the cost is not really predictable, it depends on how much data is in memory, how much data is in storage, etc. So we lowered that charge.

“Our goal is to really make this computing experience easy – like an autopilot.”

Expected AlloyDB use cases

AlloyDB is aimed at DBAs with code stacks that use the entire database offering options such as ACID-compliant transactions and stored procedures (atomicity, consistency, isolation, and durability). Gutmans told ZDNet that he expects AlloyDB to quickly enter the market and compete directly with conventional databases from Oracle, IBM or Microsoft by offering the necessary functionality in one package. cloud native that will be easier to control. CFOs will also appreciate this part.

Here’s how AlloyDB differentiates itself from its competitors, according to Gutmans:

  • Unlike Oracle, AlloyDB supports PostgreSQL. Additionally, AlloyDB supports both Postgres implementation and automation features such as autoscaling. It delivers four times faster performance than standard PostgreSQL for transactional workloads, and achieves a high availability SLA of up to 99.99%, according to Gutmans.
  • AlloyDB delivers more than twice as fast processing than the Amazon Aurora, Gutmans said. Also, AlloyDB has a more user-friendly pricing model as shown above. Unlike Amazon Aurora, AlloyDB does not charge for I/O, which can be a huge source of unpredictable and difficult to control costs – up to 60% of your total charge for transactional workloads.
  • AlloyDB is a new option for businesses that want to move away from proprietary databases, as well as PostgreSQL users with demanding, high-end applications. It allows users to cost-effectively modernize their proprietary databases and measure their mission-critical workloads, Gutmans said.

In technical terms, Gutmans says, AlloyDB is:

  • an intelligent, database-optimized storage service;
  • an optimized database engine that is 100% compatible with PostgreSQL; at
  • a service with built-in autopilot capabilities, including built-in integration with Vertex AI, that allows users to directly invoke models within a query or transaction.

AlloyDB also has a built-in columnar accelerator that can run analytical queries faster than standard PostgreSQL, Gutmans says. It is a flexible tool for developers thanks to the combination of PostgreSQL and the open infrastructure of Google Cloud. Through this, developers can use AlloyDB to quickly build applications and measure them, all with their existing open-source practices, Gutmans says.

All about Google I/O 2022

Source: “”

Leave a Comment