PgLOS PostgreSQL

Stephanie Wong talks with guests Shachar Guz, Inna Weiner, and Gabe Weiss about Google’s Database Migration Service and how it helps companies move data to Google Cloud. What typically is a complicated process, DMS simplifies everything from planning to security to validating database migrations.

DMS has undergone some changes since last we spoke with Shachar and Gabe. It’s gone GA and helped thousands of customers benefit from the service. Migrations are possible from any PostgreSQL database source to AlloyDB for PostgreSQL, which is designed to support HTAP data (transactional and analytical). One of the most exciting updates is the introduction of the DMS modernization journey, which allows customers to change database type during migration (heterogenous). In addition, migrations with DMS can be set up to continuously replicate data between the old and new database. With this feature, developers can compare the application performance against the old vs. new database.

Inna talks about the benefits of keeping your data in the cloud, like secure, reliable, and scalable data storage. Google Cloud takes care of the maintenance work for you as well. DMS takes security seriously and supports multiple security methods to keep your data safe as it migrates. We talk about the different customers using DMS and how the process works for homogeneous and heterogeneous migrations. Before you even start, Gabe tells us, DMS helps you prepare for the migration. And tools like Dataflow can help when customers decide full migration would be too difficult. We talk about the difference between Datastream and DMS and use cases for each.

We wrap up the show with a look at the future of DMS.

Shachar Guz

Shachar is a product manager at Google Cloud, he works on the Cloud Database Migration Service. Shachar worked in various product and engineering roles and shares a true passion about data and helping customers get the most out of their data. Shachar is passionate about building products that make cumbersome processes simple and straightforward and helping companies adopt Cloud technologies to accelerate their business.

Inna Weiner

Inna is a senior technical leader with 20+ years of global experience. She is a big data expert, specializing in deriving insights from data, product and user analytics. Currently, she leads engineering for Cloud DMS. Inna enjoys building diverse engineering organizations, with common vision, growth strategy and inclusive culture.

Gabe Weiss

Gabe leads the database advocacy team for the Google Cloud Platform team ensuring that developers can make awesome things, both inside and outside of Google. That could mean speaking at conferences, writing example code, running bootcamps, writing technical blogs or just doing some hand holding. Prior to Google he’s worked in virtual reality production and distribution, source control, the games industry and professional acting.

Cool things of the week

• Flexible committed use discounts — a simple new way to discount Compute Engine instances blog
• Understanding transactional locking in Cloud Spanner blog
• Interactive In-console Tutorial site

Interview

• Database Migration Service site
• GCP Podcast Episode 262: Database Migration Service with Shachar Guz and Gabe Weiss podcast
• AlloyDB for PostgreSQL site
• PostgreSQL site
• Datastream site
• Dataflow site
• CloudSQL site
• Spanner site

What’s something cool you’re working on?

Gabe has been tinkering with new Google Cloud databases and managing a new team.

Hosts

Stephanie Wong