1 Reply Latest reply: Mar 27, 2012 4:54 AM by Ferran Garcia Pagans RSS

Can I get Realtime? Using a slave replication to get as close to realtime as possible

robinsheedy

Hi All,

And thanks for any answers or opinions in advance.

Our company has many sites across Australia and im told our implementation partner is looking to have overnight refreshing of QV data to keep the server overhead to a minimum.

This isnt ideal for some users, so has anyone heard of/tried/failed to use Database Replication and use the replication/s to handle constant refreshes?

 

  • This would seperate infrastructure and keep the write databases as fast as possible
  • It would allow data feeds to wherever necessary and only files that need to be updated constantly can be.

 

Does anyone have any comments and suggestions?

Thanks