… varchar column. This however does not work for pt-online-schema-change: root@smt2:~# pt-online-schema-change –execute –alter=”add column v varchar(100) not…
Post: Give feedback on a pt-online-schema-change update
March 14, 2012 By 4 Comments
…-online-schema-change. The outline of the changes I want to make is here: http://www.percona.com/docs/wiki/ptdev:blueprints:redesign-pt-online-schema-change…
Post: Percona Toolkit 2.1.9 is ready
February 15, 2013 By Leave a Comment
…-online-schema-change makes bad DELETE trigger if PK is re-created with new columns pt-online-schema-change 2.1.9 handles another case of changing the primary key. However, since changing the primary key is…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… slide 44 Slide 48 is the default output for pt-online-schema-change, ran as detailed on slide 47 Slide 57 is the… you get when first running pt-sift). Q: For pt-online-schema-change, does renaming the table take a long time, and what… you’re using innodb_file_per_table. Q: Does pt-online-schema-change work for fast index drops and creates? Yes, though you…
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… — and using this the node should be fully functional and online during the entire backup. Q: Can I run two Percona… using Galera’s rolling schema upgrade feature. If that won’t work with your change (i.e., your change will prevent replication from working if you only do it on some nodes), then I’d suggest pt-online-schema-change. Q…
Comment: KISS KISS KISS
March 1, 2009 By 7 Comments
… 
“Master-Master which you typically want for high availability and online schema changes.” Ahh, thanks for this tip, I never thought to address… when the schema change is expected to be fast and resources friendly, without large index creations) is the problem with InnoDB schema changes being…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
… versions 5.5.28 and newer: pt-table-chcecksum pt-online-schema-change pt-archive pt-mysql-summary pt-heartbeat pt-variable-advisor… the server or MySQL time zone. Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables. Since MyISAM tables…’t have foreign keys, and the tool uses the information_schema to find child tables, this could cause unnecessary load on…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… the new table schema, we failover to the slave and repeat the alter table on the other server. Those online schema change are easier… Can lose data Caches on failover slave are not cold Online schema changes Low impact backups Automatic failover with replication I already mentioned…
Post: Percona Toolkit version 2.1.6 released
November 15, 2012 By 3 Comments
… list of changes is on the Launchpad milestone for 2.1.6, but here are some highlights the release: pt-online-schema-change can now handle column renames pt-online-schema-change‘s DELETE trigger no longer fails when…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… upgrade, you still need to keep into account possible query changes, replication etc. Q: Is it possible to move MyISAM to… lot faster. You can also use pt-online-schema-change tool for online migration. Q: Should we change ROW replication to MIXED during Upgrade? I… resolved in all cases – sometimes queries just need to be changed or supplemented with hints to get to old execution plans…
