… the second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here. Our goal… slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based on what… volume mounted, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql… specific for MySQL, but note that SchemaSpy works for pretty much all the popular RDBMS out there. java -jar schemaSpy_5.0.0.jar -t mysql -u msandbox_ro -p msandbox -meta schemaspy.meta…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the… always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… share my experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from… for the test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL data structures that… why that is the case. Maybe someone more knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE…_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE… versions I was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other use cases that…
Comment: Upgrading MySQL
May 27, 2013 By 24 Comments
… mysql-5.5.11-linux2.6-i686.tar.gz /usr/local/ cd /usr/local/ tar -xf mysql-5.5.11-linux2.6-i686.tar.gz mv mysql-5.5.11-linux2.6-i686 mysql cd mysql chmod root:mysql data/ chown root:mysql data cd /var/lib/mysql/ rm -rf ibdata1…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
Yes, because MySQL 5.6 GTID is fundamentally broken in the design. You don’… of MySQL 5.6 and MariaDB 10 using GTID. You will be kept plenty busy trying to get even a pure MySQL 5.6…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… Wednesday, June 5, at 10 a.m. PDT (1700 UTC), I will be presenting a webinar entitled, Choosing a MySQL HA Solution…. We will then explore some of the more well-known MySQL HA tools and technologies available today (largely grouped into those which use traditional MySQL replication, those which use some other MySQL-level replication, and those which replicate at…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
You can replicate from MySQL 5.6 to MariaDB 10.0 or vice versa. You just … MariaDB compatible without merging all of the crap that is MySQL 5.6 global transaction ID, I would very much like to…
