Re[2]: mysql high availability

2001-05-31 Thread Gabriel Ambuehl
-BEGIN PGP SIGNED MESSAGE- Hello Matt, Wednesday, May 30, 2001, 11:31:03 PM, you wrote: > Another thought on this: What happens when you are using multiple > SQL servers (for HA) and the primary is down? With having a small > program that gets called by tcpserver, it's going to try to c

RE: mysql high availability

2001-05-30 Thread Matt Simerson
e want connections to return to the first MySQL server we can have tcpserver periodically attempt to reconnect to the primary SQL server. Matt > -Original Message- > From: Sean C Truman [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 30, 2001 12:52 PM > To: Matt Simerson; Ken

Re: mysql high availability

2001-05-30 Thread Sean C Truman
- From: "Matt Simerson" <[EMAIL PROTECTED]> To: "'Sean C Truman'" <[EMAIL PROTECTED]>; "Ken Jones" <[EMAIL PROTECTED]>; "Dave 'Duke of URL' Weiner" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday,

RE: mysql high availability

2001-05-30 Thread Matt Simerson
et/computing/mail.shtml and is found under the link entitled "tcpserver MySQL patch" Matt > -Original Message- > From: Sean C Truman [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 30, 2001 6:50 AM > To: Ken Jones; Dave 'Duke of URL' Weiner > Cc:

Re: mysql high availability

2001-05-30 Thread Dave Weiner
> Hi Dave, Hi Ken! :) > Yes, I was looking at that. > The first thing that I ran into is trying to minimize database > transactions during a pop access. The authentication part is > easy, just read the user info from mysql. > > There are two optional transactions that do updates during > an auth

Re: mysql high availability

2001-05-30 Thread Sean C Truman
: "Ken Jones" <[EMAIL PROTECTED]> To: "Dave 'Duke of URL' Weiner" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, May 30, 2001 7:28 AM Subject: Re: mysql high availability > Hi Dave, > > Dave 'Duke of URL' Weiner wr

Re: mysql high availability

2001-05-30 Thread Ken Jones
Hi Dave, Dave 'Duke of URL' Weiner writes: >> This is probably worth talking about now, since we are working >> on the mysql module for the next several weeks. Using Matt's >> read/update patch as a starting point the mysql functions >> are broken up into read-only queries and update queries >>

Re: mysql high availability

2001-05-30 Thread Ken Jones
of vchkpw. > > Mark > > - Original Message - > From: "Jeffrey Iskandar Ahmad" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 29, 2001 7:26 PM > Subject: mysql high availability > > > Hi guys, > Is there

Re: mysql high availability

2001-05-29 Thread Mark Lane
Sent: Tuesday, May 29, 2001 7:26 PM Subject: mysql high availability Hi guys, Is there a feature to enable failover if primary mysql does not respond and go to secondary mysql server. Is there anyway to enable multiple point of failure in any kind of setup?. Thanks Regards, Jeffrey Iskandar

mysql high availability

2001-05-29 Thread Jeffrey Iskandar Ahmad
Hi guys, Is there a feature to enable failover if primary mysql does not respond and go to secondary mysql server. Is there anyway to enable multiple point of failure in any kind of setup?. Thanks Regards, Jeffrey Iskandar Ahmad System Engineer Technology Division Time dotNet bhd