… and synchronous clusters I’ve seen a lot of people setting up clusters with 3-6+ nodes on 1 Gbps networks… my.cnf: wsrep_provider_options = “gmcast.mcast_addr=239.192.0.11″ If you already have wsrep_provider_options set, add it to… regular IP of the node. Typically I just set the wsrep_node_address setting on each node if this IP is not…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… configure the slave to only replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is…-level slaves. You can also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… the last event executed: s1> show slave status\G [...] Executed_Gtid_Set: 219be3a9-c3ae-11e2-b985-0800272864ba:1, 3d3871d1-c3ae-11e2-b986… reading from there? Unfortunately, there is no –start-gtid-position option or equivalent. See bug #68566. Does it mean that we… event and use mysqlbinlog with the good old –start-position option! Even with GTIDs, you cannot totally forget old-style replication…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… in and didn’t get significant differences between either output option, or between using the plugin or enabling the general log…. 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: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… about using a temporary table to store an interim result set, and then use that to ultimately produce the result you… SUBQUERY to fetch and compare MAX(episode_id) as an option there? Yes, I think what you’re referring to is…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… was removed. We also removed several options that probably nobody ever used, and changed/renamed other options to be more logical. The… pt-mysql-summary 2.2 have all the standard MySQL options built-in, like other tools: –user, –host, –port, –password, –socket… once and exit. To do that, the tool magically set some options and clobbered others, resulting in no way to do repeated…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… designed to look solely at vCache performance under some different sets of MySQL configuration parameters. For example, given that the front… The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
…. Configuring Galera The configuration here is quite easy: wsrep_provider_options = “socket.ssl_cert=/etc/mysql/cert.pem; socket.ssl_key… must also have it enabled. Other SSL options It is also possible to set the following options (though they seem to have sane… default Other questions Will IST be encrypted if I set the above settings? Yes, according to Codership, IST transfers use the same…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… rows in MySQL */ reclength=max(file->min_record_length(table_options),reclength); if (info_length+(ulong) create_fields.elements*FCOMP+288… interval in UNIREG speak is a set of strings that are the options for ENUM or SET columns. The tricky bit is that it’s unique intervals, not actual intervals, so two ENUM columns both having the options…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… Percona Playback now supports the –query-log-stdin command-line option for accepting a never-ending stream of queries to playback…-only playback Using the –session-init-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs…_fake_changes. Thread pool Percona Playback added a connection pool option via –dispatcher-plugin-thread-pool that will allow connection reuse…
