asked on

MySQL HA and DR solution.

hi,

any one can tell me what is MySQL Fabric, MySQL Router and MySQL Shell is ?

can MySQL use replication and mirroring ?

what about the master/master and master/slave mode, any topology diagram to explain all that above?

since what version MySQL has Fabric, MySQL router and MySQL shell ?

ASKER CERTIFIED SOLUTION

Ray Paseur

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marrowyung

ASKER

it seems more on HA and DR, it has a lot of relationship to cluster/master-slave database architecture, right?

any good link you can tell and educate me about MySQL cluster/master-slave database architecture?

MySQL has master-master architecture, is that right?

marrowyung

ASKER

I also read this one:

http://www.compassitesinc.com/blog/distributed-database-architecture-using-mysql-replication/

and I am not sure why in the diagram, the slave can send update to master, in MySQL slave is read only, right?

Also Master-Master replication, allow read/write on more than 2 nodes at the same time, right? what is the maximum number of nodes can join this relationship? is it just like merge replication which both side can updates each other,

this Master-Master replication should still have the across site network issue as merge replication, right? that's why there are Percona XtraDB Cluster, right?

marrowyung

ASKER

any more commend expert ?

marrowyung

ASKER

tks.