Question about replication

2005-04-12 Thread Luis Calero
Hello, I've been discussing with a coworker if it's possible to setup the following replication scenario: We've got two boxes, machine A that has machine B as his master, and machine B that has machine A as his master (A-B B-A), both boxes are masters and slaves. Over this two boxes there's an

Re: Question about replication

2005-04-12 Thread Gleb Paharenko
Hello. Similar questions are often asked in the list. Search in archives about various solutions at http://lists.mysql.com/mysql. See: http://dev.mysql.com/doc/mysql/en/replication-faq.html Luis Calero [EMAIL PROTECTED] wrote: Hello, I've been discussing with a coworker if it's

Re: Question about replication

2005-04-12 Thread Atle Veka
Here are two posts on list that you might find relevant: http://lists.mysql.com/mysql/182017 http://lists.mysql.com/mysql/180889 Atle - Flying Crocodile Inc, Unix Systems Administrator On Tue, 12 Apr 2005, Luis Calero wrote: Hello, I've been discussing with a coworker if it's possible to

Another Question About Replication

2004-02-16 Thread Ronan Lucio
Hi All, A short question: If I have a slave MySQL Server (updating via logs). Supposing the master MySQL (for any reason) goes down. The users start using (and updating) the slave database. When the master MySQL goes up. Does it will update it´s data from the slave database? Thank´s Ronan

Re: Another Question About Replication

2004-02-16 Thread Jeremy Zawodny
On Mon, Feb 16, 2004 at 02:41:30PM -0300, Ronan Lucio wrote: Hi All, A short question: If I have a slave MySQL Server (updating via logs). Supposing the master MySQL (for any reason) goes down. The users start using (and updating) the slave database. When the master MySQL goes up. Does

Re: question about replication

2004-02-11 Thread Victoria Reznichenko
Liying Huang [EMAIL PROTECTED] wrote: I have tried to upgrade mysql to 4.0.17 version, still have the same problem. All queries shown in relay-bin file at slave, but slave database is not updating. I read documentation, but can't find helpful information on this. Do you use any replicate-*

Re: question about replication

2004-02-11 Thread Liying Huang
Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 6:50 AM Subject: Re: question about replication Liying Huang [EMAIL PROTECTED] wrote: I have tried to upgrade mysql to 4.0.17 version, still have the same problem. All queries shown in relay-bin file

Re: question about replication

2004-02-11 Thread Liying Huang
Hi, I have done a show processlist\G right after I start slave. *** 1. row *** Id: 1 User: martin Host: localhost:1110 db: NULL Command: Query Time: 0 State: NULL Info: show processlist *** 2. row

Re: question about replication

2004-02-10 Thread Victoria Reznichenko
Liying Huang [EMAIL PROTECTED] wrote: I tried to create replication. I have edited my.cnf on master and slave side. Grant necessary privileges on master side, then start both servers, when I update the database in master side, I could see the query showed up in ***-bin.001, and it is

Re: question about replication

2004-02-10 Thread Liying Huang
I only replicate the simplest, master-slave. I used MySQL 4.0.11 version in both PCs. Liying - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 5:32 AM Subject: Re: question about replication Liying Huang [EMAIL

Re: question about replication

2004-02-10 Thread Liying Huang
I have tried to upgrade mysql to 4.0.17 version, still have the same problem. All queries shown in relay-bin file at slave, but slave database is not updating. I read documentation, but can't find helpful information on this. Liying -- MySQL General Mailing List For list archives:

question about replication

2004-02-09 Thread Liying Huang
Hi, I tried to create replication. I have edited my.cnf on master and slave side. Grant necessary privileges on master side, then start both servers, when I update the database in master side, I could see the query showed up in ***-bin.001, and it is passed to slave side successfully, shown

Question about replication

2003-01-06 Thread Chambon
Hello I am using Mysql and Innodb tables since one year with great success. Everything works fine. Now I try to set up a master/slave replication architecture. master slave pc Linux rh 6.2 pc Linux rh 6.2 version 3.23.47 version 3.23.54 I have

Re: Question about replication

2003-01-06 Thread Jeremy Zawodny
On Mon, Jan 06, 2003 at 04:56:38PM +0100, Chambon wrote: Hello I am using Mysql and Innodb tables since one year with great success. Everything works fine. Now I try to set up a master/slave replication architecture. master slave pc Linux rh 6.2 pc

Re: question about replication - a very simple one - I know they all

2002-08-22 Thread Victoria Reznichenko
Norris, Wednesday, August 21, 2002, 6:44:51 PM, you wrote: N I have just got into a situation in which I need to explore replication and N I know nothing about it. Can any one direct me to specific documentation on N this and maybe a simple tutorial for the greener of us? Check the appropriate

question about replication - a very simple one - I know they all say that - but this is - sql, query

2002-08-21 Thread Norris, Joseph
(filter bypass words - Mysql, sql, query) Group, I have just got into a situation in which I need to explore replication and I know nothing about it. Can any one direct me to specific documentation on this and maybe a simple tutorial for the greener of us? Thanks.

question about replication under version 3.23.38 for Unix (database)

2001-05-21 Thread Joseph Chow
HI, everyone, I met a problem about setting up replication(master/slave) of mysql sever on unix boxes. Mysql servers are installed under /usr/local/ on master and slave and they can be run under /usr/local/mysql/bin. It seems to me that I have three choices where to put my configuration