…_increment or change ENUM values. When it comes to changes that really require table to be rebuilt – adding/dropping columns or indexes, changing data… your overall database size, scope of changes, and few other variables though if you can’t use mmm_clone i.e. you don… if you’re not using MMM though it takes few more steps i.e. you must change application to use different IP for MySQL…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…IO at the time if Innodb or MyISAM tables are used. There is read-ahead functionality but usually…anyway. Yet another approach is to use MySQL replication with something as MMM or Flipper. I think …of semi-online MySQL/OS upgrades and Schema changes. Backups SAN has number of advantages for operations…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… master using the new table schema, we failover to the slave and repeat the alter table on the other server. Those online schema change are easier when a master to master topology is used. The following… on it recently. The architecture of a highly available setup using MMM and Master-Master replication is presented on the figure below…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…and offered a behavior pretty similar to MMM regarding Virtual IP addresses, VIPs, management. …use when setting up replication. It is also currently used for the ‘CHANGE MASTER TO’ command, something that should/will change… to run select count(*) on mysql.user table, so the user given should at …
Comment: Is DRBD the right choice for me?
July 8, 2009 By 17 Comments
… but also minimizing scheduling downtime needed. MMM allows much more here – ALTER TABLEs, MySQL Upgrades, Storage Engine changes etc. 2) Anders: The switch… mk-table-checksum before putting traffic back on it or simply reclone it from the slave using MMM. You also may resolve the changes…
Comment: Using MMM to ALTER huge tables
April 4, 2008 By 11 Comments
[...] huge queries to huge tables. On the MySQL performance blog, Aurimas Mikalauskas walks us through using MMM to ALTER huge tables. He writes, “When it comes to changes that really require table to be rebuilt – [...]
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…% Heartbeat/DRBD 99.9% NDB Cluster 99.999% From the table, if your requirements are for 99.99%, you are restricted… replication” and “Master-Master with MMM manager” Don’t use any special MyISAM feature All Can change MyISAM Full text to Sphinx All… summarized in the table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM manager Good…
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
… often; we have used it more for Maatkit and MMM than for server patches. But we hope that will change as more people… dinner where everyone brings something and puts it on the table. These builds are stamped with our name and are downloadable… the MySQL server, XtraDB, Maatkit, our InnoDB data recovery tools, MMM, innotop, or even projects like standard GNU utilities, we’re…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 4 Comments
… even replay those changes on slaves and hope it works out), re-clone it from the slave or use mk-table-checksum to find inconsistencies and re-sync them with mk-table-sync. Both of these… of some tools like MMM. Row level Replication makes it possible to identify the objects which were changed on the Master after…
Post: When should you store serialized objects in the database?
January 21, 2010 By 42 Comments
… full blob for 1 change, it is expensive. Another potential pro for this technique is that ALTER TABLE commands are no longer… table require the whole table to be rebuilt (now just the index is built). I don’t really buy this pro, since using… index adds. Projects like MMM and Flipper make this even easier. In Friendfeed’s case, they also used the serialization to be…
