May 25, 2012

Post: Mirrored Binlogs patch

…, which going to be replacement for MirroredBinlogs, we still think mirroring binary logs is very useful for: Backup of binary logs… time High availability, to switch master load to slave with mirrored binary logs By request of our friends EngineYard we extracted… download patch by itself there http://www.percona.com/mysql/5.0.67-b6/patches/mirror_binlog.patch with docs on our wiki…

Post: Ultimate MySQL variable and status reference list

…in the Percona documentation …binlog_cache_sizeblogpercona.commanual Binlog_cache_useblogpercona.commanual binlog_direct_non_transactional_updatesblogpercona.commanual binlog_do_dbblogpercona.commanual binlog_formatblogpercona.commanual binlog_ignore_dbblogpercona.commanual binlog… innodb_mirrored_log…

Post: Aligning IO on a hard disk RAID – the Benchmarks

…IO bound. That said, benchmark was running on a Percona Server 5.0.92-87 with the following … = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M … on writes. Another interesting setting might be a [mirrored] RAID0 with many more stripes as not having …