Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now
3 of 3 added 145 characters in body

Amazon EBS Type for MySQL Replication Server

I have the following topology

City 1                                                City 2
Master <----> Distribution Master (EC2 Instance) <---> Slave
  • Master : Write heavy
  • Distribution Master: Read only
  • Slave: Read only

There won't be any application in front of Distribution Master.

Distribution Master is slave of Master and Master of SlaveServer . Master and Slave are in different cities and the replication needs to be Asynchronous.

The EC2 instance just gets the data from Master and replicates to the Slave when a connection is established.

  • Do you think I need SSD volumes for the Replication Master?
  • Or will a cold HDD (sc1) will be enough?

With a cold storage solution I can get more space for a much lower price.