Migrating from MySQL to YugabyteDB Using YugabyteDB Voyager
See how easy it is to use YugabyteDB Voyager to migrate a web application from a MySQL database to a distributed YugabyteDB database cluster.
See how easy it is to use YugabyteDB Voyager to migrate a web application from a MySQL database to a distributed YugabyteDB database cluster.
See how how easy it is to use YugabyteDB Voyager to migrate a Node.js application backed by a single-node PostgreSQL database to a distributed YugabyteDB database cluster.
Accelerate database modernization initiatives and say goodbye to the limitations of your legacy or single-cloud databases. This blog post explains how YugabyteDB Voyager simplifies the entire database migration process, including cluster preparation, schema migration, and data migration.
In 2019, I gave a presentation with the title, “19 features you will miss if you leave Oracle.” The talk focused on features used every day with Oracle—and those that may not be available in other databases. However, the goal of this presentation was not to influence any decision or outcome.
Migrating from a commercial database is not about covering a full set of features. It’s a strategy to stay in control of the software that processes and stores enterprise data.
…
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.
…
Data migration can be a complex and time-consuming task, but proper planning can help streamline the process. In this blog, we’ll demonstrate how to migrate a Sakila demo database from MongoDB to a YugabyteDB cluster using Studio 3T, highlighting the key steps and considerations involved in the process.
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.
…