… will allow you to stripe a TCP connection over multiple ports, and with a two-NIC bonded pair you…There are a few of ways to do it. One way is to set up replication filters on the slave, as … information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I saw that it was getting a…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… to replicate and establish global ordering for every transaction, and the expense of doing …mean you can’t modify data on multiple cluster nodes simultaneously. You can. It … periodically? if( $last_count % 100 == 0 ) { $db->do( “UPDATE achievements SET count = $last_count where achievement…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… corresponding position in masters binary logs. There are multiple ways to get the “snapshot” – shutting down MySQL …Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: …
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…replication system with optimistic locking. So, when is this really a problem? Really whenever transactions across multiple… fail over gracefully. Update your application DB library to handle sudden deadlocks– …using transactions should have some facility to do this anyway (IMO). Restructure your …
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… schema changes to be replicated to db1 now. 3. on db2: load the sql scripts $ mysql -u root db < changes.sql At... requirement for this step is to ensure replication has caught up. If you have multiple pairs doing some changes in parallel and you… for a failover. There are two ways to do it: 6. Allow replication to catch up This can be slower or faster…
Comment: Should you move from MyISAM to Innodb ?
February 1, 2010 By 59 Comments
…DBs are fronted by memcached machines (64 instances). All applications are written to use memcache before hitting DB. We use RAID0 with multiple…DBA. For failures on a MASTER, we do a quick shift and make one of… you, icrease the use of MASTER-SLAVE replication, and use file-per-table management. Then…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… is conceptually similar to a replication slave that is behind. Until … refresh algorithm computes changes in multiple transactions. After each transaction it…procedures to modify the dictionary. Do not modify it directly. … “CREATE TABLE db.schema … AS SELECT” and/or “INSERT INTO db.schema ……
Post: Tokyo Tyrant -The Extras Part III : Write Bottleneck
November 12, 2009 By 3 Comments
…my 8 thread test. Moving to 10 threads doing the same 4Million inserts I completed the test in…your data into multiple tables each with there own cache. This limit is per TC DB so this should… The 4th & 5th posts were supposed to deal with replication and scaling… this may take a little while. …
Comment: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… storage would be that the cache could be shared between multiple MySQL instances, for instance a group of slaves. That makes…’t change. When something does change, it can cause multiple invalidations because replication is not synchronous – if you’d be able to… including/excluding dbs/tables from the cache. While that can be done in the app, it could be beneficial to do this…
Comment: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… storage would be that the cache could be shared between multiple MySQL instances, for instance a group of slaves. That makes…’t change. When something does change, it can cause multiple invalidations because replication is not synchronous – if you’d be able to… including/excluding dbs/tables from the cache. While that can be done in the app, it could be beneficial to do this…
