… you add binary log filters; this ensures that the top-level master and its binary logs are fully intact, and then the binary log filters are executed on the intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves. You can also use the slave_compressed_protocol option in /etc/my.cnf…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… master has crashed before sending all writes If the binary logs of the master are no longer readable, you will… the server UUID can be read in the auto.cnf file in the datadir). So the last executed event… is a solution of course, but very poor in my opinion: look for the binlog file/position of the…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…, replication will restart at the beginning of the first available binary log, which is very likely to corrupt your data by reexecuting… available binary log file on the master, which is probably not what you want. So never set master-xxx variables in my.cnf! From…, replication will start at the beginning of the first available binary log file, with all the nasty consequences we can imagine. Even…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… this re-release only affects RPM so our dpkg and binary packages remain unchanged. Percona XtraDB Cluster was also affected by…-29.3 which could cause a server to hang when binary log is enabled. Bug fixed #1162085 (Alexey Kopytov). Fixed upstream bug… of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… during installation. Bugs fixed #1031427 and #1051874 (Ignacio Nin). The log tracker thread was unaware of the situation when the oldest…-29.3 which could cause a server to hang when binary log is enabled. Bug fixed #1162085 (Alexey Kopytov). Fixed upstream bug… of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
… current binary log gets close to max_binlog_size in size, new binary log is created and, if expire_logs_days is not zeroish, log files older than expire_logs_days are removed. &LOCK_log mutex is… the size of binary log file from default 1GB (some systems have it set to 100MB in their default my.cnf) down to 50MB…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… or stripped binaries, which are optimized for speed rather than debugging). If the binaries you have are… instance include –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in order …) | | ->27.73% (114,084,096B) 0x728DAA: Log_event::read_log_event(st_io_cache*, st_mysql_mutex…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… statements from that transaction are written to the binary log. They are called binary log events. A binary log event contains the server-id where it…-id on the binary log, and the slaves (included the other master) will replicate them… and write them in their binary log… and then… machine and you forget to change the server-id in my.cnf. You change the server-id interactively, this is an action…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…/mysqld_safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17:30 /usr/libexec/mysqld –defaults-file=/etc/my.cnf –basedir… a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log gives…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this…! # #skip-networking # Replication Master Server (default) # binary logging is required for replication log-bin=db1-bin log-bin-index=db1-bin.index binlog-ignore…-port = # # binary logging – not required for slaves, but recommended #log-bin # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path…
