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…
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
@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: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
…mathew: Wrong, it’s still the same in 5.5. Here is the related output from show engine innodb status: —…, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… server can easily handle the write load of all the MySQL instances. The original idea was to configure them with raid… correctly. We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on Linux is… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… (and in my opinion bad) part of the design of MySQL 5.6 global transaction ID. In general, there is no ordering…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
… 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 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: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
… type of query objective, and show how you can use MySQL 5.6 built-in methods to analyze them for optimal query…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…, this isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate… 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…
Comment: How to Monitor MySQL with Percona's Nagios Plugins
May 20, 2013 By 11 Comments
… great post, i was trying to implement a pmp-check-mysql-status plugin for server uptime is small, as it will… server crashes and i try these parameters -x Uptime -c 5 and my output is CRIT Uptime = 4951 | Uptime=4951;;5;0; so how can i change it to alert only …
