… don’t like DRBD with virtual machines. First is the disk IO performance hit that comes with DRBD. When you run… should be directly connected from one machine to another and configured with Linux network interface bonding in balance-rr mode; this…, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… of all the MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to stripe the… ZFS a try. So I trashed the raid-10 arrays, configure JBODs and gave all those drives to ZFS (30 mirrors… from the other drive in the mirror. Better availability and disk usage On purpose, I allocated mirror pairs using drives from…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… a 4GiB buffer pool. The cache devices were flushed to disk immediately prior to and immediately following each test run. With… HDD storage configuration? After creating a vCache device with the default configuration, I started with a baseline HDD configuration for MySQL (configuration A, listed…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… buffer pool (thus leading to a lot of buffer pool disk reads) but still small enough to fit into the cache… driver you’ve already had to install, and then further configuration requires modification to assorted sysctls. I would also argue that… FlashCache due to configuration flexibility, but if the GA release of vCache added some of FlashCache’s additional configuration options and exposed…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… tries and wait time between tries for all operations are configurable. Also, we removed –lock-wait-timeout which set innodb_lock… was not really aware of them. And it’s highly configurable, so you can make the tool try very hard to… on a server. Granted, this can take a lot of disk space, but it allows you to “run now, compare later…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… malloc after the startup phase and hence its rather complex configuration. Probably most readers of this blog know (or should know… like: pt-stalk, vmstat, top, iostat, etc all saving to disk with the current time stamp in front of each line… size limit is 5GB. So, about 28GB was written to disk in a short while. Here’s the vmstat output during…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… or cart object built from several queries) Infrequently changing data (configurations, etc) In pseudo-code, here is the basic approach: data… into the buffer pool, so there are no reads from disk. However, there is write activity stemming from the fact that… additional system Impact of warmup time to application Cost of disk space on database server Now, there are definitely other NoSQL…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… have been added in MySQL 5.6, go over the configuration and spend most time showing how you can use the… typical performance bottlenecks. Other areas of focus include: Bottlenecks with Disk IO Problems with excessive temporary tables and external sorts Excessive…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… server has an issue. At Groupon, our standard MySQL database configuration follows this active/passive pattern. There is a virtual IP… after failover as the buffer pool pages were loaded from disk. Replaying Queries Working with Groupon, we have developed a solution…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… disk in the array. This is also one of the options you usually have to decide on very early when configuring RAID. Disk sectors Most if not all hard disk drives available on the market these… and actual disks, it’s not really all that difficult to get a proper alignment if you’re careful when configuring all…
