stability of replication?

2001-09-06 Thread Duc Chau
I just wanted to know how stable is mysql databse replication is? What we have in mind is a tiered system. $master (california)-<(internet ssh tunnel) \$slave (texas)< 10 other slave machines on the same network

index not incrementating

2001-09-06 Thread Duc Chau
Hi, can someone tell me how the index number on the bin logs are incremented? When i update my master machine the changes are still going to $machine-name-bin.001 on my slave its looking for Log_file $machine-name-bin.002 can someone tell me how these number are incremented? the .00# how

RE: mysql db replication security across the internet

2001-09-05 Thread Duc Chau
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 3:50 PM To: Duc Chau Subject: Re: mysql db replication security across the internet Your message cannot be posted because it appears to be either spam or simply off topic to our

FW: mysql db replication security across the internet

2001-09-05 Thread Duc Chau
Can anyone tell me or point me to documentation on how to securely do database replication over the internet? I need to replicate to machines in datacenters in diffrent states. How feasible is this? Has anyone done it? What are the security concerns with doing this via the net? Thanks ---

RE: replication problem

2001-09-05 Thread Duc Chau
25 AM To: Duc Chau Cc: [EMAIL PROTECTED] Subject: Re: replication problem The slave does not have a server-id. Duc Chau wrote: > Hi, this is my first time posting to the list. I've followed mysql > replications how-tos to a tee...and I am still not able to get it to work. > &g

replication problem

2001-09-04 Thread Duc Chau
Hi, this is my first time posting to the list. I've followed mysql replications how-tos to a tee...and I am still not able to get it to work. the master mysql is running on a sun sparc station (SunOS 2.8) with mysql 3.23.41 the file /etc/my.cnf is as follows: # The following options will be pa