'MySQL' Category

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

  • MySQL Community Awards 2014: Call for Nominations!

    February 9, 2014

    The 2014 MySQL Community Awards event will take place, as usual, in Santa Clara, April 2014, during the Percona Live MySQL Conference & Expo (currently scheduled at Thursday, April 3rd 2014). The MySQL Community Awards is a community based initiative. The idea is to publicly recognize contributors to the MySQL ecosystem. The entire process of […]

  • Why delegating code to MySQL Stored Routines is poor engineering practice

    February 6, 2014

    I happen to use stored routines with MySQL. In fact, my open source project common_schema heavily utilizes them. DBA-wise, I think they provide with a lot of power (alas, the ANSI:SQL 2003 syntax feels more like COBOL than a sane programming language, which is why I use QueryScript instead). However I wish to discuss the […]

  • Seconds_behind_master vs. Absolute slave lag

    January 24, 2014

    I am unable to bring myself to trust the Seconds_behind_master value on SHOW SLAVE STATUS. Even with MySQL 5.5's CHANGE MASTER TO ... MASTER_HEARTBEAT_PERIOD (good thing, applied when no traffic goes from master to slave) it's easy and common to find fluctuations in┬áSeconds_behind_master value. And, when sampled by your favourite monitoring tool, this often leads […]

 
Powered by Wordpress and MySQL. Theme by openark.org