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
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
Run the change master again to get the relay logs from master server again.
On Wed, Feb 16, 2011 at 4:50 PM, Carl c...@etrak-plus.com 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
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
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
, February 16, 2011 6:23 AM
Subject: 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
that I know to be good?
Just trying to be really careful.
Thanks,
Carl
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
To: Carl c...@etrak-plus.com
Cc: mysql@lists.mysql.com
Sent: Wednesday, February 16, 2011 6:24 AM
Subject: Re: Replication issue
--
MySQL General
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
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
-plus.com
Cc: mysql@lists.mysql.com
Sent: 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
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
!
Thanks,
Carl
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
To: Carl c...@etrak-plus.com
Cc: mysql@lists.mysql.com
Sent: Wednesday, February 16, 2011 7:02 AM
Subject: Re: Replication issue
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
need sleep!
Thanks,
Carl
- Original Message - From: Reindl Harald h.rei...@thelounge.net
To: Carl c...@etrak-plus.com
Cc: mysql@lists.mysql.com
Sent: Wednesday, February 16, 2011 7:02 AM
Subject: Re: Replication issue
--
Mit besten Grüßen, Reindl Harald
the lounge interactive
: 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
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
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
[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
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 running on RH9
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'
(113)
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
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
: 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 errors in there like
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?
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 using
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 like
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
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
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
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 below can
: connected to master
'[EMAIL PROTECTED]:3306', replication started in log 'www-bin.001' at position
4
[EMAIL PROTECTED] mysql5]#
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 12:21 PM
To: [EMAIL PROTECTED]
Subject: 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
Randy
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
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:
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
--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
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
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 Slave
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:
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
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
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:
We have a 4.0.4-beta
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 key
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,
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
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
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 same
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
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 - has apache
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
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, I
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
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
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
http://www.mysql.com/doc/R/e/Replication_HOWTO.html
All very straight forward.
When I spin
53 matches
Mail list logo