… you judging quality based on anecdotes and bug counts? Will MySQL adapt to this by being less open about bugs? Note…. In MySQL 4.0, a crash on the master was likely to make the binlog and InnoDB out of sync. The sync_binlog option was… programming and default column values. Also, the golden days have set the stage for the problems of tomorrow. Too much code…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… use MySQL replication instead. So assuming you have innodb_flush_log_at_trx_commit=1 and sync_binlog=1 you will have 4 “sync” operations in MySQL 5.0 – there is event written… with ACK, assuming the DRBD is configured with maximum durability settings. So overhead can vary a lot depending on the speed…
Comment: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…is also to compare against a run with sync_binlog=0 or no-binlog, and possibly also innodb_flush_log_at…give a “best case” baseline to see how much MySQL can do when there are no synchronous fsyncs at…not a valid measurement for production use, rather it sets a goal for group commit developers to try …
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
… been created for the main MySQL branch. The MySQL at Facebook branch has … the master and slave are in sync (once the test load is stopped… DBUG_SUICIDE();); DBUG_EXECUTE_IF(“half_binlogged_transaction”, DBUG_SUICIDE();); What happens … rule that will issue a SET SESSION debug=”d,crash_commit_*”. …
Comment: Is your server's performance about to degrade?
May 19, 2010 By 13 Comments
… use a ext4 filesystem and have binlog enabled to facilitate replication. Ext4 (at least with default settings) doesn’t flush the data… 1GB binlog from memory to disk at the moment MySQL issued the sync. And that sync is by default only issued inside the binlog-rotation… was caused by the very long sync-call. Obviously with faster syncs (i.e. because you sync your binlog more often or with another…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…would be in single-threaded MySQL replication. Therefore all nodes stay in sync much more reliably. Also, …replays changes for a subset of the binlog, skipping the other binlog entries. In this way, each …queries (select etc.)? A: You can set up a pair of MySQL instances to replicate from each other…
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
… 1 row in set (0.00 sec) Uh oh, now the slave is out of sync… replication. When using the latter, MySQL will log separate statements … {msandbox} (test) > SELECT @@binlog_format; +—————–+ | @@binlog_format | +—————–+ | ROW | +—————–+ 1 row in set (0.00 sec) master…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…usr/lib/libgalera_smm.so user=mysql wsrep_cluster_address=gcomm:// binlog_format=ROW wsrep_slave_threads=…; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; replicator.causal_read_timeout = PT30S; …: Start replication 130221 17:59:06 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
August 3, 2012 By 63 Comments
…://10.3.3.3:4567,gcomm:// [mysqld] # # * Basic Settings # server_id=1 binlog_format=ROW wsrep_provider=/usr/lib64/libgalera_smm.so… variable changes as per different nodes) innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 log_slave_updates wsrep… complete….the synced node does not let me make connections…so i have to stop the db as “service mysql stop” and…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…MySQL; they are very careful about upgrades. The RDS instance was a Quadruple Extra Large DB Instance. I used default settings…lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF innodb_log_buffer_size 8388608 innodb_…_mode OFF innodb_support_xa ON innodb_sync_spin_loops 30 innodb_table_locks ON …
