On Thu, Jan 29, 2004 at 11:47:52PM -, Andrew Braithwaite wrote:
I believe MySQL 4.1 has support for ssl replication but it's still alpha at
the moment.
If you are referring to connecting to a MySQL server from an application to
query it then the following applies:
---from the manual---
When you
EMAIL PROTECTED]
Subject: Re: Read Slaves, and load balancing between them...
On Thu, Jan 29, 2004 at 03:40:17PM -, Andrew Braithwaite wrote:
>Hi,
>
>I employ a simple method, I have a 'status' table on the master and
>have a cron job that updates this table with the c
On Thu, Jan 29, 2004 at 03:40:17PM -, Andrew Braithwaite wrote:
Hi,
I employ a simple method, I have a 'status' table on the master and have a
cron job that updates this table with the current time (now()) every minute.
I test all the slaves each minute and if the time in the status table gets
From: James [mailto:[EMAIL PROTECTED]
> Mike & Andrew,
> Excellent ideas...
>
> The reason I am considering checking the log location, is
> because normal lusers will be using this software, so it
> won't be too good for them to see errors about the slave
> being out of synch. (Some 20 peopl
ad Slaves, and load balancing between them...
From: James [mailto:[EMAIL PROTECTED]
> I am interested in setting up 3 read only slaves and one
> write master. I am thinking of implementing this because
> one server is slower than 3 ;-). But anyway, I have read
> all the docs and I
Hi,
I employ a simple method, I have a 'status' table on the master and have a
cron job that updates this table with the current time (now()) every minute.
I test all the slaves each minute and if the time in the status table gets
too far behind the actual time then it flags a warning to me.
Chee
From: James [mailto:[EMAIL PROTECTED]
> I am interested in setting up 3 read only slaves and one
> write master. I am thinking of implementing this because
> one server is slower than 3 ;-). But anyway, I have read
> all the docs and I am fairly sure how I want do this and
> keep the sanity ch
