Forum Stats

  • 3,733,360 Users
  • 2,246,748 Discussions
  • 7,856,667 Comments

Discussions

innodb cluster vs master - slave replication

3770300
3770300 Member Posts: 7
edited March 2019 in MySQL Community Space

Want to know advantages and disadvantages of innodb cluster over the master - slave replication.

3770300

Best Answer

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 350 Employee
    edited March 2019 Accepted Answer

    High availability is the foremost reason.  In traditional semi-sync and async replication, if the master goes away for any reason you are unable to write data.  InnoDB Cluster will detect a failed master and promote another system to replace it.

    3770300

Answers

Sign In or Register to comment.