…log_binblogpercona.commanual log_binblogpercona.commanual log_bin_indexblogpercona.commanual log_bin_trust_function_creatorsblogpercona.commanual log_errorblogpercona.commanual log_isamblogpercona.commanual log_outputblogpercona.commanual log…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…mysql-data 0.00 mysql-logs sb -wi-ao 10.00g Suppose sometime after the snapshot, I accidentally dropped the salaries tables…. [root@sb logs]# cat mysql-data-201202230157-binlog-info File Position Binlog_Do_DB Binlog_Ignore_DB mysql-bin.000022 336796712 …
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… or partial MySQL Replication (as of version MySQL 5.0) – …_LOG_BIN=0 if you need to skip some statements from binary logging…table, replicate-ignore-table, replicate-wild-do-table and replicate-wild-ignore-table options which act differently. Instead of looking at the query and analyzing which tables…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…ignore” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin…MySQL. Default is to run select count(*) on mysql.user table, so the user given should at least have select on that table… In some cases, if slaves are logging replication updates, it may …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…log-bin=db1-bin log-bin-index=db1-bin.index binlog-ignore-db=chrome_vin binlog-ignore-db=dummyData #binlog-ignore-db=edmunds #binlog-ignore-db=evox #binlog-ignore…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…Log_File: db01-bin.003814 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…Ignore_DB | +——————+———-+————–+——————+ | mysql-bin.000007 | 474 | | | +——————+———-+————–+——————+ master > show binlog events in ‘mysql-bin.000007′\G *************************** 1. row *************************** Log…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…_query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M binlog_format=MIXED log-slave-updates log-bin…log_file_size = 512M innodb_open_files=2048 #Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor ======== ==> max_heap_table…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… assumed that /usr/bin/perl was where …MySQL connection was given to innobackupex with the –passwordoption, innobackupex would log that password in plain text in the log…ignoring the dropped table. With this bug fix, innobackupexnow safely ignores file not found errors for non-InnoDB tables…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…log ‘bin.000025′ at position 12410321, relay log ‘/var/log/mysql…
