…compared with this baseline to see how they are affected and how the system scales with increasing …MySQL 5.6 brings some abilities of parallel replication but these apply only to some use cases. Many database…most cases is seen when the system is overloaded and suffering. So what is the problem with…
Post: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
…database overload for the customer recently I have found about 80 copies of same cron job running hammering the database…starting again) or using GET_LOCK function in MySQL. The second one is good if you …time. Create the table in the database and store information about how long cron took to run. …
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
…complex situations which happen with databases such as performance problems,…might have limited information about how exactly things are set…overloaded and “goes down”. As we fail over another server goes down with overload…MySQL such as Clustrix, Tungsten Replicator, PRM, Percona XtraDB Cluster, MySQL…
Post: How to generate per-database traffic statistics using mk-query-digest
September 16, 2009 By Leave a Comment
… a subset of the databases to a different physical host when the existing host begins to get overloaded. But MySQL doesn’t allow us to examine statistics on a per-database basis. Enter Maatkit. There… is to migrate a database to a different server, you know exactly which database to move (db3) and how much room that will…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… your scaling path – it becomes very easy to overload the replication, especially as it has to serialize… we learned it can be quite nasty, so how can we deal with this problem ? I …MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or simply the database…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… of the node and do not send new requests to overloaded node as well as use other techniques which keep the… how Synchronous Replication solutions such a Percona XtraDB Cluster and MySQL Cluster are different. Synchronous replication essentially allows you to work with database nodes (SQL nodes for MySQL Cluster) in…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
…during my visit to Open Source Database Conference in November so I …like to see how many connections and queries page generated and how long they …be able to respond with “system overloaded try again later” message. Exceptions …to run multiple queries for multiple MySQL connections at once. For scale …
Post: Web Site Optimization: FrontEnd and BackEnd
June 26, 2008 By 12 Comments
… but rather optimization on the client side – how to make a browser to do less requests…your load your web site can simply get overloaded and die. Remember all these “slashdotted” or “techcrunched…10% fetching data from MySQL database it does not make sense to focus on MySQL optimization. If 90% …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… > approach. The great things about objects is you can easily overload > methods and get debugging and profiling tools, as well as… told by people with traditional database background. > Things are different with MySQL. Good design will help dictate how many tables are required in…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 15 Comments
…/10/16/finding-your-mysql-high-availability-solution-%e2%80%93-the-questions/. I am not sure how many nines it will…. So if one node gets overloaded and performance degrades, the same happens with whole cluster. – Heterogeneous-database replication. It is not here…, but group manager protocol in Galera is database independent, and it’s only matter of database drivers. For InnoDB currently it is…
