April 28, 2006 at 4:03 pm
I accidently added it to the replication thread instead of general.
My apologies for double posting..
I've just joined a company and they have this plan to revamp their site..
They want to separate the writes from the reads..
The web servers would hit one server to write data and another to read data.
The writerSQLServer would then do transactional replication to the ReadSQLServer.
Their main concern is being able to grow as needed, with this model, they say they can keep adding reads/writes servers as needed.
My concern is the impact on an application having to read/write from two different servers and once we start adding we will have to start using merge? replication.
Any thoughts?
April 28, 2006 at 9:56 pm
I already answered here :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=291&messageid=276417
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply