Announcement

Announcement Module
Collapse
No announcement yet.

Setting up a development environment

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Setting up a development environment

    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.

  • #2
    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.

    Comment

    Working...
    X