…with its binary log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with an …#1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… all filters disabled; on the relay master you add binary log filters; this ensures that the top-level master and its binary logs are…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…/nfs/dist/5.6.10/lib/plugin/ | | SYNC_RELAY_LOG | 0 | 10000 | | GENERAL_LOG_FILE | /mnt/data/sandboxes/msb_5_5_30/data…/data/dpe0 | | PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | 50000 | 445 | | SYNC_RELAY_LOG_INFO | 0 | 10000 | | SLAVE_LOAD_TMPDIR | /mnt/data/sandboxes/msb…_stats_on_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size – default…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot… which would mean limit disabled. Very few users actually need DOS prevention this variable strives to provide as MySQL is typically protected… could just be left alone. Same applies to sync_relay_log and sync_relay_log_info settings. James also promises updated sample my.cnf…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… by the slave_sql_verify_checksum variable. Let’s first disable them: slave1 [localhost] {msandbox} ((none)) > set global slave_sql_verify… ‘mysqlbinlog’ on the relay log), a network problem, or a bug in the master’s or slave’s MySQL code. If you want to check the master’s binary log or slave’s relay log, you will be…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… are still in the relay log, they are just applied. Then written with their server-id on the binary log, and the slaves…. check the mmm mode and put it to passive to disable any automatic failover during the process because high availability tools…): mysql> stop slave; Step 2: there are writes on the active master, the loop statements are also replicated from the relay-log but…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
…MySQL Replication to work. You might need to inject MySQL 5.0 in between so it will convert binary log… in MySQL 5.5, meaning you might need to set storage_engine=MYISAM if you’re relaying on … MySQL. Our focus on compatibility is indeed so high there are number of great features which are disabled …
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… Slave SQL thread initialized, starting replication in log ‘bin.000025′ at position 12410321, relay log ‘/var/log/mysql/relay.000086′ position: 4837623 080625 23:53:28…all disabled from 20 servers: # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… cache for – MyISAM tables (mysql database, temporary etc) will need it, .frm file, binary logs, or relay logs, Innodb Transactional Logs also like to be cached otherwise OS will need to do reads to serve writes to these log… spike. Plus not all kernels work quite well with swap disabled and there are other reasons against it. For some people…
