• Getting rid of huge ibdata file, no dump required, part II

    May 30, 2012

    This post continues Getting rid of huge ibdata file, no dump required, part I, where I describe way of converting your single-tablespace InnoDB database into a file-per-table one, without the pain of exporting and importing everything at once. In previous part we put aside the issue of foreign keys. We address this issue now. What […]

  • Getting rid of huge ibdata file, no dump required

    May 22, 2012

    You have been told (guilty as charged), that the only way to get rid of the huge InnoDB tablespace file (commonly named ibdata1), when moving to innodb_file_per_table, is to do a logical dump of your data, completely erase everything, then import the dump. To quickly reiterate, you can only delete the ibdata1 file when no […]

  • Impact of foreign keys absence on replicating slaves

    May 14, 2012

    In this post I describe what happens when a slave's Foreign Key setup is different from that of the master. I'm in particular interested in a setup where the slave has a subset of the master's foreign keys, or no foreign keys at all. I wish to observe whether integrity holds. Making the changes Which […]

  • Webinar review: Zero-Downtime Schema Changes In MySQL

    May 3, 2012

    Yesterday I attended the Zero-Downtime Schema Changes In MySQL webinar by Baron Schwartz, Percona (do you say "attended" for something you listened to from your home office?) I was keen to learn about possible enhancements and improvements of pt-online-schema-change over oak-online-alter-table. Here are my impressions: The base logic of pt-online-schema-change is essentially the same as […]

  • Installing MySQL from source/binary tarball as a Linux service

    May 1, 2012

    I've written before I prefer to do a manual install of MySQL over a repository one. I still do: I typically install from binary tarball or by compiling from source. I'd like to share my setup procedure for Linux installation and service setup. I've done this dozens of times, on different Linux flavors, and it […]

Powered by Wordpress and MySQL. Theme by openark.org