…MySQL 5.6. They open up a lot of opportunities to make the life of DBAs much easier when having to…of a series of articles focused on the implications of enabling GTIDs on a production setup. The manual describes very nicely how to switch to…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…”] Percona Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce the release of Percona Server 5.1… on MySQL 5.1.69, this release will include all the bug fixes in it. All of Percona’s software is open-source… has an empty LSN range and thus does not need to read any bitmap files. Bug fixed #1184427. Incorrect schema definition…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… a client that asked about using Percona Xtrabackup to take a snapshot of a particular MySQL schema and then reload it with a…-06-03_11-30/orig) Get the table structures: mysqldump –no-data orig > /tmp/orig.schema.sql Create the new target… included this helpful script to generate all of those statements for steps 7 and 10 in two scripts: mysql -N -B <<'EOF' > discard…
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… the 5.5 series. All of Percona’s software is open-source and free, all the details of the release can be found… MDEV-3915). Bug fixed #1172090. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding the…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… bug tracker. * * * Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for… verification Higher uptime due to faster restore time XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 22, 2013 By 8 Comments
These limitations are part of the reason we decided not to merge MySQL 5.6 global transaction ID into MariaDB. In MariaDB global… slave to GTID. Simply STOP SLAVE on the slave server, CHANGE MASTER to make it use GTID to connect, START SLAVE. There is no need for any special configuration or to restart or otherwise…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
…Yves: 1. Yes, it is not easy going from Linux to illumos ZFS by giving up 10% total ram for metadata… open source clustering solution. RSF-1 costs a lot. So OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker. Maybe you guys can get Galera working on OmniOS to solve our lack of clustering…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… a MySQL HA Solution, in which we’ll explore the topic of MySQL HA from each of these perspectives. The goal will be to motivate… use traditional MySQL replication, those which use some other MySQL-level replication, and those which replicate at some other layer of the system…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
… from MySQL 5.6 to MariaDB 10.0 or vice versa. You just won’t be able to use the GTID features to automatically pick the correct binlog position when switching to a new master. Old… of how to make MariaDB compatible without merging all of the crap that is MySQL 5.6 global transaction ID, I would very much like to…
Comment: How to Monitor MySQL with Percona's Nagios Plugins
May 20, 2013 By 11 Comments
…, Thanks for a great post, i was trying to implement a pmp-check-mysql-status plugin for server uptime is small, as it… CRIT Uptime = 4951 | Uptime=4951;;5;0; so how can i change it to alert only when the output is small as…
