Can we migrate an EBS volume of an existing cluster to a new SingleStore cluster?
The answer is NO.
Moving the whole EBS volume will include the Cluster Metadata of the original cluster, which will not work with the new cluster. Moving EBS volumes around the distributed system is not recommended, and we don't support it; doing so might lead to an unrecoverable state of the cluster and might lead to data loss. We recommend replicating the data to the new cluster, which is a much easier and safer option.
Please follow any one of the below 3 recommended methods, which are available for the Migration:
Replicating Data Across Cluster - We can replicate data from one cluster to another cluster in this method. Data is always replicated across clusters asynchronously. Databases are replicated at the leaf level, implying that a leaf in the secondary cluster replicates data directly from a leaf in the primary cluster.
Backing Up and Restoring Data - SingleStore Native Backup and Restore method can perform the migration.
Exporting Data using mysqldump - Using the 3rd party tool mysqldump (Used in MySQL Database), which we can use because SingleStore DB supports the same query-level inputs and outputs as MySQL.
mysqldump creates a .sql file containing the queries necessary to recreate a database.
To learn about maintaining your cluster, click here.