… is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based… determined by your environment), it’s a safe bet that MySQL is up and running. That said, there are plenty of other MySQL…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… server can easily handle the write load of all the MySQL instances. The original idea was to configure them with raid… a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will be read from the other… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… to faster restore time XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We…
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… with no concurrency. The hardware for this test was provided by Adotomi. I will be blogging about raw performance of the… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a…-based replication by inspecting the output of SHOW SLAVE STATUS? Look at the last field, Auto_Position: # Slave #1 mysql> show slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion…
Comment: Converting Character Sets
June 12, 2013 By 22 Comments
… correct. There was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For… to store as many characters as the original column.” [followed by a complete explanation of why TEXT coverts to MEDIUMTEXT] Maybe…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you …
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
…, it is not easy going from Linux to illumos ZFS by giving up 10% total ram for metadata caching, but it… OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker. Maybe you guys…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… difference so I was likely not hitting a bottleneck caused by compression. If I use SSD for L2ARC, I’ll need… you posted. It is not an easy move for a MySQL dba to steal 20GB memory from the Innodb buffer pool…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…120MBps, I start to get nervous around 100MBps. By default Galera uses unicast TCP for replication. …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…
