replication issue from ec2 to my network ..

Hi, I have configured replication from EC2 mysql instance to another mysql instance on our network via vpn in between. Sometimes it is showing no errors on the slave but the slave falls behind . When I issue the commands stop slave ; start slave ; it again catches up with the master. What is t

Re: Replication issue

Thank you for the information and script. I will try it out tonight when traffic stops. Thanks, Carl - Original Message - From: "Reindl Harald" To: "Carl" Cc: Sent: Wednesday, February 16, 2011 7:47 AM Subject: Re: Replication issue -- MySQL General M

Re: Replication issue

t" date echo "" echo "" I have never used the rsync process... I will try it out in the in the middle of the night when I have > time to recover from a screwup. Who says systems people need sleep! > > Thanks, > > Carl > - Original Message -

Re: Replication issue

! Thanks, Carl - Original Message - From: "Reindl Harald" To: "Carl" Cc: Sent: Wednesday, February 16, 2011 7:02 AM Subject: Re: Replication issue -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

Re: Replication issue

I can not believe that this would take 24 hours since rsync with compression is very efficient and on the other hand - who cares, the master is not down if you do this in the order i described Am 16.02.2011 12:57, schrieb Carl: >> are you saying to restart the slave in question from a good copy of

Re: Replication issue

t: Wednesday, February 16, 2011 6:40 AM Subject: Re: Replication issue -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Replication issue

Am 16.02.2011 12:36, schrieb Carl: > are you saying to restart the slave in question from a good copy of the > master that I know to be good? yes! there is a reason why the salve stops to work and in my opinion the only save way to get a 100% clean slave is clone it again from the stopped master

Re: Replication issue

Am 16.02.2011 12:33, schrieb Carl: > The max_allowed_packet setting is the same on both. the question is how large the setting is we have 200M on all machines > I have tried restarting the slave... didn't work after replication errors you should every time * stop the slave * "hot" rsync the dad

Re: Replication issue

I know to be good? Just trying to be really careful. Thanks, Carl - Original Message - From: "Reindl Harald" To: "Carl" Cc: Sent: Wednesday, February 16, 2011 6:24 AM Subject: Re: Replication issue -- MySQL General Mailing List For list archives: http://list

Re: Replication issue

The max_allowed_packet setting is the same on both. I have tried restarting the slave... didn't work. I can bounce the master. Thanks, Carl - Original Message - From: "Elizabeth Mattijsen" To: "Carl" Cc: Sent: Wednesday, February 16, 2011 6:23 AM Subje

Re: Replication issue

First make sure that the "max_allowed_packet" setting is the same on both masters. Make sure that setting is active on the slave in question. Then start replication or bounce the master (not sure which I did to fix this the last time I ran into this). Elizabeth Mattijsen

Re: Replication issue

Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master So do this in your my.cnf :-) Forget workarounds to solve replication errors and re-init you replication if you will be sure it is really consis

Re: Replication issue

Run the change master again to get the relay logs from master server again. On Wed, Feb 16, 2011 at 4:50 PM, Carl wrote: > I am running master - master replication between two locations using MySQL > version 5.1.41 on Slackware Linux 13 (64bit). > > The problem from show slave status is: > >

Replication issue

I am running master - master replication between two locations using MySQL version 5.1.41 on Slackware Linux 13 (64bit). The problem from show slave status is: Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's bi

Re: Replication Issue with Upgrade from 4.0.x to 5.0.x

