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
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Recommended Answers
Jump to PostI 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.
All 2 Replies
blud
82
Linux Reject
Moderator
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
82
Linux Reject
Moderator
Here is the recent book purchase I made on MySQL Replication:
http://www.amazon.com/exec/obidos/tg/detail/-/0782141625/qid=1102017108/sr=8-7/ref=sr_8_xs_ap_i7_xgl14/002-1355426-1287257?v=glance&s=books&n=507846
So far I'm about half way through it, I'll let you know my opinion once I finnish it.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.