Integrate Google Cloud Spanner to Google Cloud SQL for MySQL

Google Spanner is a Google Cloud-based database system that is ACID compliant, horizontally scalable, and global. Spanner is the database that underpins much of Google’s own data collection, and it has been designed to offer the consistency of a relational database along with the freedom of a non-relational one. To help facilitate high availability, Spanner includes automatic synchronous replication, which allows for your data to always be up-to-date while still being as consistent as it would be with a traditional relational database. Additionally, just like any relational database, Spanner can handle SQL queries and schemas, and it even supports an array of languages.
Since Google developed Spanner for its own global use, it has a built in global functionality, which allows spanner to scale to fit your needs. Your data can be stored on five nodes in one region or two hundred thousand nodes scattered around the world. This means your data is available whenever and wherever you need it. Spanner facilitates the dataflow for the likes of Adwords and Gmail, so it’s built to meet your business needs no matter how globally-reaching your company is.

Visit Google Cloud Spanner Read the Docs

Popular Use Cases

Xplenty can extract any data that you need from Google Cloud Spanner. Here are some of our most popular use cases:

Move data from MySQL to Google Spanner to provide more scalability

Integrate data from MongoDB and Google Spanner

Move data from HDFS to Google Spanner

Xplenty and Google Cloud Spanner

Xplenty supports a range of data stores through Google Cloud that integrate well with Spanner, but we also can provide you with the ability to move data from non-Google Cloud-based data stores as well. You may want to move data from a legacy data store to Spanner, because you want to take advantage of its increased consistency and scalability, and Xplenty can help with that. Or maybe you have a number of data sources that all need to be merged and moved into Spanner. Xplenty can handle that, too. We can also pull data down from Spanner, transform it, merge it, and then store it anywhere you like. Our wide variety of data integrations and our simple cloud-based service allows you to take full advantage of the convenience a scalable database like Google Spanner affords. So Spanner’s ability to both protect the integrity of the data and provide horizontal scalability is especially compatible with our product functionality.

Why Our Customers Choose Xplenty

Ease of Use

You don’t need to a be a developer in order to use Xplenty - the only skill set you need is to understand your data. That said, if you want to, you can write custom code, functions or interact with our extensive API.

Ownership

We take ownership of your data pipelines. That means that our platform will ensure that your data continues to flow and that your pipelines won’t break - and, if they do break, it’s our problem, not yours. So rest easy knowing that Xplenty has got you covered.

Control

Xplenty offers you full flexibility when it comes to how much control you can have over the process of data integration. That means that you choose exactly what data will be delivered, how it’s going to be delivered, and when - no restrictions and no confusing schedules.