All articles tagged with mysql
How to move a large live PostgreSQL or MySQL database to a new server with streaming replication and a short write freeze, including the pitfalls in common…
When to use Memcached or Redis 2.8 for caching and PHP sessions on CentOS 6. Covers persistence, eviction, AOF fsync stalls, and a split-instance setup.
How to tell when an OpenVZ container is being refused resources: read user_beancounters, interpret failcnt, and shrink MySQL and Apache to fit the limits.
How to confirm that MySQL 5.5 is stuck on disk I/O, and how to tune the I/O scheduler, ext4 mount options and InnoDB settings for flash or fast virtual storage.
Cut disk waits on a MySQL 5.5 server on CentOS 6: convert tables to InnoDB, size the buffer pool and logs, set the flush policy, I/O scheduler and swappiness.
Why asynchronous replication can lose committed transactions, and how MySQL 5.5 semisync and PostgreSQL 9.1 synchronous replication address it on a CentOS 6…