…with a client that asked about using Percona Xtrabackup to take a snapshot of a particular MySQL schema and then reload it with…–apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs … be done easily using mysqldump –no-data. Now, enough with the theory, here is the…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who have already done these operations with… #3: The master has crashed before sending all writes If the binary logs of the master are no longer readable, you will probably… to the correct master with master_auto_position = 1. This can even be made easier with mysqlfailover from the MySQL Utilities (this will…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…2.1.3. My node is crashed and I have this error in my log : 07:53:55 UTC – …to find out where mysqld died. If you see no messages after this, something went terribly wrong… stack_bottom …/lib/mysql/srv-d2-mysql02.pid ended in an another environment I have three nodes on VM with percona-xtrabackup…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… for MySQL was built with YaSSL which could cause some of the programs that use it to crash. Fixed by building packages with OpenSSL… for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… not fsyncing every transaction (innodb_flush_log_at_trx_commit != 1), or work around it with by fsyncing to memory (Battery or… after a crash, it has to get to disk. This has no effect on standard MySQL replication from this instance, since MySQL replication is… to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think about the tradeoffs…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
…When mysqldump was used with –innodb-optimize-keys and –no-data options, …with YaSSL which could cause some of the programs that use it to crash. Fixed by building packages with… to hang when binary log is enabled. Bug fixed #1162085…was missing help texts in the MySQL client because the help tables …
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer …log copying thread which could cause XtraBackup to crash. Bug fixed #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer satisfied mysql…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… for MySQL was built with YaSSL which could cause some of the programs that use it to crash. Fixed by building packages with OpenSSL… for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
…crash_commit_after_log“, DBUG_SUICIDE();); DBUG_EXECUTE_IF(“crash_commit_before_unlog”, DBUG_SUICIDE();); DBUG_EXECUTE_IF(“crash… sourced command file: No registers. # 2011-12… completed with failure status STATUS_SERVER_CRASHED (…crashed and restarted: $ ./kewpie.py –suite=innodbCrash –basedir=mysql…
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… flush the log to disk at commit. By this means you are ensuring that in the event of a MySQL crash the data will still be consistent, however in the event of a system crash there may be… Server with XtraDB allows much larger logs beyond the InnoDB limit of 4G. As a side effect of logging there is no need to…
