… clarify my position a bit. For Many applications level of Master-Master reliability is enough + backup of course. Second I’m not…. Each shard has a single master and two slaves that can be promoted to master. We can just create as many shards as we… Master-Master you have 2 copies of data with Master-20-slaves you would have 21 copies which is significant waste. Speaking about Shards…
Comment: Master-Master or Master with Many Slaves
April 7, 2007 By 7 Comments
…’ it? We use shard and partition our data so we spread writes this way. Each shard has a single master and two slaves that can be promoted to master. We can just create as many shards as we… 12GB effective cache on the master-N-slave configuration compared to 36GB of effective cache on 3 master-master pairs.” Again. This seems…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… master. Finally as you have your slave running on new MySQL version you want to promote it to the master and upgrade Master… run into some serious issues with Master. In many cases you can leave the ex-Master as a slave so you can… in case you’re having Sharded envinronment you often approach things a bit differently – upgrading one shard with full validation and when…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…’re quite likely beyond reasonable use of single master and should have done sharding functional partitioning or something else. Complex Replication There… the simplified case – you got pair of servers replicating as Master-Master which you typically want for high availability and online schema…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… things that seem “less advanced” than using a database. Sharding and Partitioning Sharding is inevitable if your write workload exceeds the capacity… caused by ALTER TABLE — a typical reason to think about master-master with failover and failback for maintenance. As with anything, it…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… list the most common ones: – MySQL replication with manual failover – Master-Master with MMM manager – Heartbeat/SAN – Heartbeat/DRBD – NDB Cluster These…” and “Master-Master with MMM manager” otherwise, you can only consider the other three solutions. Data 100% safe MySQL replication no Master-Master with…, if you are planning for a growth that will need sharding (splitting the database over multiple servers), then you might need…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… features out of the box started deploying their custom solutions – Sharding and Caching. Indeed Memcache is the most known caching technologies… box even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD or SAN based HA architectures all have their…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… “liability” of compex replication tree setup. On the contrary sharded master-master pairs (or master with few slaves) are much easier to deal with… have master or relay binary log corruption. Master or Slave running out of space, Slave crashing (and loosing its position on master), Replication…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…? PZ: Indeed using master-master setup and switching roles is a good way to get large data manageable. MySQL Master Master Manager can help you to automate it a bit. I also like to keep tables small enough, “sharding” to…
Comment: Sharing an auto_increment value across multiple MySQL tables (revisited)
October 28, 2010 By 7 Comments
@Jason – it’s more useful for sharded environments than master/master. In my post I carefully tiptoed around ‘when to use it’, since there are a lot of cases I’ve seen this done for all the wrong reasons. I just wanted to demonstrate if you do use it – here are the performance characteristics.
