How to migrate a database from one cluster to another cluster?
In this article, we are going to discuss methods to migrate databases between clusters or databases between servers. Also, this kind of operation may be required for moving databases between a Production cluster and a Development cluster for testing purposes or between servers in case of OS migration/upgrade.
- The primary method to migrate a database from one cluster to another cluster is by using SingleStore BACKUP/RESTORE,
- The second method is to set up replication across clusters, Click the below link to learn about configuring replication across clusters,
Setting up replication across clusters means that there will be two active clusters and you will replicate the database from one cluster to another cluster. Once the database is in sync, you can disconnect the old one.
- Another alternate method would be to use mysqldump, Click the below link for the mysqldump procedure:
mysqldump for export and import of single table
mysqldumpmethods generate a sequence of SQL statements that can be executed to reproduce the objects. But these two methods are slower for large databases and tables.
For SingleStore CloudDB Clusters:
- The primary method to perform the database migration is BACKUP and RESTORE.
- Another method is mysqldump.
- Replicating Across clusters is not supported on SingleStore CloudDB.
For Migrating to workspaces click here.
For Migrating the local storage database to an unlimited storage database click the below link,
Migrate a Local Storage Database to an Unlimited Storage Database
For migrating, just the tables across the clusters click the below link,
Methods to move large tables across clusters