…OK, 0 rows affected (0.39 sec) Records: 0 Duplicates: 0 Warnings: 0 We get no warnings and no errors in 5.6,… # Summary of indexes # ######################################################################## # Size Duplicate Indexes 9 # Total Duplicate Indexes 1 # Total Indexes 2 By the way, if you…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… and Dependencies Download the latest copy of SchemaSpy jar file (5.0.0 at time of writing) Make sure you have latest copy… to properly link child_A to parent table: 1.0” encoding=”UTF-8″?>
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… on MySQL 5.6 GTIDs. You can find part one here. Our goal will be to go from setup #1 to setup… scenarios: For these tests, all servers are running on 127.0.0.1 with ports ranging from 10000 for s0 to 10004 for… all; # For s0 s0> change master to master_host=’127.0.0.1‘,master_user=’rsandbox’,master_password=’rsandbox’,master_port=10001,master…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… discussed on a previous post in our blog. Starting with 5.1, the new plugin API gives us more flexibility by allowing… Percona Server version I was using for the test (5.5.28-29.1). This is needed as the plugin needs the offset…”} {“msg-type”:”activity”,”date”:”1369155747383″,”thread-id”:”6440″,”query-id”:”0“,”user”:”debian-sys-maint”,”priv_user”:”debian-sys-maint”,”host…
Comment: Percona Server for MySQL 5.5.30-30.2 now available
May 24, 2013 By 10 Comments
after upgrade ssl replication doesn’t work anymore: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) same certificates worked fine with 5.5.30, OpenSSL 1.0.0
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings… Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database…recommended to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off …
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication… interface, eth1: [all nodes]# ip ro add dev eth1 224.0.0.0/4 [all nodes]# ip ro show | grep 224 224… my.cnf: wsrep_provider_options = “gmcast.mcast_addr=239.192.0.11″ If you already have wsrep_provider_options set, add…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the –export flag: innobackupex… was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other use cases that come to mind…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… For MySQL 5.0 and 5.1, run STOP SLAVE, CHANGE MASTER TO MASTER_HOST=” and then RESET SLAVE. For MySQL 5.5 and 5.6, run… from MySQL 5.5). If you want to know more details, please read on! MySQL 5.0/5.1 First let’s consider MySQL 5.0 and 5.1. RESET….cnf [...] master-user=rsandbox master-password=rsandbox master-host=127.0.0.1 master-port=35301 [...] Let’s disconnect the slave: mysql> stop…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… XtraDB Cluster We started beta support for MySQL 5.6 in 2.1.8 when 5.6 was still beta. Now that MySQL 5.6 is GA, so is our support for it…. Now that we have four base versions of MySQL (5.0, 5.1, 5.5, and 5.6), plus at least four major forks (Percona Server, MariaDB…
