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 ignored from

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

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 I

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 used,

Re: Re: Re: Replication

2002-10-01 Thread CP
, 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 establish connection to the master. However, C the slave complains that error

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

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

Re: Re: Replication

2002-09-29 Thread CP
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, 2002, 3:11:14 AM, you wrote: C hi Victoria

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

[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 slave.

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 the

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 slaves. Here

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:30

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 replicaiton