…to write about using MySQL Partitioning for Performance Optimization and I just got a relevant customer case to illustrate it. First you need to…if you have very active access to values which ave been added to the table recently… hey…. you need to check the impact on master too. Master in its turn …
Post: Percona Server 5.5.15 + Galera 21.1-beta2
October 3, 2011 By 18 Comments
… each node is active (accepts both reads and writes). You can perform writes to ANY node. Setup of 3-master active MySQL Replication is practically impossible. 2. In contrast to MySQL replication, in Percona Server…
Post: Conflict Avoidance with auto_increment_increment and auto_increment_offset
January 12, 2011 By 2 Comments
A lot of people are running MySQL Master-Master replication pairs in Active-Passive mode for purpose of high availabilities using MMM or … to be very carefully switching writes as if you do not do it atomically (such as some scripts continue to write to old master… duplicate key error in replication thread if you happen to insert data to 2 masters at once. This can be solved with auto…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general …_on_metadata = off Yet another change I actively recommended max_connect_errors = 100 10 …to crash. The recommendation to use master_info_repository=table is a good one though default could just be left alone. Same applies to…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… of MySQL Enterprise from MySQL Marketing Materials . There is not much of technical insight otherwise – pretty simple site, master slave replication, plans to use… which was very unusual to see without Brian Aker which normally takes part in all Storage Related activities. There were some Q…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… HEAP for in memory tables. So first MySQL versions did not bother naming variables with … to allocate many resources to MyISAM tables if you do not use them actively you might with to allocate… replication/binlogging related options – when to delete binary logs from master. It does not affect Innodb …
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
September 12, 2011 By 21 Comments
… want to kickstart replication then I stop slaves on both, refresh mysql data (dump with –master-data) on passive node from active node, “change master to” on passive node using the values in the dump. Then to…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… Load – MySQL Replication goes in single thread so it is really vulnerable to the server load. If you get 100 active queries running… interested to know how to measure replication lag – MySQL Toolkit has a great tool for real latency measurement. Do not trust Seconds_Behind_Master…
Comment: Master-Master or Master with Many Slaves
April 7, 2007 By 7 Comments
… master. Other example is Backup process (I prefer to have this done from Active node to avoid problems in case there are bugs in MySQL replication) If properly planned the partial capacity should be no more than a few hours, even if master dies… choice as master can already higher load than usual. This is not to say your advice is wrong, but to say using master as…
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
… tell when your slave is nearing its capacity to keep up with the master? Here are three ways: One: watch for spikes of lag. If you have Cacti (and these Cacti templates for MySQL… replication threads on the slave) to see how much of the time the slave thread was actively processing statements. If the slave…
