• When you cannot replicate from master M to slave S

    April 28, 2014

    Working on some replication topology automation, here are some rules that will prevent you from replicating from a MySQL server M to a slave S: M does not have binary logs (log_bin) enabled M is itself a slave and does not have log_slave_updates enabled M has a higher major version than S (e.g. M is […]

  • The mystery of MySQL 5.6 excessive buffer pool flushing

    April 20, 2014

    I'm experimenting with upgrading to MySQL 5.6 and am experiencing an unexplained increase in disk I/O utilization. After discussing this with several people I'm publishing in the hope that someone has an enlightenment on this. We have a few dozens servers in a normal replication topology. On this particular replication topology we've already evaluated that […]

  • Monitoring DML/slow queries with graphite

    April 19, 2014

    pt-query-digest, Anemometer or "Anemomaster" do a great job of analysing your queries and giving you visibility into what's going on with your MySQL servers. However, the place where the query digests are written is just some MySQL tables on some server. Do you have monitoring/alerts on that table? How will you verify a specific query […]

  • "Anemomaster": DML visibility. Your must-do for tomorrow

    April 18, 2014

    Here's our take of master DML query monitoring at Outbrain (presented April 2014). It took a half-day to code, implement, automate and deploy, and within the first hour of work we managed to catch multiple ill-doing services and scripts. You might want to try this out for yourself. What's this about? What queries do you […]

  • Some anecdotes I learned at Percona Live

    April 8, 2014

    While on the plane back home I wrote down all my impressions from Percona Live 2014. Have lots of TODOs and great ideas to implement. Among all my impressions, there were a few anecdotes worth noting. 5.6 GTID is still unfriendly. It will require complete shutdown & reconfiguration of your entire replication topology; and some […]

  • MySQL Community Awards 2014: the Winners

    April 4, 2014

    The MySQL Community Awards initiative is an effort to acknowledge and thank individuals and corporates for their contributions to the MySQL ecosystem. It is a from-the-community, by-the-community and for-the-community effort. The committee is composed of an independent group of community members of different orientation and opinion, themselves past winners or known contributors to the community. […]

 
Powered by Wordpress and MySQL. Theme by openark.org