June 20, 2013

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… this to make life easier, however, wouldn’t it be nice if this was built into the system itself? PXC based…

Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

… enabling GTIDs on a production setup. The manual describes very nicely how to switch to GTID-based replication, I won’t… a lot of servers to reconfigure. It would be really nice to be able to mix servers where gtid_mode is…

Post: Implementing SchemaSpy in your MySQL environment

… on crontab so that schema changes are automatically picked up.  Nice, eh? Usage of this tool is very straightforward and it…

Comment: ZFS on Linux and MySQL

Nice to see this writeup on ZFS and MySQL. One question, …

Comment: ZFS on Linux and MySQL

Nice article! Actually I ran into performance issues during testing ZFS …

Comment: ZFS on Linux and MySQL

… metadata block size etc.). b) For #a, it would be nice if btrfs (from 3.9) and zfsonlinux (latest) are benchmarked…

Comment: ZFS on Linux and MySQL

Nice post Yves! Had any chance to try using ZFS volumes via iSCSI? Also why no mention of using SSD drives for L2ARC?

Comment: Sphinx search performance optimization: multi-threaded search

…, hence only run indexer on idx1p0,idx1p1,idx1p2. Have a nice weekend! Aurimas

Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster

Hi Peter, Nice article. Recently we shifted on following new dedicated server. From …

Post: Virident vCache vs. FlashCache: Part 2

… vCache with the time-based flushing that we see some nice, predictable, constant performance. So why is it the case that…