…many environments when development has too much autonomy. I must note in this aspect however DRBD goes on par with MySQL… understood what was meant here. With MySQL Master-Master replication I can add and index on… few not committed transactions on the slave. We should spend some time implementing …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…. CDC applications exist for many commercial databases but until recently this type of software was not available for MySQL. Change Data Capture… up a dedicated MySQL slave which has log_slave_updates=1 and binlog_format=row to process SBR changes from a MySQL master. I’ll… table: $ mysql -e ‘select * from flexviews.binlog_consumer_status\G’ -uroot *************************** 1. row *************************** server_id: 999 master_log_file: binary_log.000001 master_log…
Post: Using MySQL Sandbox with Percona Server
February 16, 2013 By 3 Comments
… versions of MySQL Servers is MySQL Sandbox which allows you to maintain many different versions of MySQL, Percona Server,…master installing slave 1 installing slave 2 starting slave 1 … sandbox server started starting slave 2 … sandbox server started initializing slave 1 initializing slave…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | 445 | | SYNC_RELAY_LOG_INFO | 0 | 10000 | | SLAVE_LOAD_TMPDIR | /mnt/data/sandboxes/msb… | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON | | SYNC_MASTER_INFO | 0 |…MySQL 5.6 but you can see many options can be scaled down compared to MySQL…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot of good changes and many defaults are… different buffer sizes used. sync_master_info = 10000 Quite useless change in my opinion. Syncing master info every 10000 events is no… will be badly out of sync if slave is to crash. The recommendation to use master_info_repository=table is a good…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… setup MySQL replication between a master and one or more slaves. Upon failure of the master, one of the slaves is manually promoted to the master… committed transaction has not been pushed to the slave(s) leading to data loss. Many large websites that are fine with some… 2 MySQL servers configured in a Master to Master topology. Additional slaves can also be added. A MMM agent runs on all the MySQL servers…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… be on promoted slave and slave should have –log-slave-updates enabled so it somethat has copy of master logs. In many cases I’ve…. Master or Slave running out of space, Slave crashing (and loosing its position on master), Replication breakage (or running out of sync) due to MySQL…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
… are many aspects of MySQL replication, but my main focus will be the logistics – how replication events are written on the master, how… file stores data that replication slave will be reading later. Whenever a replication slave connects to a master, master creates a new thread for…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… tables from replication in master side vs slave side? A: You can configure filtering either on the master or the slave. Master-side filtering records… sense to improve it to query-level. As you mentioned, many applications require different tolerance levels per query. A: Yes, that… the master and then subsequently potentially a number of “unsafe” slaves going to be a high performance cost? A: Connecting to a MySQL…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
MySQL 5.6 has an impressive list of improvements. Among them, replication checksums caught my attention as it seems that many … Relay_Master_Log_File and Exec_Master_Log_Pos from SHOW SLAVE STATUS slave1 [localhost] {msandbox} ((none)) > change master to master_log_file=’mysql-bin.000001′, master…
