…master. Even though replicate-*-table options also have some issues they are much safer than database based counterparts. In…if you would like to add more tables to be replicated to the slaves. Another issue is of …this one as well. As you can see no matter which road you take with partial MySQL …
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…add / remove nodes almost transparently. It is possible to use it in traditional master-slave…masters in different data centers. This provides a HA solution for MySQL setups in the Cloud. E.g. with current state of MySQL… much more complex than an average MySQL master-slave … I have one serious feature…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…more in my > Why MySQL…master and all those changes are making it to the slave(s). Like any other decision in database design, one…in MySQL you might be > better of using several queries than doing complicated ones. Of > course you would rather use IN() than do 100 of queries in…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…SLAVE…mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON | | SYNC_MASTER…one of the component of purging fine tuning in MySQL…more sense in my opinion. MySQL 5.6 adds a lot more optimizer switches which you can play with: mysql…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…MySQL service. A high availability solution based on MMM requires at the 2 MySQL servers configured in a Master to Master topology. Additional slaves…slaves and remove the read VIP of a slave if it has failed or is lagging behind the master by more than a defined threshold. One…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…one doesn’t know what data should live in it. And this only gets harder to resolve as you get more…in MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the master…than MySQL is, especially for more complex queries. Percona is not tied to MySQL…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… usually operate in one of the following ways: Timestamps (usually more than one) to identify…MySQL slave which has log_slave_updates=1 and binlog_format=row to process SBR changes from a MySQL master. I’ll talk more about that in… utility included with FlexCDC called ‘add_table.php’. This script …
Post: When should you store serialized objects in the database?
January 21, 2010 By 47 Comments
… from storing data in MySQL columns to serializing …in every record, serializing the data in one column can be a better idea than…master-slave switching I’ve always been able to emulate online index adds. Projects like MMM and Flipper make this even easier. In… since more data must be kept in the …
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
…add richer features to the tool, we need equivalent testing capabilities. However, it seems a constant in the MySQL… striving to let more of the work be done by unittest code rather than things I have … do additional work on the master and compare master and slave states One of the great things about…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… – if you need to add/remove indexes and do…in Oracle MySQL Server. set userstat_running=1 and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql…. In this case as we know there is only one…is less than 1, so the master writes more binary logs than slave can…
