… the CPU,IO and Network usage is below 10% of capacity – does it mean you can count on server being able… independently of traffic so it is fine to measure system capacity in Transactions per second. If system can handle twice amount… scalability. The Replication is perfect example in MySQL world. Slave executes replication stream in single thread which means it replication can’t scale…
Comment: Just how useful are binary logs for incremental backups?
July 22, 2009 By 6 Comments
… seems pretty good, especially the incremental capacity. Finally, as Peter mentioned, running replication anywhere near full capacity is asking for trouble. One thing… is to split events into different “channels” for replication in parallel. Parallel replication seems to be particularly helpful when you have events…
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
… pretty uniform, a slave that’s at 90% of its capacity to keep up with the master can be indistinguishable from… slave’s routine work gets closer and closer to its capacity, you’ll see these spikes get bigger and “wider”. The… to one-half the CONNECTED_TIME (because there are two replication threads on the slave) to see how much of the…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… easier to deal with. Recovering the data with replication you always have to keep replication positions in mind. Such if you recover… from backup. So this is just question of having decent capacity planning (such as being able to shut off 2 slaves… environments can be even more complicated – one may use partial replication, replication to different storage engine, add some tables beyond tables which…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… be a master or a slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I… in synchronous, and a disaster recovery location replicated asynchronously? A: You can use asynchrounous replication between 2 PXC clusters, with one node… it commits to another host, does that not limit write capacity to the “weakest link”. Or have i missed something? A…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… check on existing replication setup. As we’re checking replication consistency down the road we need to make sure replication is in sync… a tool to do it. It turned out replication indeed had an issue replicating triggers. The problem should be fixed by upgrade…-checksum can use replication to check consistency but comparing 2 servers directly is faster and we had a spare capacity which we…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… different modes on successive queries. Q: Is RBR faster replicating vs SBR replication? RBR is faster than statement based, correct? A: Often that’s true, Row-Based Replication (RBR) can be faster than Statement-Based Replication (SBR). But there are exception cases… other words, you end up multiplying work instead of multiplying capacity. Also, some care is necessary to work with this kind…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual replicate_do_dbblogpercona.commanual replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_rewrite_dbblogpercona.commanual replicate_same_server_idblogpercona.commanual replicate_wild_do_tableblogpercona.commanual replicate…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… shard your data properly so you would not have to replicate everything 
There are also cases when storage size becomes the… show search results which does not require too much IO capacity or high in memory fit. For large number of applications… for example these 50 drives will unlikely be helpful solving replication delay or speeding up this 3 hours reporting query or…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… provider. For large MySQL web MySQL installations using Sharding or replication IO needs are typically rather predictable. There are also often… disk enclosure does it great. My Advice for Scaling IO capacity with SAN (this applies to directly attached storage too) is… I would highly consider DRBD which can do storage level replication between directly attached volumes. Now with support for Dolphin Interconnect…
