We have a current XtraDB Cluster of 7 nodes
what i would like to do is set up another cluster of 3 that is for development/testing that is one way synced with production. Is there any way I can do with with Percona Xtradb? I figure someone out there in TV land has a setup like this, just cant for the life of me figure out how to set it up. Any clue x 4’s would be appreciated! thanks.
You can still use MySQL asynchronous replication to feed dev cluster from production cluster. Just enable binary logging on one of the production nodes, then create a consistent backup from this node to use for provisioning first dev node. You have to enable log_slave_updates on slave dev node in order to properly replicate into it’s cluster.
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2024 Percona LLC. All rights reserved.