…and wsrep_node_name variables have to be different on each host, for wsrep_node_name, you can …ea53b7b12451): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():439. IST …a database and a userfor it. mysql> create database sbtest; Query OK, 1 row affected (0.01 sec) mysql> …
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
…_XOR h=hostname.local,u=root,p=xxx –replicate=checksum.checksum –emptyrepltbl –chunksize=500000 –databases mydb –sleep 1 He could then examine… Name: maxlength Value: 7 Field_Id: 3 As you can see from the above, the updates were performed in a different order, with the inserts being assigned a different Foo_History_Id. This is because…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…MySQL Replication (statement based) works by fetching statements from MASTERs binary log and executing them on the SLAVE. Since MySQL…replication to work properly you need to have proper “snapshot” – consistent state of the database…replication being delayed very significantly you will see different…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… MySQL configurations for high availability is master-master replication, which is just like normal master-slave replication …; a mixed workload will usually have some different hot spot or mixture of hot spots,… buffer. Notice the pages with no database or table name — the second row in the table …
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…to reduce their database size on disk…, or just sample different short windows during your…careful not to break replication!). mysql> create schema index_analysis…name as table_name, all_indexes.index_name as index_name from all_indexes left join used_indexes using (TABLE_SCHEMA, TABLE_NAME, INDEX_NAME…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…System Administrator are different people from different departmnents which might…/Data – This will create snapshot named dbbackup for Logical Volume Main…/Copy database to the slave database directory. 10) Start MySQL Server…. Run SLAVE START to restart replication. With slightly modified process…
Post: Getting History of Table Sizes in MySQL
December 8, 2010 By 13 Comments
… MySQL 5.0+ has information schema collecting and keeping this data is very easy: create database… KEY(DAY,TABLE_SCHEMA,TABLE_NAME), KEY(TABLE_SCHEMA,TABLE_NAME) ) ENGINE=INNODB DEFAULT CHARSET=utf8… you use statement based replication it will automatically pick up sizes and even different tables on …
Post: Missleading Innodb message on recovery
February 15, 2010 By 2 Comments
… seems to be duplicate for describe different issues). Anyway. The customer came to …MySQL replication slave the last master binlog file InnoDB: position 0 10000000, file name mysql-bin.005000 InnoDB: Last MySQL… This database was running older MySQL version a while back which was updated to MySQL 5.1…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…different timezone. We have a fix here. Details on how we dump schemas: loop through each DB write out ALTER DATABASE… Restoring data while automatically replicating out to all slaves… TABLE WITH READ LOCK”. Namely when a select is…MySQL backup systems for future posts Detailed strategies for different…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… replication with ROW based binary log file. The application connects to the database… the tmp partition with the name ML*. Here is the problem. …on the binary log. There are different solution to this problem: Increase the… killing system in the end. Conclusion MySQL can creates temporary files even …
