3 added 145 characters in body
source | link

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.

I have the following topology

City 1                                                City 2
Master <----> Distribution Master (EC2 Instance) <---> Slave

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.

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.

    Post Closed as "primarily opinion-based" by LowlyDBA, mustaccio, jcolebrand
2 added 98 characters in body
source | link

I have the nextfollowing topology

Master <----> Distribution Master (EC2 Instance) <---> SlaveServer

City 1                                                City 2
Master <----> Distribution Master (EC2 Instance) <---> Slave

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 getgets the data from Master and replicatereplicates to the Slave when getsa connection is established. Do you think i need SSD volumes for the Replication Master? Or a cold HDD (sc1) will be enough?.

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

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

Thanks in advance.

I have the next topology

Master <----> Distribution Master (EC2 Instance) <---> SlaveServer

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 get data from Master and replicate to the Slave when gets connection. Do you think i need SSD volumes for the Replication Master? Or a cold HDD (sc1) will be enough?. With a cold HDD i can get more space for much lower price.

Thanks in advance.

I have the following topology

City 1                                                City 2
Master <----> Distribution Master (EC2 Instance) <---> Slave

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.

1
source | link

Amazon EBS Type for MySQL Replication Server

I have the next topology

Master <----> Distribution Master (EC2 Instance) <---> SlaveServer

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 get data from Master and replicate to the Slave when gets connection. Do you think i need SSD volumes for the Replication Master? Or a cold HDD (sc1) will be enough?. With a cold HDD i can get more space for much lower price.

Thanks in advance.