To meet their technical requirements for a highly scalable application, a digital marketing agency migrated to YugabyteDB Managed from MySQL, leveraging horizontal and vertical scaling, advanced monitoring capabilities, and superior query performance.
See how easy it is to use YugabyteDB Voyager to migrate a web application from a MySQL database to a distributed YugabyteDB database cluster.
We understand that database migrations can be painful. We have helped users successfully migrate from MySQL to YugabyteDB, a PostgreSQL-compatible distributed SQL database. A very popular tool to accomplish this task is pgloader. In this post, we will cover how to migrate both your MySQL schema as well as data to YugabyteDB.
Before starting the migration there are a few prerequisites you’ll need to address.
If you work with databases, at some point you are going to need to get data in and out them using a format that can be consumed by a completely different system. YugabyteDB makes use of CSV files to make this as easy as possible. The CSV format is arguably the most universally portable way to get data migrations accomplished.
TL;DR – YugabyteDB makes use of Cassandra’s COPY FROM command and a forked version of Cassandra’s Bulk Loader to get data into the system.