…Get the table structures: mysqldump –no-data orig > /tmp/orig.schema.sql Create the new target database: mysqladmin create orig_old Load the schema into the…have a old version of the schema running side by side with the current version on the…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…the work for you. Basically if your database has Foreign Keys then you’re laughing, if not don‘t despair, you just have…I created the mysql.properties file in the same directory as the jar file, I don‘t…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…on the small but handy improvements – changes and bug corrections – in MySQL 5.6 that can make our lives easier and have…all) DBAs. Duplicate Index Detection I commented about this on my last webinar, but did not have time to analyze it in…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
…having inconsistent data on the nodes and encounter replication errors, which you have…I will give a talk on this topic at next month’s RAMP conference in Budapest, Hungary. My…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…on MySQL 5.1.69, this release will include all the bug fixes in it. All of Percona’s software is open-source and free, all the…the directory and file name components in a bitmap file name could stop the server starting if the innodb_data_home_dir variable didn’t have the…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
…is the best thing since the invention of L2ARC and ZIL. All I am dreaming now is to have LZ4 … so I consider that pretty much dead project. The only thing I don‘t like about OmniOS is that the illumos …MySQL Masters using Pacemaker. Maybe you guys can get Galera working on OmniOS to solve our lack …
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…t much traffic in my puny local VMs, but you get the idea. We can clearly see some factor in play adding the extra nodes. Multicast to the…in my trivial VM environment, I just need to make sure that the multicast address space routes to my Galera replication interface, eth1: [all…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…on MySQL 5.6.11, including all the bug fixes in it, Percona Server 5.6.11-60.3 is the first RC release in the…the directory and file name components in a bitmap file name could stop the server starting if the innodb_data_home_dir variable didn’t have the…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…the great questions. I answered as many as we had time for during the session, but here are all the questions with my…have to match the order of columns in the index. Example: WHERE (last_name, first_name) = (‘Karwin’, ‘Bill’); Q: On the Dynamic Pivot, the…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…All slaves have processed all the writes This is the easiest case, we will make s2 a master and redirect replication on the…file/binlog position needs to be done with care if you don‘t…in my opinion: look for the binlog file/position of the last executed event and use mysqlbinlog with the…
