… apply any rolling upgrade process. So like for Pacemaker 0.6.x to 1.0.x, you need again to update all nodes as… Stack: openais Current DC: percona1 – partition with quorum Version: 1.1.7-6.el6-148fccfd5985c5590cc601123c6c16e966b85d14 3 Nodes configured, 3 expected votes 7 Resources…_prm @ Thu May 23 10:20:36 2013 Member Status: Quorate Member Name ID Status —— —- —- —— percona1 1 Online percona2 2 Online percona3…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar Example Schema CREATE TABLE `parent` ( `parent_id` int(10) unsigned… to properly link child_A to parent table: 1.0” encoding=”UTF-8″?>
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB… Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database… recommended to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off …
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the –export flag… all of those statements for steps 7 and 10 in two scripts: mysql -N -B <<'EOF' > discard… VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other use cases that come to mind…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… current stable version should be used (currently 2.0.6 in the 2.0 series at the time of writing). This release contains… 2.0.6, plus the following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0… with all the bugfixes for Percona XtraBackup for MySQL 2.1.0-beta1 are available in our online documentation. Bugs can be…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
…bought any other software at the time. MySQL 4.1.0 was also available as an early alpha. 2004 … for MySQL Server – the online backup in MySQL 6.0, it’s to ship in commercial version only. … have from you attending MySQL Conference over last 10 years. Please leave comment and share your experiences! …
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… MacBook Pro) Centos 6.4 Single core VM 528M RAM Host-Only network 1 Box with http/php, 1 box with memcache or… = 0; $i < 100000; $i++) { $cache->save(new Object(), “key_$i”); } $totalTimeStore = $timer->stop(); $avgTimeStore = $totalTimeStore / 100000; $timer->start(); for ($i = 0; $i < 10; $i++) { for ($i = 0; $i < 100000; $i++) { $obj = $cache->load(“key_$i…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…255) DEFAULT NULL, `SPACE` int(10) unsigned DEFAULT NULL, PRIMARY KEY … PREC | +———-+—–+————-+——-+———+——+——+ | 741 | 0 | actor_id | 6 | 1794 | 2 | 0 | | 741 | 1 | first_name | 12 | 2162959 | 135 | 0 | | 741 …_FIELDS from indexes 0-1, 0-3, 0-2 and 0-4 respectively. …
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… This evolved into the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM file specified …36; $name.=chr(ord(‘0‘)+$n) if $n < 10; $name.=chr(ord(‘a’)+($n-10)) if $n >= 10; $c= int $c/36; …BIG_ROW); } Which is curiously gone from MySQL 5.6, it’s replaced by the following set of defines…
Comment: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
April 11, 2013 By 2 Comments
…-xtrabackup-2.0.6/bin/xtrabackup lrwxrwxrwx root/root 0 2013-03-19 17:29:37 percona-xtrabackup-2.0.6/bin/innobackupex-1.5.1 -> innobackupex drwxr-xr-x root/root 0 2013-03-19 17:29:38 percona-xtrabackup-2.0.6/share… Server 5.6 – xtrabackup_56 # MySQL 5.5.* – xtrabackup_55 # MySQL 5.6.* – xtrabackup_56 # MariaDB 5.5.* – xtrabackup_55 # MariaDB 10.0.* – xtrabackup…
