Replication
Cloning MySQL 5.6 instances
A tip for all those cloud users that like cloning database servers (as reported in my book Effective MySQL – Replication Techniques in Depth ). Starting with MySQL 5.6, MySQL instances have a UUID .
Read moreUse Replication for backups? Are you schemas consistent?
Many people have a master/slave MySQL environment of various different topologies, and many use the slave as a backup. Is your slave schema identical to your production schema? As long as an SQL statements completes without an error, your slave schema can differ.
Read moreHigher Availability (HA) starts with two database servers
Many early startups that use a single server for all services or a single database server for their website talk about how they would like to achieve higher availability with MySQL.
Read moreCommon MySQL Scalability Mistakes
This week I was one of the presenters at the first Surge Scalability Conference in Baltimore. An event that focused not just on one technology but on what essential tools, technologies and practices system architects need to know about for successfully scaling web applications.
Read moreMongoDB Experience: Replication 101
After successfully installing and testing mongoDB it’s very easy to create a replication environment. $ mkdir -p data/{master,slave} $ mongod --dbpath=`pwd`/data/master --master --port 28011 > master.log 2>&1 & # Always check your log file $ cat master.
Read moreMySQL Replication 102
One of the most asked questions is how to setup MySQL replication. The MySQL Reference Manual provides a good Replication How To as a starting guide on MySQL Replication 101.
Read moreNever let your binlog directory fill up
Recently with a client while running a number of disaster recovery tests I came across a nasty situation which was not part of the original plan and provided a far worse disaster situation then expected.
Read more