… hurdle in the future for people wanting to switch from MySQL 5.6 to MariaDB 10.
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
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…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
@Kristian Does it mean that MariaDB 10 is incompatible with MySQL 5.6 GTID? You cannot replicate to/from a MySQL 5.6 host using GTIDs?
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 22, 2013 By 8 Comments
… are part of the reason we decided not to merge MySQL 5.6 global transaction ID into MariaDB. In MariaDB global transaction…
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… the popular RDBMS out there. java -jar schemaSpy_5.0.0.jar -t mysql -u msandbox_ro -p msandbox -meta schemaspy.meta… can then write into your metadata file. Donate – This is free software and John Currier asks for donations so he can…
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…
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…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on …is a copy on write filesystem, the snapshots are free, no performance penalty. You can easily run a … ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact …
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: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
… MySQL Meetup at Portland organized by our own Daniel Nichter, who recently moved to the area. Percona MySQL University is a daylong, free, fast-paced and very technical MySQL educational event for wide range of people interested in MySQL – Developers…
