Not the answer you need?
Register and ask your own question!

How to Restore MySQL backup to Percona XtraDB Cluster

abhishekamralkarabhishekamralkar EntrantCurrent User Role Novice
All ,

I configured 3 node Percona XtraDB cluster in Amazon Ec2 , and it got successfully installed and running .

Below are the points which I want to achieve

1. Restore mysql DB backup on Percona XtraDB cluster.
2. Make one of the node as slave of existing master.

If my one of my Percona Xtradb Cluster node is slave of my current master will data get replicated across the cluster.

Comments

  • wagnerbianchiwagnerbianchi Remote DBA Current User Role Patron
    First of all, how was your backup done? mysqldump, xtrabackup, copying files?

    Take a look on this, it may be helpful, http://www.percona.com/blog/2012/08/02/avoiding-sst-when-adding-new-percona-xtradb-cluster-node/

    You can make a Galera Cluster node as SLAVE of an existing MySQL which one will act as a MASTER as this is the best and recommended strategy to migrate from a not scaled/replicated environment to Galera Cluster. So, all the data that is written at the MASTER MySQL will be written as well to all Galera Cluster nodes. Test it before going production, ok?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.