…care if you don’t want to break replication or corrupt your data. Scenario #2: One of …For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And … replication may be broken. Scenario #3: The master has crashed before sending all writes If the binary logs…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…logs to the dirty tablespace and voila, you have a consistent binary…files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For…to compare and restore values (potentially corrupted via user error or other ….e. functional partitioning) Combine with –replicate-rewrite-db Daily backups …
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…I have this error in my log : 07:53:55 UTC – mysqld got …this binary or one of the libraries it was linked against is corrupt, improperly …0×23)[0x7f9337da4c13] /usr/sbin/mysqld(_Z25wsrep_replication_processP3THD+0x4b)[0x595edb] /usr/sbin/…mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave… has been deleted, replication will restart at the beginning of the first available binary log, which is very likely to corrupt your data by…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…, so beware. Binary log corruption – Binary log may become corrupted and out of sync with database content. This will sometimes break replication but if you’… Innodb log and binary log are synchronized. In MySQL 5.0 XA is taking care of this synchronization. .frm Corruption – Few people know MySQL …
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… fairly common issue is binary log or relay log corruption. Will replication checksums help you in this case? Yes, they will! Replication checksums on replicas Checksums…: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay log is corrupted (you can…’s or slave’s MySQL code. If you want to check the master’s binary log or slave’s relay log, you will be…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
…replication stopped with message like this: Last_Error: Could not parse relay log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay log is corrupted…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… the stock MySQL. Yet another way is using DRBD to get a standby MySQL server or at least synchronously replicated master binary logs. If you… master or relay binary log corruption. Master or Slave running out of space, Slave crashing (and loosing its position on master), Replication breakage (or…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…You run into a InnoDB corruption bug that propagates via replication (not common, but does happen)… these major components: Percona XtraBackup for MySQL for binary backups mydumper for logical backups mysqlbinlog 5… mysqlbinlog 5.6, you can now pull binary logs in real time to another server using “…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… Backing up database which was already corrupted is very nasty problem you want…binary log position which is done by running SHOW MASTER STATUS – This is binary log position you’ll need to point your MySQL…log_file=”host-bin.000335″, master_log_pos=401934686; 12) Run SLAVE START to restart replication…
