Console Login

Database Management Articles

Technical insights and best practices for Database Management

Database Management

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…

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…

Recent Searches