Checking throughput with async MySQL replicationReplication throughput is the measure of just how fast the slaves can apply replication (at least by my definition). In MySQL async replication this is important to know because the single-threaded apply nature of async replication can be a write performance bottleneck. In a production system, we can tell how fast the slave is currently running (applying writes), and we might have historical data to check for the most throughput ever seen, but that doesn’t give us a solid way of determining where we stand right NOW().
I’ve been talking to some smart people about deployment. First a little background. One of my colleagues was working on a project that ultimately didn’t bear fruit. It was a system for continuous delivery, and involved reacting to
git push by building and shipping to production.
Here’s a problem some or most of us have encountered. You have a latin1 table defined like below, and your application is storing utf8 data to the column on a latin1 connection. Obviously, double encoding occurs. Now your development team decided to use utf8 everywhere, but during the process you can only have as little to no downtime while keeping your stored data valid.
GUI monitoring tools for MySQL are not always suitable for all our needs or situations. Most of them are designed to provide historical views into what happens to our database over time rather then real-time insight into current MySQL server status.
A week ago we launched our first GA release of href="http://www.mysqlperformanceblog.com/2013/10/07/percona-server-5-6-13-61-0-first-ga-release-is-now-available/">Percona Server 5.6 and it’s a real game-changer for us. The release of Percona Server 5.6 (our enhanced, drop-in replacement for MySQL) not only provides stability and performance but also provides key features only available in Oracle’s MySQL 5.6 Enterprise Edition. As usual, Percona Server 5.6 is 100 percent Free and Open Source Software.
Percona is glad to announce the release of href="http://www.percona.com/software/percona-monitoring-plugins/" target="_blank">Percona Monitoring Plugins 1.0.5. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts.
class="aligncenter size-full wp-image-14616" alt="cacti-graph-set" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/04/cacti-graph-set.png" width="650" height="400" />