… # binary logging and replication binlog_cache_size=1M binlog_format=MIXED log-slave-updates log-bin=mdmp_freehold_binlog sync_binlog=1 relay-log=mdmp…-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor boonton: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…binlog_format=ROW log_bin=mysql-bin wsrep_cluster_address=gcomm:// wsrep_provider=/usr/lib/libgalera_smm.so datadir=/var/lib/mysql…*’. Selected 1 (ip-10-112-39-98)(SYNCED) as donor. 120619 13:20:19 [Note]…local_state variable. To set it up, create the clustercheck user. mysql> grant process on *.* to …
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… with pt-table-checksum/pt-table-sync) than several days or several weeks … the new –verify-binlog-checksum option of mysqlbinlog: # mysqlbinlog –verify-binlog-checksum mysql_sandbox18676-relay-bin…. by default): master [localhost] {msandbox} ((none)) > set global master_verify_checksum=ON; Query …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… can binlog rollforward 24 hours of binlogs as a good test. Store your binlogs … on the lock time by syncing the frm files. Enable –slave-…write out ALTER DATABASE DEFAULT CHARACTER SET
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
… wsrep_slave_threads=16 and all other required wsrep settings. Also note that I disabled log-bin and innodb_… clients with semi-sync replication. Apparently each client must wait for it’s turn writing to the binlog and waiting … and disaster recovery than semi-synchronous replication in stock MySQL.
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…format in GA versions of MySQL 5.1 is ‘MIXED’ STATEMENT*; The binlog_format variable can still be…even if the data is not 100% in sync, so MySQL doesn’t know anything is wrong. …on_the_slave; +———-+ | count(*) | +———-+ | 0 | +———-+ 1 row in set (0.00 sec) Now, lets make a …
Comment: Jeremy Cole on MySQL Replication
June 14, 2006 By 12 Comments
… However, i stumbled upon this in the official mySQL 5.0 documentation: “Even with sync_binlog set to 1, there is still the chance… tables and the binary log. (Note: –innodb-safe-binlog is unneeded as of MySQL 5.0; it was made obsolete by the…, if you have enabled binary logging (replication), sync_binlog = 1, and you’re using MySQL 5, and it’s the only transactional resource…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…have to be very careful such as using sync-binlog innodb_flush_logs_at_trx_commit=1 and…with delayed replication (which you already could have set up with mk-slave-delay from Maatkit. Delayed…master), Replication breakage (or running out of sync) due to MySQL bugs or wrong use. Interesting enough very…
Comment: Percona Server 5.5.15 + Galera 21.1-beta2
October 5, 2011 By 18 Comments
Andy, Galera catches binlog events directly from MySQL transaction cache, before they are written to binlog files. Therefore, log-bin does not even… binlogging just by setting ‘log-bin’ and ‘log-slave-updates’ options and do further tuning with sync_binlog to your liking. To my understanding binlog…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… some settings Here is mysql configuration (We are having only 1 mysql server, no replication setup) [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql server-id=1 #replicate-same-server-id=0 log-bin=newcrmdb1-bin #binlog_do_db=crmdb binlog… #master-port = 3306 #innodb_flush_log_at_trx_commit=0 sync_binlog=0 slave-skip-errors = 1062 back_log = 75 # skip-innodb…
