…with its binary log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with an …#1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… of the replication topology. On the top-level master, you leave all filters disabled; on the relay master you add binary log filters…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… to use GTIDs Disable read-only mode This procedure will switch all your servers from regular replication to GTID replication. But if you…’s create a simple replication configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure… and restart it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log tells us why the…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…Replication … logfile ‘/var/log/corosync.log‘ for reason: … has been disabled at boot… [ OK ] Checking Network Manager…MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… with infinite replication loops. I decided to write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain… to disable any automatic failover during the process because high availability tools like mmm can cause failover if you stop replication # mmm…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and … advanced cases allowing replication to control what will be logged to binary log and so replicated. On the … MyISAM tables, because MyISAM can’t be disabled and so if you create tables as …
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 executes… do not forget to disable binary logging with SET SQL_BIN_LOG=0 before you run ALTER TABLE query. Replication Overload Many tutorials out…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… 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… of the tool does NOT have any features to disable the binary log; my experience has been that this is a very…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
Jeremy Cole recently posted very nice post about MySQL Replication Performance. There are however few points I should comment on. … log drops update performance. I guess Jeremy speaks about enabling binary log and setting sync_binlog option which is good for safe replication… effect just by enabling log_bin. Innodb tables also have to flush logs on transaction commit unless you disable it so you should…
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, as described here yet it does not guaranty replication will… former execution plan either by updating statistics (ANALYZE TABLE) or disabling some of the optimization/statistics related features in new version…
