How to set up MySQL replication. And for debugging purpose, it will be great if I can run multiple MySQL instances on a single host. To set up MySQL replication, check these tutorials: MySQL Replication MySQL replication setup You can Setup multiple MySQL instances on single server. Read more: How to set the data replication factor of Hadoop HDFS? How to change an running HDFS cluster’s replication factor? How to check the replication factor of a file in HDFS? How to set the replication factor for one file when it is uploaded by `hdfs dfs -put` command line in HDFS? How to find out all files with replication factor 1 in HDFS? How to set replication factors for HDFS directories? How to repair a MySQL table? How to find out and change the storage engine of tables in MySQL