… the ALTER isn’t written to the bin-log and thus isn’t replicated, why ? without any replication filters or relevant args, the replication breaks reliably on the __tmp_x table why ? The first question sounds like a potential MySQL…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… ALTER large tables with no blocking or downtime. As you know, MySQL locks tables for most ALTER operations, but pt-online-schema-change performs the ALTER… key is that it is replication-aware and inspects replicas, throttles its operation to avoid causing replication delay, watches for load on…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… believe is ability of MySQL to use powerful system (including powerful storage) – Is quite limited with single thread replication as well as… with large table and data sizes in MySQL can be painful, lacking online operations to alter table, defragmentation etc. Yes there are replication based and…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…MySQL, replication. High Availability solution for MySQL: Replication This HA solution is the easiest to implement and to manage. You basically need to setup MySQL replication…that with MySQL, altering a table means recreating the whole table and it is a blocking operations. Altering a large table …
Post: Converting Character Sets
March 17, 2009 By 16 Comments
… TABLE `t1` ( ->Â Â `c1` text NOT NULL -> ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.02 sec) mysql> ALTER TABLE… force a reload of data on every server in the replication chain (very time/bandwidth/disk space consuming). Except for Approach… they need to be. Consider the following ALTER statement against the table in Approach #1: ALTER TABLE `t1` DEFAULT CHARSET=utf8, MODIFY COLUMN `c1…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right… add more tables to be replicated to the slaves. Another issue is of course creating and altering tables. If you have Innodb tables you’re…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…If our stored procedure write data to our tables the queries inside the procedure get logged… in this case we alter every event adding DISABLE ON SLAVE. ALTER EVENT even_name DISABLE …used variables are replicated on the slave. Example: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql> insert into…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… require table to be rebuilt – adding/dropping columns or indexes, changing data type, converting data to different character set – MySQL master-master replication… assigned to db1 at this stage. If you’re altering gigabyte size tables, this step may take some time. Go get a… replication mysql> START SLAVE; db1 will receive the updates that were executed by changes.sql or some other script and rebuild its tables…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
…MySQL Replication goes in single thread it is enough for one statement to get stuck to have all replication stalled. Long Queries – MySQL Replication …0 before you run ALTER TABLE query. Replication Overload Many tutorials out where will give you impression problem with replication starts only when …
