Brian Aker recently published good write up about using MySQL replication. The piece I find missing however is good description of … Brian writes this works best for read intensive envinronments. Write scaling however can be real problem. Not moderate increase of write… times if write load growth by only 50%. – Delays in replication MySQL replication is fast which means in average delay is small. Typically…
Post: Making MySQL Replication Parallel
January 30, 2007 By 1 Comment
Kevin Burton writes about making MySQL Replication Parallel. Many of us have been beaten by the fact MySQL Replication is single threaded so in… applications Parallel Replication could be implemented simply by filtering transactions and writing to number of binary logs. If you’re “Scaling Out…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
Jeremy Cole recently posted very nice post about MySQL Replication Performance. There are however few points I should comment on. …. I also should mention this covers only Master overhead of Replication. Slave is where you can expect more problems, especially on… want to go with scale out and keep single server a box with few CPUs and few hard drives while running MySQL.
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… both MySQL does not crash under your load as well s it scales well. There have been number of scalability bugs in MySQL… you want to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup slave with new version… possible as MySQL only fully support slaves newer than the master. Older slaves may have issues unable to interpret new replication stream…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with… instances. When you have a heavily sharded or otherwise horizontally scaled application, it’s not only easy to get into this…, it wouldn’t be a great OLTP web database too. MySQL replication is one of the core, fundamental features — and it’s…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
There are interesting posts these day about future of MySQL Replication by Brian Frank and Arjen. I think it very interesting … cross shard queries become a pain. Dealing with lag in MySQL Replication is another issue which complicates application development. All of it… running fast and Scalability on the scale of Big Table with Map Reduce. Indeed I think MySQL Replication usage will reduce, but I…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… a poor choice as it did not allow to scale (ie attempt to scale replication) or was a poor choice, with adding memory… use MySQL replication with something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL replication is a showstopper) and it also solves the other big pain of semi-online MySQL/OS upgrades and…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… MySQL, replication. High Availability solution for MySQL: Replication This HA solution is the easiest to implement and to manage. You basically need to setup MySQL replication… read scaling. In addition to hardware failure, the level of availability of this solution is affected by the availability of the MySQL replication…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… used together with MySQL is Scale Out, but to say the truth MySQL does not provide much of the functionality for scale out itself, besides its fast and simple replication. You still… not think MySQL Cluster would ever be that thing as it provides too strong guarantees. It is same as with MySQL Replication – the…
Page: Consulting for MySQL
July 31, 2006 By
…MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL Replication consulting including chained and circular replication, bi-directional replication, troubleshooting MySQL Replication…
