Writing Data to multiple DB servers

[Eddiefdz]

Hello,

I would like to know if there is anyone out there doing the following. Is anyone writing data to 2 different db servers and then having those servers keep the data synched between themselves. Essentially my problem is that i have too many users hitting a single box, I would like to load balance but my problem is that the boxes may not be at the same location so I may have to load balance over wan. Can anyone shed some light on the subject?

Thanks.

Eddie Fernandez
CCNA, Network+, A+, MCP

 

[ptheriault]

I have been looking into this for awhile now. Load balancing databases is not an easy task. If this is SQL 2005 you could use peer to peer replication. If it is sql 2000 you can use merge replication. You could also set up a Federated database.(Not recomemded!) What ever you choose it will not be easy to maintaine. for example how are you going to handle conflicts in the data. I have come to the conclusion that my best option was to purchase a single server that could handle the load. We put in with the following config 64bit, 8CPU, 12gb RAM RAID 10 SAN. If your server load is realy large then look into datacenter.

- Paul
- Database performance looks fine, it must be the Network!

 

[Eddiefdz]

I do have all my servers at a datacenter. My problem is that we now need a second datacenter on the west coast. We need to have major redundancy. I currently have a SQL Cluster but I need to figure out a way to get the data synced over the WAN.

Eddie Fernandez
CCNA, Network+, A+, MCP

 

[ptheriault]

datacenter is an OS version by windows for very large databases with extreamly large loads. Here is a link to merge replication.

http://www.databasejournal.com/features/mssql/article.php/1438231

- Paul
- Database performance looks fine, it must be the Network!