…easy for MySQL replication to become bottleneck when Master server is not …your system when your replication runs normally – if you need to add/remove indexes and do other schema…estimate replication capacity, so we can deal with replication load before slave is unable to catch up. Need to replication…
Post: Missleading Innodb message on recovery
February 15, 2010 By 2 Comments
…: In a MySQL replication slave the last master binlog file InnoDB: position 0 10000000, file name mysql-bin.005000 InnoDB: Last MySQL binlog file position… restart replication from mysql-bin.005000 position 10000000 which failed with “Could not find first log file name in binary log index file…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…mysql-bin wsrep_cluster_address=gcomm:// wsrep_provider=/usr/lib/libgalera_smm.so datadir=/var/lib/mysql wsrep_slave…view# 18: Primary, number of nodes: 3, my index: 0, protocol version 2 120619 13:20:17 …): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():439. IST …
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
…Text Search solutions with MySQL and Sphinx. This presentation will talk about architecture of BoardReader.com which indexes over billion of …last summer. Using Slave Server Without Breaking User Experience MySQL Replication is asynchronous this means you should be using slaves only for reads and…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 …MySQL Cluster would ever be that thing as it provides too strong guarantees. It is same as with MySQL Replication…They anyway read stale data from the slave or memcached manually relaxing data consistence requirements…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
… temporary table with temporary indexes resulting in an unbootable server. Bug fixed #999147 (Laurynas Biveinis). Fixed the upstream MySQL bug #66301. Concurrent…. Bug fixed #890623 (Alexey Kopytov). A server acting as a replication slave with the query cache enabled could crash with glibc detected…
Post: Announcing Percona Server 5.5.24-26.0
June 1, 2012 By 9 Comments
… as a replication slave with the query cache enabled could crash with glibc detected memory corruption. This bug was introduced in MySQL 5… crash could leave behind an InnoDB temporary table with temporary indexes resulting in an unbootable server. Bug fixed #999147 (Laurynas Biveinis…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…and slave IPS and will accept writes. But what could happen with Galera replication …_connected | ON | | wsrep_local_index | 1 | | wsrep_ready | ON | only wsrep_local_index defers as expected…mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…Replication Master Server (default) # binary logging is required for replication log-bin=db1-bin log-bin-index=db1-bin.index…Replication Slave (comment out master section to use this) # # To configure this host as a replication slave…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…) ); What can we improve here? Especially assuming that there are indexes other than the primary key, we can shrink the primary… use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the work on a slave, then piping…
