Replication is my next best option... However, at this time replication is
a one-way street, being if the master goes down the slave can not queue up
inserts so when the master comes back up they currently cannot sync back
together.
I believe I could accomplish something like this, using replication and then
synching the slave to master with php, if the master goes down.
Does anyone know the actual lag time when 100's of updates are happening per
minute?
- Can I insert into the master and select from the slave and get the latest
record in the very same script, nanoseconds later?
TIA!
.:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
Systems & Network Administrator :: Programmer
[ phone - 208.343.3110 ][ pager - 208.387.9983 ]
----- Original Message -----
From: "Peter Skipworth" <[EMAIL PROTECTED]>
To: "Nathan Cook" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 4:18 PM
Subject: Re: Mysql over NFS
> Nope...
>
> It's stated explicitly in the docs that this is a *Bad Idea* (with caps,
> even! *grin*). You'll need to look at other options - replication,
> possibly, either on to the same machine with your db on a different
> drive, or (probably preferable) onto a seperate box.
>
> regards,
>
> P
>
> On Tue, 6 Feb 2001,
> Nathan Cook wrote:
>
> > I am trying to setup some sort of loadbalancing and more importantly
> > fail-over-services for my mysql servers. I would like to have all the
data
> > stored on a RAID interface that will mirror the data and provide the
data to
> > two separate mysql daemons on two separate boxes. That way if one
daemon or
> > machine fails the other daemon can access the independent RAID.
> >
> > Is this possible and will two mysql daemons play nicely with each other
when
> > accessing data on a drive shared between the two computers?
> >
> > Essentially, can two mysql daemons play nicely with mysql data over a
RAID
> > or NFS?
> >
> > TIA,
> > Nathan Cook [ [EMAIL PROTECTED] ]
> >
> >
> > ---------------------------------------------------------------------
> > 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
> >
> >
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
