… look for me there. You can checkout the sessions I’ll be leading here. In my last post, I described a solution for… SIGHUP When copytruncate is disabled, MySQL must be told to reopen the slow log file. There are two options for signaling: Send… during log rotation. Putting it all together Here is a logrotate configuration file for a slow log that illustrates these best practices…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… via SSL for secure transfer of your replicated data. Setting this up is actually quite easy to do and probably will look familiar… is what is called a Distinguished Name or a DN. There are quite a few fields but you can leave some blank For… for SST in this case: each node was shutdown cleanly, and brought back up cleanly. As soon as the first node is…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… 5.6, run STOP SLAVE and then RESET SLAVE ALL. For all versions, ban master-user, master-host and master-password… as all the relay log files. This looks great, but does it ensure the replica is disconnected from its master? Let’s… you run START SLAVE (or if it’s done automatically, for instance when restarting the server without the skip-slave-start…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…. For the REPEATABLE_READ isolation level, the snapshot is created on the first SELECT for each transaction. For lower isolation levels it is created for each SELECT, even within the same transaction. Why is that a major problem for… read-only limitations. Let’s take a look at the following benchmark: This is the so-called QPS-mode POINT_SELECT benchmark…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… to look solely at vCache performance under some different sets of MySQL configuration parameters. For example, given that the front-end device is… for vCache + time-based flushing, around 6000 for vCache without time-based flushing, and somewhere around 2500 for FlashCache. We can take a look…
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
…-galera-practice-part-2 Migrating to Percona XtraDB Cluster for MySQL This is a 1-hour talk that covers the ins and…-use cases), as well as a practical look at what configuring a PXC setup looks like. Again, Galera / MariaDB Galera Cluster users… Codership folks should be in attendance. I can’t speak for any representatives from the MariaDB Galera Cluster team, but they…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… assorted sysctls. I would also argue that the vCache documentation is superior. Winner: vCache. Ease of post-setup modification / advanced installation… the other direction. Stay tuned for part two of this series, wherein we’ll take a look at some benchmarks. There’s no razor-thin margin of victory for either side here: vCache…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… for the sysbench fileIO tests, the EXT4 filesystem was used. The card itself is the 700GB model. So let’s take a look at the data. With the sysbench fileIO test in asynchronous mode, read performance is an extremely steady…: And in this graph we look at the card’s performance on sysbench OLTP: It is worth noting here that EXT4 outperforms…
Comment: How to start a Percona XtraDB Cluster
April 27, 2013 By 10 Comments
This had me stumped for too long, so hopefully it will help someone out there. … then be sent to mysqld via $@. This is how your /etc/init.d/mysqld should look after editing: shift “${PERCONA_PREFIX}”/bin… & This was done on 5.5.30, but should work for other versions too. Ciao!
Comment: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
Thanks for the info. I looked at the pt-query-digest documentation but can’t see any mention of –type for rawlog option….html#cmdoption-pt-query-digest–type ? I see 4 types for binlog, genlog, slowlog and tcpdump ?? Is rawlog undocumented ? cheers
