'Replication' Tag

• Thoughts on MySQL 5.6 new replication features

  October 15, 2012

  After playing a little bit with MySQL 5.6 (RC), and following closely on Giuseppe's MySQL 5.6 replication gotchas (and bugs), I was having some thoughts. These are shared for a few reasons: Maybe I didn't understand it well, and someone could correct me Or I understood it well, and my input could be of service [...]

  posted in MySQL by shlomi

• MySQL 5.6 new features: the user's perspective

  October 5, 2012

  This is a yet-another compilation of the new MySQL 5.6 feature set. It is not a complete drill down. This list reflects what I believe to be the interesting new features user and usability -wise. For example, I won't be listing InnoDB's split of kernel mutex. I'm assuming it can have a great impact on [...]

  posted in MySQL by shlomi

• Notes on row based replication

  July 4, 2012

  MySQL's Row Based Replication (RBR) succeeds (though not replaces) Statement Based Replication (SBR), as of version 5.1. Anyone who is familiar with replication data drift -- the unexplained growing data difference between master & slave -- might wish to look into row based replication. On multiple servers I'm handling the change to RBR has eliminated [...]

  posted in MySQL by shlomi

• Auto caching INFORMATION_SCHEMA tables: seeking input

  March 8, 2012

  The short version I have it all working. It's kind of magic. But there are issues, and I'm not sure it should even exist, and am looking for input. The long version In Auto caching tables I presented with a hack which allows getting cached or fresh results via a simple SELECT queries. The drive [...]

  posted in MySQL by shlomi

• Problems with MMM for MySQL

  May 16, 2011

  I recently encountered troubling issues with MMM for MySQL deployments, leading me to the decision to cease using it on production. At the very same day I started writing about it, Baron published What's wrong with MMM?. I wish to present the problems I encountered and the reasons I find MMM is flawed. In a [...]

  posted in MySQL by shlomi

• Impressions from MySQL conf 2011, part III: BoF Replication

  April 19, 2011

  This post continues my impressions from some of the talks I've been to. I'll dedicate this post to a single session. Wednesday BoF: Replication, Lars Thalmann, Mat Keep (Oracle) Lars Thallman presented the MySQL 5.5 replication features, as well as the expected 5.6 features. Among other features, one could notice parallel replication, binlog checksums, sub-second [...]

  posted in MySQL by shlomi

• Recovering a MySQL `root` password: the fourth solution

  March 22, 2011

  Have just read Darren Cassar's Recovering a MySQL `root` password – Three solutions. There's a fourth solution: using an init-file, which leads to just one restart of the database instead of two. It also avoids the security issue involved with using skip-grant-tables. I've written all about it before on Dangers of skip-grant-tables. Darren's 1st advice [...]

  posted in MySQL by shlomi

• Upgrading to Barracuda & getting rid of huge ibdata1 file

  February 15, 2011

  Some of this is old stuff, but more people are now converting to InnoDB plugin, so as to enjoy table compression, performance boosts. Same holds for people converting to Percona's XtraDB. InnoDB plugin requires innodb_file_per_table. No more shared tablespace file. So your ibdata1 file is some 150GB, and it won't reduce. Really, it won't reduce. [...]

  posted in MySQL by shlomi

• openark-kit (rev. 170): new tools, new functionality

  December 15, 2010

  I'm pleased to announce a new release of the openark kit. There's a lot of new functionality inside; following is a brief overview. The openark kit is a set of utilities for MySQL. They solve everyday maintenance tasks, which may be complicated or time consuming to work by hand. It's been a while since the [...]

  posted in Development, MySQL by shlomi

• MMM for MySQL single reader role

  August 12, 2010

  The standard documentation and tutorials on MMM for MySQL, for master-master replication setup, suggest one Virtual IP for the writer role, and two Virtual IPs for the reader role. It can be desired to only have a single virtual IP for the reader role, as explained below. The two IPs for the reader role A [...]

  posted in MySQL by shlomi