RE: Re: Replication, Stored Proceedures and Databases

2009-07-11 Thread Gary Smith
> -Original Message- > From: Claudio Nanni [mailto:claudio.na...@gmail.com] > Sent: Saturday, July 11, 2009 2:44 AM > To: Simon J Mudd > Cc: mysql@lists.mysql.com > Subject: R: Re: Replication, Stored Proceedures and Databases > > You dont have changes coming from db G since it is ignore

Re: RE: Replication Performance

2004-07-02 Thread MaFai
Dear ALL: Some time the slave would crushed by I/O error.It happen at the server with the lower CPU.( per 45 days ) All of the slave database has block the binary log,it reduce the CPU loading. The database would replicate text,int,varchar but no blob. Network connection hasn't drop frequently,it

re: Re: Replication problem (alter table fails)

2003-02-26 Thread Egor Egorov
On Wednesday 26 February 2003 10:19, Kirill Peskov (WEB-EU) wrote: > Looks like we've mixed up two threads into one ;-) > > As I understood from various forums and maillists, versions 4.x are > still in development state. Yup, 4.0.X is gamma. > The newest production version is 3.23.55, > am

re: RE: Replication problem (alter table fails)

2003-02-25 Thread Egor Egorov
On Tuesday 25 February 2003 16:36, Floyd Wellershaus wrote: > Egor, > I am sorry, my bad. I misrepresented the versions of mysql I am using. Must > have been a typo. > Here is what I am using. > > Master: Sparc Solaris 7 MySQL 4.0.9-gamma-log > Slave: RedHat Linux 7.2 MySQL 4.0.8-gamma-log

Re: re: Replication of only a couple of databases

2002-12-19 Thread Victoria Reznichenko
On Wednesday 18 December 2002 17:18, you wrote: > At 16:57 18-12-02 +0200, you wrote: > >On Wednesday 18 December 2002 11:36, Wico de Leeuw wrote: > > > I've setup replication with a master-slave. > > > But i only want to replicate some databases so i'd put in my.cnf on the > > > slave (it's being

re: Re: Replication

2002-11-02 Thread Egor Egorov
Alexander, Friday, November 01, 2002, 9:48:50 PM, you wrote: AB> I did the configuration below but the server doesn´t make the replication. AB> I tryed some commands. AB> start/stop slave AB> status master AB> but they didn´t. AB> What else do I have to do? Is there anything in the error log?

re: Re: Re: Re: Replication

2002-10-01 Thread Victoria Reznichenko
CP, Tuesday, October 01, 2002, 11:29:30 AM, you wrote: C> I stopped both mysql in master and slave. Then I put in the server id for C> both master and slave, start the master then the slave. Is it okay? Yes. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This ema

Re: Re: Re: Replication

2002-10-01 Thread CP
CTED]> Sent: Monday, September 30, 2002 10:37 PM Subject: re: Re: Re: Replication > CP, > Monday, September 30, 2002, 3:48:31 AM, you wrote: > > C> The Master's server id is 1 while the slave's server id was set to 5. There > C> is no problem for the slave to establ

re: Re: Re: Replication

2002-09-30 Thread Victoria Reznichenko
CP, Monday, September 30, 2002, 3:48:31 AM, you wrote: C> The Master's server id is 1 while the slave's server id was set to 5. There C> is no problem for the slave to establish connection to the master. However, C> the slave complains that error reading packet from server, the reason is C> misco

Re: Re: Replication

2002-09-29 Thread CP
t and this messages keep on repeating. Any idea? Thanks, Chee Peng - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 27, 2002 9:16 PM Subject: Re: Re: Replication > Hello CP, > Friday, September 27,

Re: Re: Replication

2002-09-27 Thread Victoria Reznichenko
Hello CP, Friday, September 27, 2002, 3:11:14 AM, you wrote: C> hi Victoria, thanks for the reply. I have set server id in the very C> beginning, but its still not working. I don't understand why the MySQL would C> not let me change its server id accordingly. The server id was set to 1. You must

RE: Re: Replication Circle

2002-08-04 Thread Oren Zeev-Ben-Mordehai
Hello, I also plan to use two servers such that each is a master for the other. A -> B B -> A Unless you tell me otherwise, the log-server-updates option will not be used. Seems to work in a small test I've conducted. In fact this setup will be used for reasons of high availability. (rather t

[mysql@lists.mysql.com: Re: Re: Replication: Push by Master or Pop by Slaves ?]

2001-08-30 Thread Peter van Dijk
On Thu, Aug 30, 2001 at 12:44:46PM +0200, Claudio Cicali wrote: [snip] > Here, seems that are the slaves that pop data from master. > So where is the truth ? Is the master that pushes or the slaves the pops ? > Or it is a combination of the two ? In normal operation, the master pushes to the slav

Re: Re: replication doesn't maintain logs?

2001-06-21 Thread Brian Reichert
No, this isn't spam. I was publicly thanking someone for advice given. :/ On Thu, Jun 21, 2001 at 08:25:37PM -, [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of th

Re: Re: Replication question.

2001-02-25 Thread Jeremy D. Zawodny
On Sun, Feb 25, 2001 at 03:29:37PM +0900, ÇãÁ¤¼ö wrote: > > >It sounds like you are using a version of MySQL that had a > >replication bug in it. I suspect that if you upgrade to 3.23.33 the > >problem will go away. > > > > No, Master is 3.23.33, and slave is 3.23.32 3.23.32 was troublesome for

Re: Re: Replication Bug in 3.23.33

2001-02-15 Thread Sasha Pachev
On Thursday 15 February 2001 18:50, Rodolfo Sikora wrote: >Does this problem exist in 3.23.32?? > > > >> >>Thanks for the bug report. The problem is a bug in the code that skips events >>when it sees a log entry with the same server id - something that can only >>happen in the bi-directional re

Re: Re: Replication Bug in 3.23.33

2001-02-15 Thread Rodolfo Sikora
Does this problem exist in 3.23.32?? > >Thanks for the bug report. The problem is a bug in the code that skips events >when it sees a log entry with the same server id - something that can only >happen in the bi-directional replicaiton setup. Fix: > >--- 1.85/sql/slave.cc Sat Jan 27 15:33: