…, many people are using a single server with some backups configured, and then simply take the downtime when a restore is…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
Comment: Percona Playback 0.6 for MySQL now available
June 10, 2013 By 1 Comment
I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn’t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… should be directly connected from one machine to another and configured with Linux network interface bonding in balance-rr mode; this… the slave, as described in the MySQL manual. You can 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…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… have a running cluster, we need to shut it down, configure our mcast address and re-bootstrap it: [root@node3 mysql… unicast, so we still want to make sure those are configured to use the regular IP of the node. Typically I…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… are straightforward: #For s2 (the new master), we remove its configuration as a slave s1> stop slave; s1> reset slave all…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…: 1.1.7-6.el6-148fccfd5985c5590cc601123c6c16e966b85d14 3 Nodes configured, 3 expected votes 7 Resources configured. ============ Online: [ percona2 percona3 ] OFFLINE: [ percona1 ] reader_vip… the configuration file is OK: [root@percona1 ~]# ccs_config_validate -f /etc/cluster/cluster.conf Configuration validates We can now copy the configuration…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… of all the MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to stripe the… ZFS a try. So I trashed the raid-10 arrays, configure JBODs and gave all those drives to ZFS (30 mirrors…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…, and this is what the McAffee plugin does. Installation and configuration are straightforward following the available instructions. The only extra step… few sample output lines generated by the plugin with this configuration: {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 22, 2013 By 8 Comments
… connect, START SLAVE. There is no need for any special configuration or to restart or otherwise touch any other servers. I…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… all events and be in sync with the master Change configuration for all servers and restart them Use CHANGE MASTER TO… answer to these questions, let’s create a simple replication configuration with one master and two slaves, all running MySQL 5… disabled. First try: configure only one of the servers with GTIDs Let’s stop slave #2, change configuration and restart it: mysql…
