…slave status\G … Slave_SQL_Running: No Last_Error: Error ‘Duplicate entry ’1′ for key ‘PRIMARY” on query. Default database: ‘percona’. Query…MySQL version and it does not have the rds_skip_repl_error procedure, you can try removing the conflicting record from replication slave…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_… not permitted) at galera/src/replicator_str.cpp:prepare_for_IST…mysql> grant process on *.* to ‘clustercheckuser’@'localhost’ identified by ‘clustercheckpassword!’; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…defined way so cross shard queries become a pain. Dealing with lag in MySQL Replication is another issue …companies I talk to are committed to “no vendor lock in” policy and would not like proprietary solutions, …of MySQL Proxy to help with sharding or dealing with use not fully up to date slaves. …
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
… fixed #999147 (Laurynas Biveinis). Fixed the upstream MySQL bug #66301. Concurrent INSERT … ON DUPLICATE … with the default value of innodb_autoinc_lock_mode=1. Bug fixed #1035225 (Alexey Kopytov…Alexey Kopytov). A server acting as a replication slave with the query cache enabled could crash with …
Post: Percona Server 5.5.14-20.5
August 17, 2011 By 4 Comments
…replication environment, its client connection to the remote server was closed leading to an unappropriated network error and stopping the Slave SQL thread. Bugs Fixed #813587 / #51196 and#61790 in MySQL (Alexey Kopytov). Querying…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock bind-address=10.234.94.71 skip-locking…_length=2048 long-query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=…1 # Replication Slave (comment out master section to use this) # # To configure this host as a replication slave, …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH READ LOCK…long running queries. The catch here is FLUSH TABLES WITH READ LOCK actually …Run SLAVE START to restart replication. With slightly modified process you can clone slaves from the slaves …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…run with –kill-long-queries to avoid nasty problems with “FLUSH TABLES WITH READ LOCK” –compress, …in time Restoring data while automatically replicating out to all slaves mysqlbinlog 5.6 Last year… long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources …
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…_pages_limit. MySQL option handling …slave was processing replication events for a table that is present only on slave server while there are updates on the replicated…lock information even if no lock information was going to be printed. Bug fixed #1100643 (Laurynas Biveinis). InnoDB and the query…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…MySQL…Locking for Partitioned tables – Reduced Contention for LOCK…Replication – Multi-Threaded Slave – Global Transaction Identifiers – Crash Safe Slave and Binlog – Replication Event Checksums – Time Delayed Replication – Server UUID – Improved Logging for Row based Replication – Replication…queries …
