… application error which deletes/trashes all the data and gets replicated to all the slaves ?” Sure… but this is a non… to handle much more write load. Especially keeping into account MySQL replication is single thread it might be not long before it… their database caches. You can partially improve it by load partitioning but still it will not be perfect – for example all…
Comment: Thoughts on MySQL Replication
July 16, 2006 By 18 Comments
… addition to MySQL replication, however it is not alternative if you’re also looking for increased performance, not only high availability. Partitioning on… still end up with partitioning and having different languages in different replication groups otherwise at some point in time replication will not be…
Comment: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… (it replicates, but doesn’t store the data anywhere) and participates in the quorom protocol if there are network partitions or node….ignore_sb option. With that enabled, if you have network partitioning, then both nodes will continue to operate independently. You can… slave promotion issues like you have with MySQL replication, but Galera is still better than MySQL replication so it is not totally stupid to…
Comment: Flexviews is a working scalable database transactional memory example
May 19, 2011 By 3 Comments
… balancing – my last proposal for the future of the PHP replication plugin….What?…Think of a global transaction ID as a… ….Dear MySQL database administrator please drop us a note if you want this to be implemented in the PHP plugin! Partitioning itself… compared to disk i o overheads.In MySQL 5.0 or earlier versions where range partitioning is not supported creating daily weekly…
Comment: Master-Master or Master with Many Slaves
April 9, 2007 By 7 Comments
… other benefits. What is often misuse is having 10+ slaves replicating 500GB database. Regarding good night sleep, well it depends a… being down so many times I think it is not MySQL related at all. “Sure… but this is a non sequitor…. To often however people use too many slaves using replication Instead of partitioning. By the way, how many shards do you have…
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
… for the analysis.. Have created a test table with the partitions@ described. Also, modified indexes –> 1 index (ObjectClass, Timestamp), PK –> (ObjectClass… in the same group ). This base mysql version (5.1.56) supports partitions, but does not support partition pruning. 3. The records in… in chronological order of timestamp. 4. The underlying disk partition is DRBD, with replication to a second standby server for failover.. (This…
Comment: MySQL Partitioning - can save you or kill you
July 2, 2012 By 45 Comments
… –> This section discusses an optimization known as partition pruning, which was implemented for partitioned tables in MySQL 5.1.6 So, to test, I tried selects with the first where clause using partition column… the two nodes mentioned above b) InnoDb/MyISAM on the replicated DRBD partition on these two nodes. (This is what we have…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… functional partitioning or something else. Complex Replication There are impressive numbers out there on how many slaves people run and how complex replication… the availability of the application is only related to the MySQL redundancy for very high quality/high scale applications. I’ve…
Post: Why you can't rely on a replica for disaster recovery
July 31, 2010 By 25 Comments
… a nutshell, the client used SAN block-level replication to maintain a standby/failover MySQL system, and there was a failover that… of errors, including warnings about accessing data outside of the partition boundaries. We were eventually able to coax the filesystem into… replication. DRBD would behave just the same way. At a higher level, MySQL replication has the same weakness. If you rely on a MySQL…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… @Todd: Replication are two different ways of replicating data, from my experience, DRBD is more reliable than replication. ….7 Only true if the schema is not partitioned correctly. I have worked with NDB having …use SSL between your application servers and your MySQL servers? 2.9 Good point and yes, …
