June 18, 2013

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

… are part of the reason we decided not to merge MySQL 5.6 global transaction ID into MariaDB. In MariaDB global transaction… read the documentation or try it out in MariaDB 10.0: https://kb.askmonty.org/en/global-transaction-id/

Post: 10 years of MySQL User Conferences

… an IPO, and MySQL 6.0 was to ship the next year. MySQL releases are split between the MySQL Community, and MySQL Enterprise is released with… first “open core” plans are announced for MySQL Server – the online backup in MySQL 6.0, it’s to ship in commercial version only. An Innodb Plugin is announced and will be separate from MySQL Server…

Post: Percona XtraBackup 2.1.0 for MySQL beta now available

… glad to announce the release of Percona XtraBackup 2.1.0 for MySQL beta on April 22, 2013. Downloads are available from… MySQL 2.0.6, plus the following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0… notes with all the bugfixes for Percona XtraBackup for MySQL 2.1.0-beta1 are available in our online documentation. Bugs can…

Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)

….0 and 5.1, run STOP SLAVE, CHANGE MASTER TO MASTER_HOST=” and then RESET SLAVE. For MySQL 5.5 and 5.6…, 0 rows affected (0.02 sec) mysql> reset slave; Query OK, 0 rows affected (0.04 sec) mysql> show slave status\G Empty set (0.00 sec) mysql> start… behaves differently: mysql> stop slave; Query OK, 0 rows affected (0,01 sec) mysql > reset slave; Query OK, 0 rows affected (0,11 sec) mysql> show slave…

Post: Percona Live MySQL Conference 2013 wrap-up

… Zaitsev from Percona and the keynote panel on MySQL 5.6 and the future of MySQL in the cloud with all of these… Oracle development discipline MySQL 5.0 and 5.1 were rushed and not properly tested but 5.5 and 5.6 were significantly improved and 5.7 promises to be more of the same The future for the MySQL community…

Post: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released

… 2.0.6 was released March 20.[/caption] Percona is glad to announce the release of Percona XtraBackup 2.0.6 for MySQL 5.6 on… the 2.0 series. New Features: XtraBackup 2.0.6 has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0. Basic… notes with all the bugfixes for Percona XtraBackup 2.0.6 for MySQL 5.6 are available in our online documentation. Bugs can be…

Post: Understanding the maximum number of columns in a MySQL table

… for generating reports. This evolved into the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM file specified what…_ERR_TO_BIG_ROW); } Which is curiously gone from MySQL 5.6, it’s replaced by the following set of defines #define… what I can create. That’s right folks, in MySQL 5.6 you can create a table with a few more columns…

Post: Percona XtraBackup 2.1.0 for MySQL alpha now available

… glad to announce the release of Percona XtraBackup 2.1.0 for MySQL alpha on April 2, 2013. Downloads are available from… bug fixes in Percona XtraBackup for MySQL 2.0.6, plus the following: New Features Percona XtraBackup for MySQL now has support for Compact… notes with all the bugfixes for Percona XtraBackup for MySQL 2.1.0-alpha1are available in our online documentation. Bugs can be…

Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo

…Engineer, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks, Tuning, and… Chief Evangelist for MariaDB for Monty Program Topic: “MariaDB 10.0 & What’s New With the Project” Sergei Petrunia, Optimizer …

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

… support for MySQL 5.6 and Percona XtraDB Cluster We started beta support for MySQL 5.6 in 2.1.8 when 5.6 was still beta. Now that MySQL 5.6 is GA, so… that we have four base versions of MySQL (5.0, 5.1, 5.5, and 5.6), plus at least four major forks…