… be on the same machine if you use the BLACKHOLE storage engine) in between the actual master and the…we can consider it truly production-ready. I suppose I should state an obvious disclaimer here in …build something more involved if that’s what you need. Q: What MySQL HA solution is most similar to…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…. It caught me off guard because I‘d never really thought about it – typically, I‘ve used Xtrabackup simply to clone a server… FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER… WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF For full disclosure, here are the versions I was using on my test VM: Percona…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register… for common patterns the MySQL designers know can be improved. But there’s a finite amount of engineer-years spent developing and… used a SUBQUERY to fetch and compare MAX(episode_id) as an option there? Yes, I think what you’re referring to is what I…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
I am currently working with a large customer and I am involved with servers located in …, I allocated mirror pairs using drives from different controllers. That way, if a controller dies, the storage …on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an …
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… I was using for the test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL… transparent to users, and the McAfee MySQL Audit Plugin is only one of example of what can be achieved with it. It…, since I think proper audit trail support has been an important missing feature on the server, which has made using MySQL in PCI…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside transaction. 2. Updates involving non-transactional storage engines…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… best thing since the invention of L2ARC and ZIL. All I am dreaming now is to have LZ4 compressed persistent L2ARC, which… quite stable, IMHO, and its lead developer just quit, so I consider that pretty much dead project. The only thing…. So OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker. Maybe you guys can…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… caused by compression. If I use SSD for L2ARC, I‘ll need to do the same for xfs… I am redoing my tpcc test with primarycache=metadata, if giving more arc to metadata make sense, I should already see… for a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the filesystem. I took a…
Comment: MySQL VIEW as performance troublemaker
May 23, 2013 By 57 Comments
i have been burned by ms access queries. now that i am into mysql… i certainly want to hear all these view stories. even though i have not yet used them.lol.
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… unused mcast address (again, talk to your network guys). I‘m using 239.192.0.11, so we’ll add this to… mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql…
