GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Regular MySQL as master, Percona as slave?

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

  • Regular MySQL as master, Percona as slave?

    Hi,

    I want to try Percona server, and the best way I can think of is to replicate my production mysql server with Percona. Basically, I want to use regular mysql server as master and use the percona server in dev environment as slave, and have it replicate this.

    Is this configuration possible? Is there any pointers for this?

    Thanks a lot..

  • #2
    Percona server is compatible with MySQL server, so you can setup the replication using the tutorials from the mysql website or you can use xtrabackup for example.

    It is always recommended to run mysql_upgrade to update the system tables if you are going to copy the datadir or make an the replication with xtrabackup.

    Regards,

    Martin Arrieta
    @martinarrietac

    Comment

    Working...
    X