… faster for IO Bound Index scans and large range scans. We surely should benchmark this aspect…as bunch of others due to statement level MySQL Replication which among other requirements, needs all auto-… should also mention Paul Tuckfield Keynote about Scaling Innodb at YouTube. There were many other …
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
…most cases I would recommend automated failover for large systems only. If I’m looking not … are very good. When we apply them to MySQL replication we can use these simplified principles – we only…pilot is a good approach for larger scale systems. Interested in MySQL and High Availability ? Come to …
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… Billions of documents with MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and Sphinx. This…MySQL – Innodb, Falcon, SolidDB, PBXT and analyzing how things have changed since last summer. Using Slave Server Without Breaking User Experience MySQL Replication…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0…. I have never seen this approach scale well. Use The Best Technologies You Can MySQL is not the end-all and be… of some of the tactics I’ve used to successfully scale large click-processing and other types of event-analysis databases. In…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… establish replication mainly to be able to fail over if there are problems. Over time application still will be limited by MySQL… go ahead and implement memcache, sharding, replication or other techniques which allow you to scale out to the several boxes. If you… large scale application you have the more time and effort you should spend on optimization. Same often applies to HA as higher scale…
Post: Scaling: Consider both Size and Load
July 13, 2010 By 5 Comments
… – This is probably the most obvious one. MySQL (and systems in general) do not scale perfectly with numbers of CPUs and number…. The Replication is perfect example in MySQL world. Slave executes replication stream in single thread which means it replication can’t scale for large amount of…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… and start building multi level support systems to handle large volumes but that is surely not the plan for … MySQL and LAMP systems in general, LAMP performance optimization, replication and high availability, scaling, writing whitepapers, helping people with data recoveries, implement MySQL…
Post: Upcoming Webinar "Managing Big Data with Percona Server, XtraBackup and Tungsten"
February 2, 2011 By 3 Comments
… Percona Server, XtraBackup, and Tungsten to manage Terabyte+ databases and scale to millions of transactions a day. We’ll discuss the… backup, restore, and provisioning of large data sets, and how to replicate scalably and safely using Tungsten Replicator with parallel apply. Bring your…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… writes, slower blob handling, concurrency issues, problems dealing with very large number of tables, slow data load and ALTER TABLE and… way too much time to do restore for Innodb. On large scale installations mysqldump does not work anyway but it may still… the MySQL server – in particular Optimizer may have harder time because costs between storage engines may not be well balanced or replication…
Comment: Thoughts on MySQL Replication
July 16, 2006 By 18 Comments
…. DRBD makes great addition to MySQL replication, however it is not alternative if you…replication groups otherwise at some point in time replication will not be able to keep up. This would of course require very large… it is conceptually very good for scaling. The traffic must be reads in astinishing…
