Console Login

#mysql

All articles tagged with mysql

#mysql

Near-Zero-Downtime PostgreSQL and MySQL Migration via Replication

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…

Memcached or Redis for Caching and Sessions: A 2014 Reference

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.

OpenVZ failcnt: Diagnosing Memory Denials on a Shared-Kernel VPS

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.

Diagnosing MySQL I/O Bottlenecks on Linux: Scheduler, Mounts, InnoDB

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.

MySQL 5.5 I/O Tuning: InnoDB, Flush Settings, Scheduler, Swap

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.

MySQL 5.5 vs PostgreSQL 9.1: Choosing and Replicating Safely

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…