April 28, 2006 at 4:01 pm
I've just joined a company and they have this plan to revamp their site..
They want to separate their data writes from the reads..
The web/app 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:55 pm
I have a simple math solution for you :
2 servers = 2 times the costs
2 servers also means that the data has to be written twice instead of one which makes no sens unless you have a very special situation I've never heard of.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy