… the available instructions. The only extra step I had to take was to extract the offsets for the Percona Server version I was using for the test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL… support has been an important missing feature on the server, which has made using MySQL in PCI or SOX compliant environments, to name…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… personally only worked with one customer that’s using 5.6), is that I question its readiness. There have been some… in the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL server‘s…/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I saw…
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 transaction… to switch a slave to GTID. Simply STOP SLAVE on the slave server, CHANGE MASTER to make it use GTID to connect… or to restart or otherwise touch any other servers. I invite you to read the documentation or try it out in MariaDB…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…connections=13 max_threads=2002 thread_count=6 connection_count=6 It is possible that mysqld could …software/percona-server/. You may find information in the manual which will help you identify the cause of the crash….mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an …
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… produce an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But there’s a finite amount of engineer-years spent developing and testing the query optimizer. The… and the MySQL community at our events. The next one is in London on November 11-12, 2013. We also look forward to the…
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
… that support multiple copies of the source database. Would be interested if someone wanted to contribute on the MySQL side. Interesting that on… aggregating Oracle, SQL Server and MySQL into one source that the user or application sees. On the other hand following the VMware paradigm where one…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
Wow, I pulled all the 300GB drives out of my MySQL servers years ago. I don’t need the space of a 2TB drive, but they are way faster than the old… as fast as older SSDs. But the newer SSDs are as big, and much faster than the 300GB HDDs, on MySQL type loads.
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
@Kristian, Well, the (slave) server *knows* whether it is replicating in parallel or not, so it doesn’t have to always manage the general case. When it knows it uses single thread replication the “last executed” assumption is safe.
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…(such as the Pacemaker daemons) and it’s part of the RedHat cluster stack. If you were using some puppet recipes published previously here…:mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2 ] Now we can upgrade all servers to 6…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… is part two in what is now a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In…
