… are still in the relay log, they are just applied. Then written with their server-id on the binary log, and the slaves…): mysql> stop slave; Step 2: there are writes on the active master, the loop statements are also replicated from the relay-log but… was the loop of events from server-id 2? # mysqlbinlog mysql-relay-bin.000x | grep ‘id 2′ | sort | uniq Special thanks to…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
… (Yasufumi Kinoshita) Old system variable innodb_overwrite_relay_log_info was renamed to innodb_recovery_update_relay_log. (Yasufumi Kinoshita) Old system variable innodb…7 could crash the server. (Yasufumi Kinoshita) MySQL bugs 56433 and 51325 – These MySQL bugs have been fixed in Percona Server. (…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…. I decided to write a series of blog posts on MySQL‘s unsolved severe limitations. I mean limitations that really hobble… to each of them. The coordinator would read from the relay log until it has a complete transaction’s worth of events… transactions begin in the same order as defined in the relay log, and commit in the same order. If any error occurred…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** …read-io-threads=16 innodb-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout innodb-rollback-…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… innodb-safe-binlog option in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL 5.0 XA is taking care of this synchronization. .frm Corruption – Few people know MySQL… corruption – If slave happens to crash you can also have relay logs corruption and master.info being corrupted. Not to mention MyISAM…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… while with MySQL Replication you can use Maatkit to merge the changes after all, also you can review binary logs to see… I run in production relaying on MySQL Replication for HA I often have 15+ minutes reply of Innodb Transactional log which would be… allows building very nice mixed environments with MySQL – for example you can replicate binary logs using DRBD so if master node fails…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… completely crash safe – if Slave MySQL Server crashes/power goes down it is likely for relay logs to run out of sync (they… would print position in master log files up to which replication was done: InnoDB: In a MySQL replication slave the last master… expected. Innodb during recovery also prints position in the MySQL binary log: InnoDB: Last MySQL binlog file position 0 589600615, file name ./galax…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… and complex procedure. Lets now compare it to MySQL Replication based solution. With MySQL Replication you have to have one Master node… for queing event in relay log. Now lets see how Synchronous Replication solutions such a Percona XtraDB Cluster and MySQL Cluster are different… talks about Percona XtraDB Cluster, Synchronous Replication and Galera Technology, MySQL Cluster production use, and Keynote and Talk about Clustrix – another…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… be making MySQL Replication to work. You might need to inject MySQL 5.0 in between so it will convert binary log events… to Innodb in MySQL 5.5, meaning you might need to set storage_engine=MYISAM if you’re relaying on tables to be created as MyISAM by default. Regarding setting character set to utf8 – this is not needed as MySQL…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… log and executing them on the SLAVE. Since MySQL 4.0 this process is a bit more involved having events passing via relay logs…_Retry: 60 Master_Log_File: db01-bin.003814 Read_Master_Log_Pos: 744615652 Relay_Log_File: mysqld-relay-bin.000953 Relay_Log_Pos: 744615788 Relay_Master_Log_File: db01…
