Advantage of PBM over mongodump/restore for MongoDB CE migration?

We have 3 MongeDB CE clusters of which we would like to migrate all databases to a single new Percona MongoDB cluster with Encryption-at-rest. My understanding is we can only use “logical backups” with CE.

For data consistency, I would stop my application cluster, run the migration, then start the application cluster with the new database connection.

What is the advantage of PBM over mongodump/restore? Can I migrate all 100+ databases with 1 command per cluster?

Hi @bluepuma77,

For migration, I would recommend to migrate your data using Initial sync process which is the easiest and safest way.

For PBM, there are many features that are advantageous. Some are -

  • Provides Point In Time Recovery (PITR).
  • Physical Backup and Restore capability.
  • Incremental Physical Backups.
  • Selectivity Backups.

Ref.: Percona Backup for MongoDB

If you are looking for support related to Data Migration, you can reach out to Percona Team.
For paid support and managed or consulting services , contact Percona Sales.

Regards,
Parag

@Parag_Bhayani Thanks for your response, what’s the “Initial sync process”? Do you mean to add a node to a replica set?

My challenge is that I have 3 clusters with 3 different replica sets (rs1, rs2, rs3), and I want to migrate all databases to a single new cluster with a new replica set name (rs).

Hi @bluepuma77 ,

Thanks for your response, what’s the “Initial sync process”? Do you mean to add a node to a replica set?

Yes, I meant by adding the fresh node to a replicaSet.

My challenge is that I have 3 clusters with 3 different replica sets (rs1, rs2, rs3), and I want to migrate all databases to a single new cluster with a new replica set name (rs).

In this case, you will need to take the dump from all three cluster and restore it one by one on the destination cluster.

I have already mentioned few features of PBM. Kindly refer to the reference link as well provided in earlier post.

Regards,
Parag