'MySQL' Category

  • 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. […]

  • Introducing Propagator: multi-everything deployment made easy

    March 11, 2014

    I'm happy to release Outbrain's Propagator as open source. Propagator is a schema & data deployment tool which makes it easy to deploy, review, audit & fix deployments to your database servers. What does multi-everything mean? It is: Multi-server: push your schema & data changes to multiple instances in parallel Multi-role: different servers have different […]

  • Speaking at Percona Live: common_schema, MySQL DevOps

    March 10, 2014

    In less than a month I'll be giving these two talks at Percona Live: common_schema: DBA's framework for MySQL If you are still unfamiliar with common_schema, this will make for a good introduction. I'll give you multiple reasons why you would want to use it, and how it would come to immediate use at your […]

  • Percona Live - call for "Hall of Shame" talks

    March 8, 2014

    We've got some spare time on Percona Live during the lightning talks session, and are spontaneously calling for "Hall of Shame" submissions. What is this about? We just had a wonderful Reversim Summit a couple weeks back, where we held the "Hall of Shame" session. We are used to hear talks about success stories and […]

  • mycheckpoint, discontinued

    March 6, 2014

    Time to admit to myself: mycheckpoint has to be discontinued. I started mycheckpoint back in 2009, as a free & open source lightweight monitoring tool for MySQL. Over some years it evolved and became an actual (lightweight) monitoring solution, used by many. It has a unique and original design, which, alas, is also its bane. […]

  • The "once and for all" SHOW SLAVE STATUS log files & positions explained

    March 6, 2014

    True, GTID is upon us whether via MySQL 5.6 or Tungsten Replicator (and wasn't it in Google Patches since 2009?). But some of us are still using standard replication with MySQL 5.5, and the "what's with all these binary log files and positions" question is ever erupting. The output of SHOW SLAVE STATUS confuses people […]

 
Powered by Wordpress and MySQL. Theme by openark.org