One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… be a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
…of the most painful things anyone experiences with MySQL is significantly alleviated. If you’ve ever …to be scheduled in the dead of the night on Sunday, and required overtime and time … it is replication-aware and inspects replicas, throttles its operation to avoid causing replication delay, watches …
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
… before, they are interested in all kinds of plugins, replicating from MySQL to Cassandra and doing other cool stuff. Some of this… they are ready to take a risks and spend sleepless nights troubleshooting issues as they come across. There are also people… with MyISAM tables but they would not actually roll back ? Replication which can get broken by Server Crash ? A lot of…
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 transactions on the slave… update for them so we can’t simply update them nightly using batch job. What to do in this case ? First… MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or simply the database which is not replicated…
Comment: Master-Master or Master with Many Slaves
April 7, 2007 By 7 Comments
… copies of everything. This way if a machine failed at night you still have a redundant copy. If it’s 1AM… application error which deletes/trashes all the data and gets replicated to all the slaves ?” Sure… but this is a non… to handle much more write load. Especially keeping into account MySQL replication is single thread it might be not long before it…
Post: Getting History of Table Sizes in MySQL
December 8, 2010 By 13 Comments
….TABLES; I put it to the cron to run nightly as: 1 0 * * * mysql -u root -e “INSERT INTO stats.tables SELECT… see how evenly data is distributed among shards etc. In replicated environment you should put this cron on Master only. If you use statement based replication it will automatically pick up sizes and even different tables…
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
… forms of scripting, implementation (writing queries), hands on setting up MySQL, Replication, Monitoring, High Availability with MMM or DRBD are good examples… is when there are multiple groups or multiple applications using MySQL – in such case each of the problem areas/groups can… easier to do work which needs to be done at night hours. Remote work however also needs to be well organized…
Post: New Presentations published (Meetup and Highload)
November 7, 2008 By 1 Comment
… presentation pages – we’ve added the presentation on MySQL Scaling by Sharding and Replication as well as Russian Language presentations I’ve… and New Features (Russian), Scaling MySQL-powered Web Sites by Sharding and Replication (Russian), Wonderful World of MySQL Storage Engines (Russian). Now some… this year because I just arrived from the US the night before and so was rather tired to do my presentations…
Comment: Why you can't rely on a replica for disaster recovery
August 1, 2010 By 25 Comments
… then turn off replication and take a dump of nightly. We’ve been toying with the idea of delayed replication, such as Joseph… cronjob script that toggles replication in some sort of estimated manner. But until they add that feature to MySQL proper, it’s…
Comment: Master-Master or Master with Many Slaves
April 9, 2007 By 7 Comments
…. What is often misuse is having 10+ slaves replicating 500GB database. Regarding good night sleep, well it depends a lot on number… being down so many times I think it is not MySQL related at all. “Sure… but this is a non sequitor… when. To often however people use too many slaves using replication Instead of partitioning. By the way, how many shards do…
