… 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 12 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…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…: MySQL 5.1+ row based logging (binlog_format=1) unique server_id in the my.cnf log_slave_updates=1, if this …*************************** 1. row *************************** server_id: 999 master_log_file: binary_log.000001 master_log_size: 214652 exec_master_log_pos: 214652 If you select from …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…, specifically you need to enable slow logging (see Configuration section for details). Then rename the binary, which can be safely done even… slow log options. This is the most important one as it enables the logging. If you don’t specify it in my.cnf file, the remaining part of the configuration will not matter, because the log…
Comment: Jeremy Cole on MySQL Replication
June 14, 2006 By 12 Comments
… should disable xa-support in my.cnf if you 1. don’t need it and 2. have binary logging (replication) enabled your benchmarks suggested… 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 94 Comments
… ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid” \ socket…_slave_lag=”15″ evict_outdated_slaves=”false” \ binary=”/usr/bin/mysqld_safe” test_user=”root” \… (default value). In some cases, if slaves are logging replication updates, it may cause failover issues. …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation…_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data… 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 6 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…/TREE replication. In this case you will need to disable binary logging while loading data from mysqldump as you may not want…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…machine restarts. The configuration variables for my.cnf have been kept for compatibility and…). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev…, please see the following links: Downloads: Binary distributions, Percona Software Repositories Installation instructions …