> Dave: > There are no uncommented entries in /etc/hosts.deny > > Baron: > The all servers have a unique server-id in their respective my.cnf's > > When I try to connect directly from the slave to the new master, I get: > > ERROR 2003 (HY000): Can't connect to MySQL server on '1xx.1xx.1xx.xx' (11

Re: Replication Issue with Upgrade from 4.0.x to 5.0.x

David Campbell wrote: > [EMAIL PROTECTED] wrote: >> I'm in process of upgrading a master server from 4.0.24-log to 5.0.22-log >> in a single master-slave environment. I've previously upgraded the slave >> to 5.0.22-log and restarted replication without issue. >> >> The current master is runn

Re: Replication Issue with Upgrade from 4.0.x to 5.0.x

[EMAIL PROTECTED] wrote: I'm in process of upgrading a master server from 4.0.24-log to 5.0.22-log in a single master-slave environment. I've previously upgraded the slave to 5.0.22-log and restarted replication without issue. The current master is running on RH9 and the slave is running on C

Re: Replication Issue with Upgrade from 4.0.x to 5.0.x

Hi, [EMAIL PROTECTED] wrote: I'm in process of upgrading a master server from 4.0.24-log to 5.0.22-log in a single master-slave environment. I've previously upgraded the slave to 5.0.22-log and restarted replication without issue. The current master is running on RH9 and the slave is running

Replication Issue with Upgrade from 4.0.x to 5.0.x

I'm in process of upgrading a master server from 4.0.24-log to 5.0.22-log in a single master-slave environment. I've previously upgraded the slave to 5.0.22-log and restarted replication without issue. The current master is running on RH9 and the slave is running on CentOS 5, which is what I'

Re: Possible Replication Issue?

al Message- From: Baron Schwartz [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 24, 2007 9:53 AM To: Jesse Cc: MySQL List Subject: Re: Possible Replication Issue? Hi Jesse, Jesse wrote: I'm running MySQL version 5.0.22-community-nt on a Windows 2003 server. I a noticing A LOT of

Re: Possible Replication Issue?

Hi Jesse, Jesse wrote: I'm running MySQL version 5.0.22-community-nt on a Windows 2003 server. I a noticing A LOT of errors in there like the following: C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\nfcamp\societies.frm' This spans multiple databa

Possible Replication Issue?

I'm running MySQL version 5.0.22-community-nt on a Windows 2003 server. I a noticing A LOT of errors in there like the following: C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\nfcamp\societies.frm' This spans multiple databases and tables. I am using

Re: Replication issue: I/O thread dies immediately after START SLAVE with no logged errors

Hello. Have you done a FLUSH PRIVILEGES after granting the rights to the slave user (not needed if you used GRANT clause). I didn't see this statement in your previous message? Do you execute a 'RESET SLAVE' on your slave host, when you make another attempt to setup the replication? Doe

Re: Replication issue: I/O thread dies immediately after START SLAVE with no logged errors

In response to Gleb Paharenko and Bruce Dembecki: Gleb Paharenko wrote: >Please send us an output of SHOW MASTER STATUS ans SHOW SLAVE STATUS. >Can you reproduce the problem using official binaries? I have included the output of those two commands below. I will try to reproduce the problem usin

Re: Replication issue: I/O thread dies immediately after START SLAVE with no logged errors

Looking at your my.cnf files I don't see where you've told the slave what server to connect to. The slave needs to know what server is the master. This is usually accomplished by including a couple of lines in my.cnf. If the file master.info is in the data directory it will override the my.cnf set

Re: Replication issue: I/O thread dies immediately after START SLAVE with no logged errors

Hello. Please send us an output of SHOW MASTER STATUS ans SHOW SLAVE STATUS. Can you reproduce the problem using official binaries? Tierney Thurban <[EMAIL PROTECTED]> wrote: > Hi all. Sorry if you get this twice -- it was posted to > mysql-replication earlier, but it doesn't look lik

Replication issue: I/O thread dies immediately after START SLAVE with no logged errors

Hi all. Sorry if you get this twice -- it was posted to mysql-replication earlier, but it doesn't look like that list is really used. I'm having a problem with my replication setup. This is my first time setting up replication, so this may be a simple problem. I'm using one master and one slave

Re: Replication Issue

Randy Johnson wrote: Here is the url sorry: http://dev.mysql.com/doc/mysql/en/Replication_Compatibility.html Does this table say that mysql 3.23.33 and up is not compatible to replicate to a mysql 5.0 slave? Yes Friedhelm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

RE: Replication Issue

Here is the url sorry: http://dev.mysql.com/doc/mysql/en/Replication_Compatibility.html -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 2:07 PM To: [EMAIL PROTECTED] Subject: RE: Replication Issue Does this table say that mysql

RE: Replication Issue

Does this table say that mysql 3.23.33 and up is not compatible to replicate to a mysql 5.0 slave? Thanks! Randy -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 12:21 PM To: [EMAIL PROTECTED] Subject: Re: Replication Issue "

RE: Replication Issue

e link points outside datafile at 0 041026 0:20:20 Slave SQL thread initialized, starting replication in log 'www-bin.001' at position 4, relay log './www-relay-bin.01' position: 4 041026 0:20:20 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', r

Re: Replication Issue

"Randy Johnson" <[EMAIL PROTECTED]> wrote: > I have mysql master and mysql slave on same machine running separately. > I have master and slave setup. > I was able to do the LOAD DATA FROM MASTER; > > to get the data but the data does not replicate after that. =20 > > Looking at the info

Replication Issue

I have mysql master and mysql slave on same machine running separately. I have master and slave setup. I was able to do the LOAD DATA FROM MASTER; to get the data but the data does not replicate after that. Looking at the info below can you tell why replication is not taking place. Can I pro

RE: Local Master replication issue

--log-slave-updates did the job. Regards, -Original Message- From: Sanjeev Sagar [mailto:[EMAIL PROTECTED] Sent: Fri 9/10/2004 3:36 PM To: [EMAIL PROTECTED] Subject: Local Master replication issue Hello All, I am seeing a small problem in Ring replication where one slave is acting as

Local Master replication issue

Hello All, I am seeing a small problem in Ring replication where one slave is acting as Local Master. See below M - Super Master S1/LM1 - Slave of super Master and act as Local Master for S2 S2 - slave of LM1 I ran one Insert on M, it showd up on S1/LM1 but it did not showed up in S2. What I c

Re: Replication Issue

On Wed, May 05, 2004 at 06:44:09PM +0200, Mechain Marc wrote: > Hello, > > Why such a SQL request running well on the master is not correctly replicated on the > slave, > > set @providerId='012345'; > insert into DATA_TYPE values (1,@providerId,'DATA_TYPE',1); > > Here is an extract of the Sla

Replication Issue

Hello, Why such a SQL request running well on the master is not correctly replicated on the slave, set @providerId='012345'; insert into DATA_TYPE values (1,@providerId,'DATA_TYPE',1); Here is an extract of the Slave Logfile: MYBCK.log.1:ERROR: 1048 Column 'PROVIDER_ID' cannot be null MYBCK.

Replication Issue?

Hi all, My slave has been working fine up until now. Here is the error message. 030730 11:32:28 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'SQLServer1-bin.034' at position 77571524 ERROR: 1062 Duplicate entry '120816' for key 1 030730 11:32:28 Slave: er

Replication issue

I'm replicating over a local SSH tunnel to a remote machine ... both MySQL instances have been working fine in the past (and both have their own binary logs, and only one database is being replicated between the two). I'm getting this in the error logs: 021030 13:13:25 Slave: connected to mas

Re: Additional Information: Replication issue in 4.0.4

On Sat, Oct 05, 2002 at 03:47:18PM +0300, Heikki Tuuri wrote: > Shane, > > > 021004 12:57:00 Slave: error 'Incorrect key file for table: > 'listing_text'. Try to repair it' on query 'UPDATE sell.listing_text SET > description='blah' WHERE listing_id=221112', error_code=1034 > > > > So, I issued

Re: Additional Information: Replication issue in 4.0.4

Shane, - Original Message - From: "Shane Allen" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, October 04, 2002 10:17 PM Subject: Additional Information: Replication issue in 4.0.4 > On Thu, Oct 03, 2002 at 06:39:26PM -0500, Shane Allen wrote:

Additional Information: Replication issue in 4.0.4

On Thu, Oct 03, 2002 at 06:39:26PM -0500, Shane Allen wrote: > We have a 4.0.4-beta master and slave. > > The slaving process starts correctly, but randomly (and frequently) has > issues. > > When the server starts, it will slave, but eventually will hit one of > two conditions: > > - Duplicate

Replication issue in 4.0.4

We have a 4.0.4-beta master and slave. The slaving process starts correctly, but randomly (and frequently) has issues. When the server starts, it will slave, but eventually will hit one of two conditions: - Duplicate key insert error (we re-sync'd the slave by hand during the install, copying

Re: replication issue (A _REAL_ ISSUE)

I was wrong. My slave servers are STILL 'hanging' and not continuing to replicate. They give no errors, the slave appears to stay running, it just lags behind the master. Nothing I have done has fixed this. Again I'm running 3.23.49. To "fix" the problem I issue a slave stop, slave start comm

Re: replication issue

It would appear that the apparent lagging/slave processes not working (yet telling me they are up) was due to having two slaves set to the same server-id. I will know as more time passes. On Wed, Feb 27, 2002 at 09:27:04AM -0600, Michael Douglass said: > > David, > > I am seeing the exact s

Re: replication issue

David, I am seeing the exact same thing on some Solaris boxen. My database sees a couple of updates every minute or two; and show slave status on the slave always appears to lag behind the master. The data in my tables lag as well as I've done some rudimentary checksumming and have found dif

RE: replication issue

I've recently set up replication on one of my databases. Both master and slave are running MySQL 3.23.46 on FreeBSD 4.1. The only tables that get updated or inserted into hold approximately 140,000 records, growing at a rate of around 50-100 every day. The issue is it is currently taking approxima

(Sort of ) replication issue

David, Monday, January 28, 2002, 10:43:38 PM, you wrote: DS> REALFROM: David Shields <[EMAIL PROTECTED]> DS> HOUR: 2002012901 DS> You wrote: DS> What about mysqldump? See http://www.mysql.com/doc/m/y/mysqldump.html DS> for more info about mysqldump. DS> well, no, not really : DS> site1 - ha

(Sort of ) replication issue

You wrote: What about mysqldump? See http://www.mysql.com/doc/m/y/mysqldump.html for more info about mysqldump. well, no, not really : site1 - has apache / php / mysql + database x site2 - has apache / php / mysql + database y site3 - has apache / php / mysql + database z at 9:00 am all data

(Sort of ) replication issue

David, Monday, January 28, 2002, 10:39:12 AM, you wrote: DS> Hi, I was wondering if any of you clever people out there can help me. I DS> have a client with a problem I'm sure some of you have fixed in the past ... DS> Client has 3 geographically separate sites, running same application (mine,

Re: (Sort of ) replication issue

Hi. Not only that you also sent it to the wrong person:) It was david that asked the question anyway i cc it to the list and him. sometime i will experiment with that also but time is to short:) Regards /PM\ Ed Lazor wrote: > > doh... I should go to bed... I just reread what I wrote and it da

Re: (Sort of ) replication issue

Hi. I would do a simple read file,search database,input record script in perl and transfer the files using scp (ofcourse i asume this is in linux/unix) put it all under cronjob and it should work fine. On the other hand i am sure others have better ideas:) /PM\ David Shields wrote: > > Hi,

(Sort of ) replication issue

Hi, I was wondering if any of you clever people out there can help me. I have a client with a problem I'm sure some of you have fixed in the past ... Client has 3 geographically separate sites, running same application (mine, of course) and generating data on MySQL database. Periodically (proba

replication issue with FreeBSD 4.2-RELEASE

I'm exploring mysql replication under FreeBSD 4.2-RELEASE. Two machines, named 'master' and 'slave', each running FreeBSD 4.2-RELEASE and MySQL 3.23.36-debug. I've followed the instructions at All very straight forward. When I spin every

Replication issue

Is it possible to define multiple masters for a specific server: ie: Updates from different servers all update to a single backup server I'd prefer not to need to set up a circular replication scheme, due to geographical issues, and also data relavance issues. Taking a quick look through the sou