title: MySQL Replication (3 masters, 1 Slave)
body: <p>I am currently in the process of setting up mySQL replication.</p>
  
  <p>I need to get data from three places.</p>
  
  <p>So for example I have</p>
  
  <p><strong>NEED THIS DATA</strong><br/>
  server1 - database1<br/>
  server2 - database2<br/>
  server3 - database3<br/></p>
  
  <p><strong>STORE DATA HERE</strong><br/>
  server4 - database4</p>
  
  <p>I need this for reporting purposes.</p>
  
  <p>I have read you can not connect to more then one master. So with that being said I am going to try a "master-chain" topology because I think I understand what is going on with this one</p>
  
  <p>So the data flow will look like this</p>
  
  <p>server1 -> <strong>server2</strong> -> <strong>server3</strong> -> server4</p>
  
  <p><strong>server2</strong> and <strong>server3</strong> will have blackhole storage engines for the replicated databases so we don't actually store the information on these servers but the information is still logged to the binary-log so all the statements will trickle down to keep server4 up to date.</p>
  
  <p>Am I understanding this correctly?</p>