… in Percona XtraBackup for MySQL 2.0.6, plus the following: New Features Percona XtraBackup for MySQL now has support for Compact Backups… now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1-builtin has been removed from Percona XtraBackup for MySQL…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… Utilities. Also the following Cacti graphs need to be recreated: MySQL “MySQL Threads”, Linux “Network Traffic”. A new tarball is available from… our software repositories. The plugins are fully supported for customers with a Percona Support contract and free installation services are provided as…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…, XtraBackup drives down backup costs while providing unique features for MySQL backup. The new 2.1.1 GA version offers improved… the 2.1 series. New Features: Percona XtraBackup now has support for Compact Backups. This feature can be used for taking… now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0…
Comment: Innodb Performance Optimization Basics
April 30, 2013 By 75 Comments
I founded that mysql supports flat, distributed, nested transactions! bur I couhd find nothing about chained,multilevel ! Does mysql supports these types or not? would you please guide me with example?
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
…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…encrypted? No, none of the default methods currently support SSL. However, SST is scriptable, so this …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing… use it to crash. Fixed by building packages with OpenSSL support rather than the bundled YaSSL library. Bug fixed #1104977 (Ignacio… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
Percona XtraBackup 2.0.7 has been published with support for GTID based replication. As promised, here is the step-… also printed by innobackupex after backup is taken: innobackupex: MySQL binlog position: filename ‘mysql-bin.000002′, position 1232, gtid_executed c777888a-b6df… restore procedure, for example remember to change the permissions to mysql:mysql. 4- Start the new slave from that GTID position: slave1…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… think is a little known goodie from Percona Toolkit for MySQL called pt-query-digest. One customer was suffering from periods… with thousands of connections. Enter pt-query-digest. The tool supports its share of format parsers, but the one that saved… issues. If you regularly work with MySQL databases, getting familiar with Percona Toolkit for MySQL will let you do more work, in…
Post: Why use encrypted backup with Percona XtraBackup 2.1 for MySQL?
April 10, 2013 By 2 Comments
… released our first alpha of Percona XtraBackup 2.1 for MySQL and with it we included the ability to encrypt backups… simple off-site backups. Percona XtraBackup 2.1.0-alpha1 supports industry standard AES encryption and we use an existing software…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… be able to choose from multiple suppliers of MySQL but it’s still MySQL, even if it’s some fork like Maria… free is what they care about. I’m a strong supporter of paying up for open source stuff – say subscribing to…. Your money will go towards supporting a significant number of open source projects, and you get support(maybe it sucks) at the…
