Timeline for Active-active Cluster In MySQL
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 10, 2016 at 9:25 | vote | accept | tesla747 | ||
| Aug 20, 2015 at 4:06 | comment | added | Michael - sqlbot | @tesla747 "master/master" is circular, as described above, though could refer to a ring of 2 or more masters, in a circle. Multi-master has been used to describe the same thing (circular/ring), but depending on context, it is likely to refer to fan-in replication, where one slave is a slave to two or more masters, and those masters are totally unaware of each other and have no conflicting schema+table identifiers among them, also called multi-source. MariaDB implemented this first, and now Oracle is trying to catch up, introducing it in MySQL 5.7. | |
| Jul 26, 2015 at 8:13 | comment | added | tesla747 | what is the difference between master-master replication and multi-master replication? | |
| Jul 19, 2015 at 17:57 | comment | added | Michael - sqlbot | @tesla747 you are correct. | |
| Jul 19, 2015 at 14:52 | comment | added | tesla747 | Got it, so if I'm using InnoDB as the storage engine for my application, then I cannot go for NDB cluster right? Correct me if I'm wrong. | |
| Jul 19, 2015 at 14:21 | comment | added | Michael - sqlbot | NDB Cluster is synchronous, but it's its own different product, it's not "Standard MySQL behavior + Synchronous Replication" which is what PXC and MariaDB essentially provide, with Galera. There are arguments on both sides of the MariaDB/Percona preference debate, which are not on topic here, but I suggest that of those two is more likely to fit what you want than NDB, because unlike them, NDB is not a drop-in replacement for MySQL Server, and has a smaller set of applications and environments to which it is suited. | |
| Jul 19, 2015 at 5:09 | comment | added | tesla747 | Brilliant Michael, some more info would clear my doubts. 1. Only Galera provides true sync replication? Isn't there 'synchronous' replication option with native MySQL NDB cluster? 2. And I would be going for 3 node active-active cluster what are the cons in MySQL Cluster (whichever version that is) that would want me to go for PXC? | |
| Jul 19, 2015 at 4:37 | history | answered | Michael - sqlbot | CC BY-SA 3.0 |