Load balancing

Expand Post »

This is probably a dumb question:o but how does one do load balancing among multiple database servers? How are the servers constantly kept in sync? With the data that must constantly be exchanged to keep them in sync, is it even worth having load balancing? It seems to me that it would take double the amount of time to do a database write, but half the amount of time to do a database read.

Similar Threads

writting functional and non functional requirements (SRS documents) for LOAD BALANCING OF NETWORK TRAFIC, Project in IT Professionals' Lounge
QoS Load Balancing router in Networking
Network Load Balancing Manager? in Networking
pls help me for load balancing in Networking
trouble load balancing cisco in Networking

cscgal

Administrator

Staff Writer

Reputation Points: 1422

Solved Threads: 163

The Queen of DaniWeb

Offline

13,646 posts
since Feb 2002

Permalink

Dec 2nd, 2004

Re: Load balancing

I believe what you are looking for is SQL Replication, it does take a little bit longer to write, but if you get to the point where one server can not handle the ammount of read/writes then you *need* to have additional servers to space out the reads etc.

blud

Moderator

Staff Writer

Reputation Points: 154

Solved Threads: 18

Linux Reject

Offline

570 posts
since Apr 2004

Permalink

Dec 2nd, 2004

Re: Load balancing

Here is the recent book purchase I made on MySQL Replication:
http://www.amazon.com/exec/obidos/tg...books&n=507846

So far I'm about half way through it, I'll let you know my opinion once I finnish it.

blud

Moderator

Staff Writer

Reputation Points: 154

Solved Threads: 18

Linux Reject

Offline

570 posts
since Apr 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Networking Forum Timeline: Remote Access

Next Thread in Networking Forum Timeline: Netgear Cable modem + Router + Wireless AP

DaniWeb Message

Cancel Changes

User Name
Password