Migrating a MariaDB to Cloud Spanner

Google Cloud Spanner is a relational database service which is highly consistent, available and scalable horizontally. It is a fully managed service suitable for OLTP workloads and low-latency/high-throughput environments. In this recipe, we'll understand the features of Spanner in relation to a popular RDBMS, MariaDB. We'll take a simple MariaDB database and move the schema and the data to Cloud Spanner. At the time of writing, there is no automated import/export tool for Cloud Spanner, the manual method gives us a glimpse of the way Spanner is built and its strengths/weaknesses. Firstly, we'll export the data from our MariaDB database using the mysqldump utility. Then, we'll create the database and tables ...

Get Google Cloud Platform Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.