… with large table and data sizes in MySQL can be painful, lacking online operations to alter table, defragmentation etc. Yes there are replication… to be significant difference between MySQL and Oracle deployments, yet as MySQL is getting better and better handling large scale systems (both in terms…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
…this works best for read intensive envinronments. Write scaling however can be real problem. Not moderate …write load growth by only 50%. – Delays in replication MySQL replication is fast which means in average delay is …update made it to them – this one has large overhead so should be used only for …
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. … of writes to large database size. This is one more reason why you might want to go with scale out and keep single server a box with few CPUs and few hard drives while running MySQL.
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
…Connection pools and persistent connections combined with a large number of application servers can lead to…you have a heavily sharded or otherwise horizontally scaled application, it’s not only easy to …t be a great OLTP web database too. MySQL replication is one of the core, fundamental features — …
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… caching or scalability issues MySQL could not solve well. There are inhouse and opensource solutions for tasks for large scale file storage, queuing… 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: 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… data loss. Many large websites that are fine with some data loss rely on replication for HA and for read scaling. In addition to hardware failure, the level of availability of this solution is affected by the availability of the MySQL replication…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… or a slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q… apply here, in large zabbix deployments, you may want to partition your large history tables, so… using MyISAM. Q: How does write performance scale with an increasing number of nodes? A: …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication… scale (ie attempt to scale replication)…MySQL replication with something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL replication…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… patches. 2. Be Scalable I’d like to see MySQL Scaling to large amount of CPUs for all storage engines all operation systems… not think MySQL Cluster would ever be that thing as it provides too strong guarantees. It is same as with MySQL Replication – the reason it is fast and has low performance overhead on the master is at large extent because…
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…
