…: openais Current DC: percona1 – partition with quorum Version: 1.1.7-6.el6-148fccfd5985c5590cc601123c6c16e966b85d14 3 Nodes…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…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
…Kristian: Mixing versions/variants is common, the most typical scenario is when you … machines to see how it goes before deploying the new version on every server. Having such an incompatibilty could unfortunately become… hurdle in the future for people wanting to switch from MySQL 5.6 to MariaDB 10.
Comment: Percona XtraBackup 2.1.2 for MySQL available for download
May 22, 2013 By 4 Comments
… bug in the 2.1.1 and 2.1.2 version (see http://www.percona.com/forums/questions-discussions/percona-xtradb…-can-not-get-percona-xtradb-cluster-to-link-up-start-mysql-its-a-cluster-f). When I update i could not… and third node. I must rollback on 2.0.7 version, and now it’s ok. Why ? Best regards Azigui
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
…/lib/mysql/ib_logfile* -rw-rw—- 1 mysql mysql 536870912 May 21 22:23 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912 May…/mysql/ib_logfile1 Of course it is worth reiterating the point made by AFTAB, crash recovery is far cheaper in modern versions of InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster And from the manual: http://dev.mysql…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… large innodb database, do I have to export databases from mysql and import them in Percona server or can I use…? 2. What’s the advantage of using Percona server over MySQL? 3. I am using CentOS for my servers but i… apps in windows, do you think percona will release windows version as well? Thanks
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 3 Comments
…’t have to export databases, you can use the existing mysql data dir. But check http://www.percona.com/doc/percona….html 3) we’re not planning to release the windows versions of Percona Server at the moment
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… available for MySQL. Facebook mentions they have over 1,800 MySQL Servers. MySQL Enterprise provides Monthly Rapid Updates [MRU] while Community MySQL versions updated every quarter or so. MySQL 5.0.51a…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… corruption. MySQL provides the handy RESET SLAVE command. But as we’ll see, its behavior has changed along with the MySQL versions and… RESET SLAVE. For MySQL 5.5 and 5.6, run STOP SLAVE and then RESET SLAVE ALL. For all versions, ban master… set master-xxx variables in my.cnf! From MySQL 5.5 Starting with MySQL 5.5, the situation has slightly changed. First…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Server for MySQL version 5.5.30-30.2[/caption] Percona is glad to announce the release of Percona Server for MySQL 5…. Bug fixed #710799 (Alexey Bychko). Debian packages included the old version of innotop. Fixed by removing innotop and its InnoDBParser Perl… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.1.68-14.6[/caption] Percona is glad to… previously removed. Bug fixed #710799. Debian packages included the old version of innotop. Fixed by removing innotop and its InnoDBParser Perl… fixed #1032139. Percona Server was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
