I have read on replication, just recently.
What I could gather from the manual: The replication creates an exact
mirror of a database on another server using a parent server to a daughter
server method.
Which brings up two issues: How long is the lag? How could I use this to
load balance?
My thoughts are: If the lag time is insignificant than I could use a php
script to round-robin connect between the two db servers and load balance
selects that way, but inserts _have_ to be done to the parent.
Now, using php and theoretically if both servers are identical, when the
parent was disconnected I could have the inserts go directly to the daughter
server, but then when the parent comes back-up they need to be able to
synchronize. Any ideas on how to do this?
I just need some way for two servers to provide the exact same information
at near perfect real-time and if machine A goes down then machine B will
take all requests and then re-sync when machine A comes back online.
It seems like this is impossible without some sort of two way replication
available.
Any input is welcome. Thank You!
.:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
Systems & Network Administrator :: Programmer
[ phone - 208.343.3110 ][ pager - 208.387.9983 ]
----- Original Message -----
From: "Jeremy D. Zawodny" <[EMAIL PROTECTED]>
To: "Nathan Cook" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 1:51 AM
Subject: Re: Load Balancing.
> On Tue, Jan 30, 2001 at 02:35:29PM -0700, Nathan Cook wrote:
> >
> > It seems like I have seen somewhere that load balancing and
> > fail-over-services are available for MySQL, to share the load and
> > mirror the data between two machines.
>
> Other than MySQL's built-in replication, which doesn't handle
> fail-over yet, I don't know of any which are MySQL-specific.
>
> There are various open source and commercial projects/products which
> do high-availability for various services on Linux, but I don't have
> any experience with them.
>
> I'd appreciate hearing back on the list about what you discover. I'm
> sure others would as well.
>
> Good luck,
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 328-7878 Fax: (408) 530-5454
> Cell: (408) 439-9951
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
