March 18, 2003 at 6:34 pm
Hi All,
I'm wondering if anyone tried to use merge replication in SQL2000 for read/write load balancing?
I've played with the following config: 2 x SQL2000 Standard behind 2 x MS2000 Advanced with Network Load Balancing.
With merge repl. setup between them all the Inserts/Deletes I've sent to either server directly or to the cluster IP end up to be in both databases. So effectively it worked like two-way repl...
What do you think guys?
Is it feasable? robust? reliable?
thank you,
Kirill
March 19, 2003 at 6:28 am
I personally would worry about database consistancy issues. I would setup one reader and one writer. Writer would have no indexes and replicate all changes to the reader that way you could split the load up between the two servers. Also if you have a failure you don't have to worry about inconsistant databases you would even turn the reader up and let people write to it while the server is being repair etc etc.
Just my thoughts.
Wes
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply