…. The other reason is because virtual machines tend to handle process scheduling and timing much differently than traditional hardware, and I… also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is… the manual’s description of how replication filtering rules are processed. There are some informative flowcharts in addition to the textual…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… you want to upgrade, you cannot apply any rolling upgrade process. So like for Pacemaker 0.6.x to 1.0… percona1 writer_vip (ocf::heartbeat:IPaddr2): Started percona1 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 percona1 ] [root... percona2 writer_vip (ocf::heartbeat:IPaddr2): Started percona3 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 ] Stopped: [ p…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
Lately I have been working with a set of customers on a longer term basis which has given … speed a lot faster and can contribute to the Development process a lot more effectively when I know the relationships between… html after each run, so I find it convenient to set it up on crontab so that schema changes are automatically…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… can write a script to listen on this socket and process the audit records as you wish. Performance-wise, I did…. The flexibility comes from the three variables that can be set to control what is logged by the plugin: – audit_record… of extending MySQL’s behavior in a way that, once set up, is transparent to users, and the McAfee MySQL Audit…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… s0 to 10004 for s4. Scenario #1: All slaves have processed all the writes This is the easiest case, we will… the last event executed: s1> show slave status\G [...] Executed_Gtid_Set: 219be3a9-c3ae-11e2-b985-0800272864ba:1, 3d3871d1-c3ae-11e2-b986…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and pre… short while. Here’s the vmstat output during the split process, the cron job started at 10am. Fri Mar 22 10… was causing the problem. It happened that the setting vm.dirty_ratio was set to 20 on a 48GB server, allowing nearly…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… Percona MYSQL server and found that Percona need some configuration setting regarding to memory allocation. So we did some memory allocation… my.cnf file. On first day after doing memory allocation setting in my.cnf file, site performance was good. But from… have also noticed that many process stay in sleeping condition for long time like 200-300 processes. Current Server Details (Dedicated Server…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…. In practice, it’s slightly more complicated. To manage this process, we use a tool co-developed with Percona. “Warm standby… for failover during peak traffic. The standby server does not process query traffic except for replication. The buffer pool and adaptive… playback Using the –session-init-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… particular, Virident engaged Percona to do a usability and feature-set comparison between vCache and FlashCache and also to conduct some… between vCache and FlashCache. Ease of basic installation. The setup process was simply a matter of installing two RPMs and running… be written to the backing store, whereas FlashCache has a setting called “fallow_delay”, defined in the documentation as the time…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… based slave (or repair a broken one) using XtraBackup. The process is pretty straightforward. 1- Take a backup from any server…. 4- Start the new slave from that GTID position: slave1 > SET GLOBAL gtid_purged=”c777888a-b6df-11e2-a604-080027635ef5:1-4… Slave_SQL_Running: Yes [...] Retrieved_Gtid_Set: c777888a-b6df-11e2-a604-080027635ef5:5 Executed_Gtid_Set: c777888a-b6df-11e2-a604-080027635ef5:1…
