… different from a Master – Slave replication in terms of the latency since both are asynchronous. How in the Master Master replication the latency… is required in a model of Master-Master replication and when I have slaves of each master in a different machine, I totally… Alter table should be done in a Master-Master replication model? How do we distinguish between a destructive and non destructive schema change? Srini
Comment: MySQL Replication vs DRBD Battles
April 29, 2008 By 12 Comments
… to backup this database). The main database is configured in Master-Master replication fashion. We evaluated using DRBD here too but did… it because we’d loose the ability to do “online schema change” or LVM snapshot backup. And finally we were not able…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…master_connect_retryblogpercona.commanual master_hostblogpercona.commanual master_info_fileblogpercona.commanual master_passwordblogpercona.commanual master_portblogpercona.commanual master_retry_countblogpercona.commanual master_sslblogpercona.commanual master_ssl_cablogpercona.commanual master…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…| 10 | 5 | | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE | 10000 | 100 | | PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES | 1000000 | 1724 | | PERFORMANCE_SCHEMA_MAX_TABLE_…any case very welcome change to help workloads with many connects/disconnects sync_relay_log_info and sync_master_info have now…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… lost. e.g. there is one primary schema and that schema was dropped. Basically when restoring may take … the master to a second server. Allows you to roll forward backups even after losing the master Very … seperated by file, for files that don’t change they can be easily hardlinked to typically save …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… levers we can pull for server optimization. Schema and query optimization can give much greater improvements… nothing else running (this is a dedicated master server). The machine has a lot of swap…and data types and table structures can be changed. Queries can be broken into pieces, combined, …
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
…would still be useful. Tracking Page Changes for Your Database and Bitmap Backups - (Laurynas …MySQL Multi-Master Replication - (Robert Hodges, Continuent) – Robert is the master in discussing the…might look like. Using MySQL Performance Schema to debug performance issues - (Zburivsky Danil, Pythian)…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
…trigger_name, event_object_table, Event_Manipulation from information_schema.triggers where trigger_schema = ‘mydb’ and action_statement like ‘%Foo_History%’\G…, thus changing the order of the inserts made by the trigger. The Foo_History table is now out of sync. Master: *************************** 1…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 5 Comments
… the new Master. In MySQL world we can chose to either ignore this problem (or may be even replay those changes on… makes it possible to identify the objects which were changed on the Master after failover to Slave happened and they can be… done a lot more simple way when there is no schema and when you do not have to mess with complex…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… Ubuntu 12.04 server. Bug fixed #1103655 (Ignacio Nin). The master thread was doing dirty buffer pool flush list reads to… original intention. Bug fixed #1105709 (Laurynas Biveinis). INFORMATION_SCHEMA plugin name innodb_changed_pages serves also as a command line option, but… the replicated table on the master which is used in that trigger. For this to happen master needs to have more than…
