…caption id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.1.69-14.7[/caption] Percona is glad…. A drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this… fixed #1079688, bug fixed #1132412, bug fixed #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… Server for MySQL version 5.5.31-30.3[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5… packaging regression that was introduced with the fix for bug #710799. This regression caused mysql schema to be missing after the clean… from the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL 5…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… to announce the release of Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available from our download… performing State Snapshot Transfer. Bug fixed #1182698. Release notes with all the bugfixes for Percona XtraBackup 2.1.3 are available in…, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We recommend support for critical production deployments.
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… looking for other examples you can find a more comprehensive example here. Running SchemaSpy The syntax below if 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… be accessed by a web server. Also note that since I created the mysql.properties file in the same directory as the…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… be created-, but we will get a warning (note severity, to be exact): mysql> ALTER TABLE test ADD INDEX (col2); Query OK… sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: Duplicate index ‘col2_2′ defined… tools like pt-duplicate-key-checker will not be necessary for MySQL 5.6? Let’s have a look at the code…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…] /var/lib/mysql/orig_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run… without needed to grant access to another “backup” server. As noted by one of my colleagues (thanks Bill Karwin!), the cumbersome… script to generate all of those statements for steps 7 and 10 in two scripts: mysql -N -B <<'EOF' > discard-ddl.sql…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…caption id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad… available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it… fixed #1182837, bug fixed #1177780, bug fixed #1154954. Release notes for Percona Server for MySQL 5.6.11-60.3 are available in our…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the InnoDB tests, a… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…on one server… NOTE: In production … [ OK ] Starting cman… [ OK ] Waiting for quorum… [ OK ] Starting fenced… [ OK ]…MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…, the more the bandwidth required for replication multiplies. Now, this isn’t really much different from standard mysql replication. 1 master with… 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…://239.192.0.11 And this works fine. Pretty slick! Note that IST and SST will still use TCP unicast, so…
