Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Blastrix
Posting Yak Master
208 Posts |
 Posted - 2003-09-25 : 13:43:08
|
| We're looking at implementing a multiple live database system, one master server which deals with data modification, and 3 read-only servers. Data will need to be synchronized with the master once an hour. If the master server is swamped with inserts and updates all throughout the hour time period, then when we replicate to the read-only servers, aren't we just taking the load of the master server and placing it on the read-only servers? What I mean, is that if the master is busy all hour, won't the read-only servers be swamped once they get the inserts and updates? Is there a process that optimizes this and causes the read-only servers to be updated in a fraction of the time?Thanks,Steve |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-25 : 13:49:32
|
| Yes, the read-only servers would have a bunch of processing to do once they receive the inserts and updates. But isn't the point of the read-only servers to off load the selects to another server so that inserts and updates aren't affected. This is what we have for our reporting server. For reporting we don't care as much how fast things run, so we moved that to another server that is replicated to.Tara |
 |
|
|
|
|
|
How is Replication Beneficial?