Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- database replication help needed
December 1, 2005, 8:16 pm
rate this thread
hard drives each 2 for OS (mirror) 2 for data (mirror) and 2 for Mysql
both are identical.
now without spending any extra cash on hardware, is there any way to
get a replicated or clustering filesystem?
i've looked high and low, and all over google, sourceforge, freshmeat,
slashdot, etc and I haven't had any luck.
Mysql replication doesn't work because it only fails-over and only
manually. no fail-back.
mysql clustering is OK, except the memory of the systems is only 1 gig,
and our database will grow to 1 gig in under a month. so that's out.
LinuxHA may be a possibility but it seems overly cumbersome and not
really workable for such a small environment.
NFS doesn't work, sure manual replication, but now fail over/back
ability at all.
the only possible things I've found which might work is CODA or
inter-mezzo, but they seem experimental.
yes I know the obvious answer is to use a SAN or storage array, but as
I said, we have no budget for hardware.
The systems have 3 NICs each, so some out of band syncing is certainly
I briefly considered NetwareFS and LDAP, neither are feasible.
anyone got any bright ideas? for something automated?
PS - this email address is dead, don't bother trying to contact
Re: database replication help needed
i.e both master and salve mirror each other per every transaction
you can even utilize this for load balancing with aid of ip load
balancer hardware which very less in cost and acts as fail over
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum
- » ssh on command line: force using a group size (prime size) of 1024 (and no...
- — The site's Newest Thread. Posted in » Secure Shell Forum