June 20, 2013

Comment: Upgrading MySQL

….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…

Post: Percona Toolkit for MySQL Webinar Followup Questions

… time to answer all of the questions during Wednesday’s MySQL webinar, “5 Percona Toolkit Tools That Could Save Your Day… typo, the correct link is percona.com/get/percona-toolkit.tar.gz. The other links are correct. Q: Can you run pt… the sakila database 1 master and 2 slaves installed with MySQL Sandbox, with the sakila database Thanks to everyone who attended…

Post: Percona XtraBackup 2.0.7 for MySQL available for download

… for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… it was missing from the source .tar.gz package. Fixed by adding the missing binary to .tar.gz as well. Bug fixed #1158948. innobackupex… #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer…

Comment: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released

MySQL version, but no xtrabackup_56 is included in the release? -bash-3.2$ tar -tvf percona-xtrabackup-2.0.6-521.tar.gz…_xtrabackup_version { # Based on MySQL version choose correct binary # MySQL 5.0.* – xtrabackup_51 # MySQL 5.1.* – xtrabackup_51 # MySQL 5.1.* with InnoDB… – xtrabackup_55 # Percona Server 5.6 – xtrabackup_56 # MySQL 5.5.* – xtrabackup_55 # MySQL 5.6.* – xtrabackup_56 # MariaDB 5.5.* – xtrabackup…

Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet

…source/Percona-Server-5.5.29-rel29.4.tar.gz unpack and build. Not, not so simple, unfortunately…we will have binaries in /usr/local/mysql, which we start mysql> show variables like ‘version%’; +————————-+——————————+ | Variable_name | Value | …

Post: Using MySQL Sandbox with Percona Server

… tools if you’re working with multiple versions of MySQL Servers is MySQL Sandbox which allows you to maintain many different versions…-401.Linux.x86_64.tar.gz unpacking /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz Executing low_level…-401.Linux.x86_64.tar.gz unpacking /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz Executing low_level…

Post: MySQL 5.5.8 - in search of stability

…. For the initial tests, I used MySQL 5.5.8 (the tar.gz binary from dev.mysql.com), and for the other tests I… post, I am sharing the percona-server-5.5.8.tar.gz I used for testing, but please note: It is very… NOTPM. The throughput is about 1.33x better than in “MySQL compatible mode”, though it requires 10500MB for checkpoint age; that…

Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T

… (Links removed) We added one more RPM to stantard MySQL RPMs – MySQL-microslow-5.0.33-0.glibc23.x86_64.rpm This…-tools/ http://bugs.mysql.com/bug.php?id=25412 Also we propose Linux (AMD64 / Intel EM64T) binaries in tar.gz archive (Link removed) The archive contains both mysqld and mysqld-microslow binaries. Source tar.gz with microslow patch (Link…

Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release

… talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster: New…: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona Server Application compatibility. There is no or minimal application…, please report to our bug tracking system. Links: We provide tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and…

Post: Percona Server 5.5.15 + Galera 21.1-beta2

…/Galera/Percona-XtraDB-Galera-5.5.15.tar.gz What difference between Percona Server+Galera and MySQL 5.5.15 ? First of course… new High Availability + Scalability solution for MySQL. And this solution is radically different from regular MySQL replication. You can actually think about… node. Setup of 3-master active MySQL Replication is practically impossible. 2. In contrast to MySQL replication, in Percona Server+Galera schema…