… all filters disabled; on the relay master 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… 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: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… cause a server to hang when binary log is enabled. Bug fixed #1162085 (Alexey …my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the upstream bug #68845 which could unnecessarily increase contention on log… work is done when userstat is disabled. Bug fixed #1128066 (Alexey Kopytov). Other …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… cause a server to hang when binary log is enabled. Bug fixed #1162085 (Alexey …my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the upstream bug #68845 which could unnecessarily increase contention on log… work is done when userstat is disabled. Bug fixed #1128066 (Alexey Kopytov). Other …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included… options are somethat benchmark optimized – for example doublewrite is disabled; checksums are disabled; binary log is disabled – this is not what you would probably run…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 7 Comments
… and ROW replication contain the changes to the data in binary logs. This requires the data to be same on Master and… can do the following: Add skip-slave-start in your my.cnf; run SLAVE STOP; dump all your memory tables using MySQLDump… CHAIN/TREE replication. In this case you will need to disable binary logging while loading data from mysqldump as you may not want…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…grep ‘Configure command’ Configure command: ./configure ‘–disable-shared’ ‘–with-server-suffix=-community’ ‘–… slow logging (see Configuration section for details). Then rename the binary, …log options. This is the most important one as it enables the logging. If you don’t specify it in my.cnf…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… transaction are written to the binary log. They are called binary log events. A binary log event contains the server-… forget to change the server-id in my.cnf. You change the server-id interactively, this …mmm mode and put it to passive to disable any automatic failover during the process because …
Comment: Jeremy Cole on MySQL Replication
June 14, 2006 By 12 Comments
… was that you should disable xa-support in my.cnf if you 1. don’t need it and 2. have binary logging (replication) enabled your… a COMMIT statement, it writes the whole transaction to the binary log and then commits this transaction into InnoDB. If the server… that the binary log ITSELF is XA-compliant:) I guess what I’m really asking is, if you have enabled binary logging (replication), sync…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid”…=”15″ evict_outdated_slaves=”false” \ binary=”/usr/bin/mysqld_safe” test_user=”…devices defined so stonith is disable. At the end of the …value). In some cases, if slaves are logging replication updates, it may cause failover…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…restarts. The configuration variables for my.cnf have been kept for …) if used. Instructions for disabling the SHM buffer pool … values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg…please see the following links: Downloads: Binary distributions, Percona Software Repositories Installation…
