…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: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
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: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 10 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: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 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 …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… for MyISAM tables by separate phase of building Indexes ? Will be UNIQUE indexes built by sorting in case of ALTER TABLE (the big Gotcha for MyISAM tables). Are there any plans to be able… happening to the same table. This was born same as bunch of others due to statement level MySQL Replication which among other requirements…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system… – if you push heavy ALTER TABLE through replication they will surely get your replication capacity down for their duration…
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… adding/updating mysql user accounts replicated? Yes, provided you use CREATE USER or GRANT. DML on the mysql.* tables directly will not be replicated unless… humongous ALTER TABLE? Does it run one at a time in cluster and won’t affect overall availability? As I said, some ALTER TABLE…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…, it doesn’t save you from the downtime caused by ALTER TABLE — a typical reason to think about master-master with failover… archiving data can be dramatic. Take It Easy On Replication Building aggregated tables is hard work for the database server. If… use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… of my favorite MySQL configurations for high availability is master-master replication, which is just like normal master-slave replication except that you… fast failover and a bunch of other benefits (non-blocking ALTER TABLE, for example). The benefit is that you have another server…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…67974, which caused server crash on concurrent ALTER TABLE and SHOW ENGINE INNODB STATUS. Bug fixed … line option innodb_changed_pages_limit. MySQL option handling would then shadow the …replication events for a table that is present only on slave server while there are updates on the replicated table…
