Versions Compared

Old Version 9

changes.mady.by.user Damodar Reddy T

Saved on

compared with

New Version 10

changes.mady.by.user Damodar Reddy T

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • It does not support any DB HA out of the box, we can use Galera with it but the same can be used with Mysql directly

    h3

    Percona Xtra DB

  • It has the following limitations
    http://www.percona.com/doc/percona-xtradb-cluster/limitation.html

    MHA

  • It is very hard to install this and also need to write our own scripts to switch between master and slave either using VIP concept or some other way of LB

    Mysql Active/Active Setup

    We can use Mysql's 2-way replication (Master-Master replication setup) along with connector's configuration to read/write data from one of the slave if master goes down.
  • It worked well with 2 nodes(master - master) set up for both fail over and fall back
  • Need to verify the same for more than 2 nodes set up using chain replication with first 2 nodes as cyclic pointers for master/slaves and remaining are chain replication strategy starting from 2nd node.