On Sun, Oct 20, 2002 at 10:52:22PM -0700, Steven Roussey wrote:
Other people can tell you more about replication and how it is
different from clustering or load balancing. And you can use it for
backup in a way too. It depends on your requirements though.
Yeah. And you can use replication
handling from 3M to 20M records/day with potentially a lot
of processing, live inserts/ updates etc.
How many records do you forsee? (There are some things to look up in the
manual to give MySQL a hint at the total size of the table so it can
start using longer internal pointers.)
How big are
Hi
Bigger than my experience, so just a suggestion - have you looked at
replication?
If you have a master which does all the processing and (multiple) slaves
which handle all the reads then you might benefit from cheaper Intel
hardware and have a more robust system to boot.
Good luck!
Peter
