…thought provoking Birds of a Feather sessions on Tuesday night and the Wednesday night Community Networking Reception will be fun and …Topic: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” Luís Soares, Senior Software Engineer, Oracle Topic: “MySQL 5.6: Redefining Replication” …
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
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: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
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: Here's a quick way to Foresee if Replication Slave is ever going to catch up and When!
August 29, 2012 By 11 Comments
… often happen in our consulting practice: sometimes replication would break and then it needs to…instant, Batch jobs: some sites would run nightly tasks like building statistics tables or table checksum… that something in awk: delay=60 cmd=”mysql -e ‘show slave status\G’ | grep Seconds_Behind_Master …
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 10 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: 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…
