…previous post I explained how to repair MySQL 5.6 GTID replication using two different methods. I didn’… for key ‘PRIMARY” on query. Default database: ‘test’. Query: ‘insert into t VALUES(NULL,’salazar’)’ Retrieved_Gtid_Set: … GTID we need to find a way to ignore that transaction. The way to do it is…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… referring to that: – pc.ignore_quorum: Completely ignore quorum calculations. E.g. …insert will take longer: percona1 mysql> insert into percona values (0,’percona1′,’vadim’); Query OK, 1 row affected (7.77 sec) percona1 mysql> insert… You can keep inserting data, it won’t be replicated and you will …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_rewrite_dbblogpercona.commanual replicate_same_server_idblogpercona.commanual replicate_wild_do_tableblogpercona.commanual replicate_wild_ignore…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…replication in MySQL 5.1 and later, but most installations I know of are using statement-based replication, even on MySQL…insert into test.t(a) values(1); -> insert…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… of concurrent inserts happening to the same table. This was born same as bunch of others due to statement level MySQL Replication which among other requirements, needs all auto-increment values in multiple value insert to be sequential. To…. There are probably similar problems in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1+ it is also possible…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… inserted. Another way to see it is by monitoring your MySQL…IGNORE_SERVER_IDS from CHANGE MASTER[4] The last solution, my favorite one, is to stop the replication…replication-implementation-details.html [2] http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_replicate…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… 8M long_query_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb innodb_additional_…_file_size = 512M innodb_open_files=2048 #Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor ======== ==> max_heap_table_size=128M
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
… [revin@forge rsandbox_5_5_17]$ ./master/use test -e “insert into t2 select * from t1″ master [localhost] {msandbox} (test) > SELECT…) do not use IGNORE, be critical about your data 2) use ROW* based replication. When using the latter, MySQL will log separate statements… successfully deleted then those 100 events are logged and eventually replicated. [revin@forge rsandbox_5_5_170]$ ./master/use test … master…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… in number of other environments. INSERT ON DUPLICATE KEY UPDATE had a unfair share of replication issues in MySQL 5.0. There are… application not to use INSERT ON DUPLICATE KEY UPDATE in this instance so it was done. So replication was running properly but… for application and could be ignored. So at this point we were sure the write traffic replicates properly to the new setup…
Post: Percona Toolkit 2.1.9 is ready
February 15, 2013 By Leave a Comment
… pt-heartbeat, made the tool report a huge amount of replication lag. This release makes the tool compatible with pt-heartbeat… bug: “Added warnings for duplicate key errors when using INSERT IGNORE“. However, standard MySQL does not warn in this case, despite the docs… has always intended to ignore duplicate entry errors by using “INSERT IGNORE“, it now handles the MariaDB case by also ignoring duplicate entry errors…
