Load balancing

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Networking Hardware Configuration section within the Tech Talk category of DaniWeb, a massive community of 456,272 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,421 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Networking Hardware Configuration advertiser: Programming Forums

Thread Tools Display Modes

Views: 2121 | Replies: 2

•

Join Date: Feb 2002

Location: Lawn Guylen, NY

Posts: 11,019

Reputation: cscgal is just really nice

Rep Power: 33

Solved Threads: 116

cscgal

Online

The Queen of DaniWeb

Load balancing

Nov 26th, 2004

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.

Dani the Computer Science Gal
Do you run a computer-related website? Feature it in our niche link directory!

•

Join Date: Apr 2004

Location: Dallas, Tx

Posts: 373

Reputation: blud will become famous soon enough

Rep Power: 6

Solved Threads: 5

blud

Offline

Linux Reject

Re: Load balancing

Dec 2nd, 2004

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.

•