- Original Message -
> From: "Néstor"
>
> I spoke to soon!!!
> Here is the error about 1.5 hours after replication has started.
> 121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897'
> for
Yes, that's what you get for running SQL_SLAVE_SKIP_COUNTER without knowing
ou started IO and SQL replication threads after you skipped an replication
error and run start slave command.
I wouldn't run SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; command either as
it makes your tables inconsistent.
I'd rather deleted offending row on the slave and started replicatio
> You don't have errors in your mysql.err log. Those are notes saying that
>> you started IO and SQL replication threads after you skipped an replication
>> error and run start slave command.
>>
>> I wouldn't run SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; command e
In regards to the second part of your email.
You don't have errors in your mysql.err log. Those are notes saying that
you started IO and SQL replication threads after you skipped an
replication error and run start slave command.
I wouldn't run SET GLOBAL SQL_SLAVE_SKIP_COUNTER =
I spoke to soon!!!
Here is the error about 1.5 hours after replication has started.
121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897' for
key 1' on query. Default database: 'parallax'. Query: 'INSERT INTO watchdog
(uid, type, message, variables, severity, link, location, ref
Hi Néstor,
You might want to put those lines into your my.cnf under replication
section and restart the slave:
replicate-wild-ignore-table=dbname%.watchdog%
and may be this as well:
replicate-wild-ignore-table=dbname%.cache%
Do you really need to replicate cache and session tables?
Cheers,
Ig
I was about to reply with a long message of all the steps I followed to
create replication but I did my steps about an hour ago and I have not
seen the replication fail so far.
BTW, I created my replication following the info on this web page:
http://crazytoon.com/2008/01/29/mysql-how-do-you-set-u
2012/11/30 Néstor
> I am trying to set up mysql replication on 2 systems but Once I get it
> going, I get the following an error 1062,
>
>
> I have re-installed the database on the slave also to see if this fixes the
> problem
> but after a few minutes I get the same error. I have repeated th
- Original Message -
> From: "divesh kamra"
>
> slave-skip-errors=1062 ---> in my.cnf and restart mysql
Really? Just like that? Without even knowing what it does or what the problem
is?
If you have replication errors, this kind of stuff is only going to break it
further. "It e
Hi
first check this thought application end
or
There is another way
slave-skip-errors=1062 ---> in my.cnf and restart mysql
On Sat, Dec 1, 2012 at 4:30 AM, Reindl Harald wrote:
>
>
> Am 30.11.2012 23:52, schrieb Rick James:
> > Possible causes:
> > * Someone is writing to the Slave
>
Am 30.11.2012 23:52, schrieb Rick James:
> Possible causes:
> * Someone is writing to the Slave
that is why the option "read-only" exists for my.cnf
> * The Slave was not in synch with the Master.
> * Schemas are different between Master and Slave
should not happen if the slave is properly clo
CREATE TABLE (for a table that is in trouble)
> -Original Message-
> From: Néstor [mailto:rot...@gmail.com]
> Sent: Friday, November 30, 2012 1:24 PM
> To: mysql@lists.mysql.com
> Subject: MySQL Replication Error
>
> I am trying to set up mysql replication on 2 syst
I am trying to set up mysql replication on 2 systems but Once I get it
going, I get the following an error 1062,
which is a duplicate entry and my 'slave status' shows:
Slave_IO_Running: Yes
Slave_SQL_Running: No
And this is the error on my mysql.err file:
121130 12:41:53 [Note
All,
Thanks for your replies and as per the advise I switched to row-based
replication but replication ended with below error.
*Last_Error: Error 'Table 'b.sdefrent' doesn't exist' on query. Default
database: 'b. Query: 'drop table sdefrent'*
above error is due to non existence of database an
> **On master server I have two databases *A and B*. App team use database B
> temporarily for there application to compute calculation and insert the
> values on A database.
For certain statements you could start with "SET SQL_BIN_LOG=0" so it
doesn't log that statement, and it won't be replicat
On Thu, Jan 27, 2011 at 10:40 AM, Nagaraj S wrote:
> **On Slave Server I replicate database *A alone* and my replication not
> working due to data fetching happen on B database.
>
Well, yes. Statement-based replication does what it says on the box: it
executes the exact same statement on the sla
I have setup mysql replication with below scenario
**On master server I have two databases *A and B*. App team use database B
temporarily for there application to compute calculation and insert the
values on A database.
**On Slave Server I replicate database *A alone* and my replication not
See Thread at: http://www.techienuggets.com/Detail?tx=46643 Posted on behalf of
a User
HI,
first check the error log and find the position where the replication was
terminated.Now run the mysqlbinlog utility on the binarylogs file.
Now when you run the query will get the text format as a result
you need to be sure you have everything the server needs to be a slave
defined in your my.cnf file, especially the relay logs and that the
replication slave user is created properly.
On Tue, Aug 19, 2008 at 2:37 AM, Krishna Chandra Prajapati <
[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am setting up r
u need to set those parameters
On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Server_id is set but not relay_log and relay_index.
>
> On Tue, Aug 19, 2008 at 1:20 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
>> is the server_id and relay_log and relay_index parameter set in
Server_id is set but not relay_log and relay_index.
On Tue, Aug 19, 2008 at 1:20 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> is the server_id and relay_log and relay_index parameter set in my.cnf
>
>
> On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>>
>> Hi,
>>
>> I am setting
is the server_id and relay_log and relay_index parameter set in my.cnf
On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I am setting up replication and got the error below
>
> mysql> change master to master_host='172.20.1.189', master_user='repl',
> master_password='pas
Hi,
I am setting up replication and got the error below
mysql> change master to master_host='172.20.1.189', master_user='repl',
master_password='pass';
Query OK, 0 rows affected (0.01 sec)
mysql> start slave;
ERROR 1200 (HY000): The server is not configured as slave; fix in config
file or with C
Hi All,
Once a week or so I get the following error:
080801 8:18:35 [ERROR] Error reading packet from server: error reading log
entry ( server_errno=1236)
080801 8:18:35 [ERROR] Got fatal error 1236: 'error reading log entry' from
master when reading data from binary log
Stopping the slave an
On Thu, May 22, 2008 at 5:36 PM, Salah Nait-Mouloud <
[EMAIL PROTECTED]> wrote:
> Hi all.
>
> I have 2 MySQL servers.
> One master and one slave.
> In order to add new slave server, and because i can't stop the master one,
> i
> have tried this:
>
> http://forums.mysql.com/read.php?26,99846,102058
Hi all.
I have 2 MySQL servers.
One master and one slave.
In order to add new slave server, and because i can't stop the master one, i
have tried this:
http://forums.mysql.com/read.php?26,99846,102058
"
*You don't have to modify the other slaves configuration. What you need to
do is obtain a sna
>Description:
I am using MySQL server as backend database supporting a telecomm platform
providing voice over ip services.
tables involved: acc, cdr, account, location2
Partial processing flow:
1. When a phone call is started. A record will be inserted into table acc
(method=INVITE). This will
Hi Jen,
Jen mlists wrote:
Hello members,
When I do mysql replication,I didn't replicate the system's "mysql"
database.
but someone updated the mysql db in master,then I got the errors on slave.
How to resolve it?Do I need to always replicate mysql db?thanks.
ERROR: 1146 Table 'mysql.mobilea
Hello members,
When I do mysql replication,I didn't replicate the system's "mysql" database.
but someone updated the mysql db in master,then I got the errors on slave.
How to resolve it?Do I need to always replicate mysql db?thanks.
ERROR: 1146 Table 'mysql.mobilearea' doesn't exist
070717 15:2
Master_SSL_Allowed: Yes
Master_SSL_CA_File: /root/.mysql/cacert.pem
Master_SSL_CA_Path: /root/.mysql/
Master_SSL_Cert: /root/.mysql/client-cert.pem
Master_SSL_Cipher:
Master_SSL_Key: /root/.mysql/client-key.pem
Seconds_Behind_Mast
Hi
I've followed the replication procedure, as instructed on the online
manual.
I want to use replication over SSL.
I've followed this procedure to create test SSL certificates, keys, etc.
http://dev.mysql.com/doc/refman/4.1/en/secure-create-certs.html
On slave machine:
mysql> show slave statu
Classification: UNCLASSIFIED
Caveats: NONE
All,
I'm getting the not-so-mysterious error in my slave log file as follows:
[ERROR] Error reading packet from server: log event entry exceeded
max_allowed_packet; Increase max_allowed_packet on master
(server_errno=1236)
[ERROR] Got fatal error 1236
"Ugo Bellavance" <[EMAIL PROTECTED]> wrote:
> Hi,
>
>I'm trying to do a replication of two servers (one is mysql version =
> 4.1.0-alpha-debug-debug (slave) on debian and the other is =
> 4.1.0-alpha-debug-debug-log (master) on RH9). No I can't upgrade for =
> now.
>
> What I've done is
Hi,
I'm trying to do a replication of two servers (one is mysql version
4.1.0-alpha-debug-debug (slave) on debian and the other is 4.1.0-alpha-debug-debug-log
(master) on RH9). No I can't upgrade for now.
What I've done is that I stopped the master, copied the data folder to the slave.
Hi,
We have 2 MySQL 4.0.16 with replication enabled (M -> S), only InnoDB
tables.
We're getting "Error reading packet from server: Client requested master to
start replication from impossible position (server_errno=1236)" in the
slave.
The master server had a problem... when it came back (with s
Mysqlians,
The sql_thread on our slave slave server has been stopping with
error 1053
ERROR: 1053 Server shutdown in progress
031203 16:05:01 Slave: error 'Server shutdown in progress' on query 'INSERT
INTO INTEREST ( ID, PERSON_ID, COMMENT, DATE_CREATED, INTEREST_ID ) VALUES
Hi,
I have a busy MySQL slave which is directly updated
by a periodic "purge" script which throws
away irrelevant data.
Occassionally, (er, a few times a day, actually),
the slave "quietly" falls over, but ITS slaves
trip with
"[SQL...] partially completed on the master and was aborted. There
>Description:
Attempts to start slave replication fail when MySQL attempts to write
the bin-log location to the master.info file.
Attempts to manually change master also fail when writing to
master.info file.
master.info file is created, but has zero length
On Wednesday 12 March 2003 20:05, trashMan wrote:
> I've tried to setup a replication but ...i've several problem! I've
> follow the manual istruction
> http://www.mysql.com/doc/en/Replication_HOWTO.html
> But the slave don't start the replica.
>
> SHOW SLAVE STATUS on SLAVE return SLAVE:running
>
hMan; [EMAIL PROTECTED]
Oggetto: RE: Replication error
What does it say when you run SHOW MASTER STATUS on the master? Are you
sure the slave is the problem and not the master?
-Original Message-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 7:29 AM
To: [E
What does it say when you run SHOW MASTER STATUS on the master? Are you
sure the slave is the problem and not the master?
-Original Message-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 7:29 AM
To: [EMAIL PROTECTED]
Subject: Replication error
Please.seven
trashMan wrote:
> Please.seven days to try it!! Help me!! :-(
>
> --
>
> Hello,
> I've tried to setup a replication but ...i've several problem! I've
> follow the manual istruction
> http://www.mysql.com/doc/en/Replication_HOWTO.html
> But the slave don't start the replica.
>
> SHOW SL
Please.seven days to try it!! Help me!! :-(
--
Hello,
I've tried to setup a replication but ...i've several problem! I've
follow the manual istruction
http://www.mysql.com/doc/en/Replication_HOWTO.html
But the slave don't start the replica.
SHOW SLAVE STATUS on SLAVE return SLAVE:r
Hello,
I've tried to setup a replication but ...i've several problem! I've
follow the manual istruction
http://www.mysql.com/doc/en/Replication_HOWTO.html
But the slave don't start the replica.
SHOW SLAVE STATUS on SLAVE return SLAVE:running
SHOW PROCESSLIST on SLAVE return reconnecting after
> Check the user 'repl' has REPLICATION SLAVE privilege.
Ah. that fixed it. Actually, the real reason was that I had not
yet updated the mysql tables and the new privileges did not take
effect as a result.
mysql_fix_privilege_tables , followed by the 'GRANT' command
and 'flush privileges' fixed
On Thursday 13 February 2003 16:43, Johannes Ullrich wrote:
> I am having problems setting up replication between two 4.0.10
> servers.
>
> What I did so far:
>
> - generate a dump of the current state of the server using
> 'mysqldump' (its a mix of mostly innodb tables and some MyISAM
> tab
I am having problems setting up replication between two 4.0.10
servers.
What I did so far:
- generate a dump of the current state of the server using
'mysqldump' (its a mix of mostly innodb tables and some MyISAM
tables)
- dropped all databases from the slave
- imported the dump into the
http://www.mysql.com/doc/en/Replication_HOWTO.html
* http://www.mysql.com/doc/en/Replication_SQL.html
* http://www.mysql.com/doc/en/Replication_Options.html
This was an automated response to your email 'Replication error'.
Final search keyword used to query the manual wa
Hy,
im trying to create a replication between two MySql Servers. The Master
is running 4.0.6 (linux) and the slave ist 4.0.10 (solaris sparc
64-bit). If i try to start the replication process on the slave it
prints the following error message in the message log :
030206 20:09:36 Slave I/O thread
Hi list,
My original post concerning this issue is below - it was a week or so ago. No replies
were forthcoming, but I'm pleased and a bit embarrassed (so simple) to say that I have
figured it out, and my slave is now replicating from the master.
The problem was that the mysql data directory wa
Hi there,
I'm trying to set up replication between two RH7.2 Linux servers running MySQL
3.23.54a (mysql RPMs). I've followed the instructions in the MySQL online manual
(section 4.10 Replication in MySQL), and when I do the following command on the slave:
change master to master_host='db1', ma
It only happened the once, I've checked the history and no one executed any
odd commands (that I noticed:-)
Thanks
Liz
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: 26 November 2002 15:45
To: [EMAIL PROTECTED]
Subject: re: MySQL 3.23.49 - strange replication
Liz,
Monday, November 25, 2002, 6:47:35 PM, you wrote:
LC> I've got a master database with 2 slaves. I've had them up and running for
LC> quite a while now with no problems, but today I noticed an error - there was
LC> a slave running on the master!
LC> I checked /etc/my.cnf - no mention of slav
Hi
I've got a master database with 2 slaves. I've had them up and running for
quite a while now with no problems, but today I noticed an error - there was
a slave running on the master!
I checked /etc/my.cnf - no mention of slaves (it hadn't been changed for a
good while anyway). I looked every
MASTER Ver 12.10 Distrib 4.0.2-alpha, for pc-linux-gnu (i686)
SLAVE Ver 12.10 Distrib 4.0.2-alpha, for unknown-freebsdelf4.6 (i386)
On my Master I am getting this:
mysql> SHOW BINLOG EVENTS IN '/usr/local/var/www200-bin.008' FROM 38717800;
ERROR 2006: MySQL server has gone away
No connection.
Slave SQL thread initialized, starting replication in log
'www200-bin.008' at position 38717817, relay log
'./s142-17-103-3-relay-bin.056' position: 9212273
021114 16:34:12 Error in Log_event::read_log_event(): 'read error',
data_len=161,event_type=2
021114 16:34:12 Slave SQL thread: I/O erro
Hi,
I currently have my replication setup with 3 machines
as such:
A > B > C
Machine A just died, so B is now my master. However, I
want to re-adjust my setup so it looks like this:
B > A > C
So what I did was stop C and copy everything over to
A. At this point, either A or C should be able to
ter and the slave?
> Was a snapshot of the master placed on the slave
> before beginning
> replication?
> I hate to ask such simple questions but I am just
> checking.
>
> Victor
>
> -Original Message-
> From: Natale Babbo
> To: [EMAIL PROTECTED]
> Sent
i get the following error in the connection
slave->master while setting up a replication between
two MySQLServer(slave and master both windows XP):
.err file on slave:
MySql: ready for connections
021023 14:08:34 InnoDB: Started
021023 14:08:35 Slave I/O thread: connected to master
'[EMAIL PROTE
- Original Message -
From: "walt" <[EMAIL PROTECTED]>
To: "Lewis Watson" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 2:08 PM
Subject: Re: Replication Error
> Lewis Watson wrote:
>
> > A
;Jeff Kilbride" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Lewis Watson" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 2:45 PM
Subject: Re: Replication Error
> RESET MASTER
> RESET SLAVE
>
> Thi
t;mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 12:08 PM
Subject: Re: Replication Error
> Lewis Watson wrote:
>
> > Also, I am intersted in a way to reset the entire replication thing. In
> > other words, just remove all hints of replication an
son" <[EMAIL PROTECTED]>
> To: "mysql" <[EMAIL PROTECTED]>
> Sent: Tuesday, October 22, 2002 12:06 PM
> Subject: Replication Error
>
> > I had replication running fine between two mysql server machines on linux.
> > Then I added yet another slave but g
; <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 12:06 PM
Subject: Replication Error
> I had replication running fine between two mysql server machines on linux.
> Then I added yet another slave but goofed and put in the same server-id.
Now
> I am getting errors on the mast
I had replication running fine between two mysql server machines on linux.
Then I added yet another slave but goofed and put in the same server-id. Now
I am getting errors on the master server and proccesses being killed and
restarted. It comes with this error.
./bin/safe_mysqld: line 273: 12250 S
Looks like you don't have binary logging turned on on the master.
louie miranda wrote:
>021009 12:56:49 mysqld started
>/usr/sbin/mysqld: ready for connections
>021009 12:56:49 Slave: connected to master '[EMAIL PROTECTED]:3306',
>replication started in log 'FIRST' at position 4
>021009 12:56:
021009 12:56:49 mysqld started
/usr/sbin/mysqld: ready for connections
021009 12:56:49 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'FIRST' at position 4
021009 12:56:49 Error reading packet from server: Binary log is not open
(read_errno 0,server_errno=2000)
At 01:48 PM 7/12/2002, Jeremy Zawodny wrote:
>On Fri, Jul 12, 2002 at 01:43:02PM -0700, Jon Drukman wrote:
> > now instead of getting the error every 30 seconds, i get it every
> > hour. is there a way to make it go away forever?
>
>Make the number really big?
>
>I wonder if you can set it to 0 t
On Fri, Jul 12, 2002 at 01:43:02PM -0700, Jon Drukman wrote:
> i am having the "Error reading packet from server: (server_errno=1159)"
> replication problem.
>
> in searching the archives for others experience replication problems, i
> came across the suggestion of adding these lines to my.cnf
i am having the "Error reading packet from server: (server_errno=1159)"
replication problem.
in searching the archives for others experience replication problems, i
came across the suggestion of adding these lines to my.cnf
set-variable = slave_net_timeout=3600
set-variable = net_read_timeout
pot
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: replication error - server errno 1159
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.51 (Official MySQL binary)
>
On Wed, Jul 10, 2002 at 03:13:55PM -0700, Jeff Kilbride wrote:
>
> Is there a web-based interface for bug reporting? Or is there a way
> to use the mysqlbug program when my database machine isn't connected
> to the internet?
You can submit a but directly to [EMAIL PROTECTED] If your
message cont
EMAIL PROTECTED]>
Cc: "Nilesh Shah" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 10, 2002 11:39 AM
Subject: Re: Replication - Error reading packet from server:
(server_errno=1159)
> On Wed, Jul 10, 2002 at 09:57:56AM -0700, Mark Hughes wrote:
> >
al Message -
From: "Mark Hughes" <[EMAIL PROTECTED]>
To: "Nilesh Shah" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 10, 2002 9:57 AM
Subject: RE: Replication - Error reading packet from server:
(server_errno=1159)
> Thanks, I had a look
On Wed, Jul 10, 2002 at 09:57:56AM -0700, Mark Hughes wrote:
> Thanks, I had a look at that and it seems that slave_net_timeout is the
> variable that should be used and this is set to 3600 seconds - however it
> appears that the net_read_timeout is being used and by changing this from
> 30 to 360
> Sent: Wednesday, July 10, 2002 3:36 AM
> To: [EMAIL PROTECTED]
> Subject: Replication - Error reading packet from server:
> (server_errno=1159)
>
>
> Hi,
>
> We updated one of our slave servers to 3.3.51 from 3.23.38 and in common
> with lots of other posts
Set variable net_read_timeout to some bigger value.
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
Nilesh Shah
-Original Message-
From: Mark Hughes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 3:36 AM
To: [EMAIL PROTECTED]
Subject: Replication - Error reading packet
Hi,
We updated one of our slave servers to 3.3.51 from 3.23.38 and in common
with lots of other posts i've seen we're getting lots of errors where the
slave loses the connection to the master:
020710 7:24:05 Error reading packet from server: (server_errno=1159)
020710 7:25:05 Slave: Failed
ds,
Bhavin.
- Original Message -
From: "Cal Evans" <[EMAIL PROTECTED]>
To: "Kannan R" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, June 22, 2002 9:26 AM
Subject: RE: replication error
> I think somewhere in the manual it warns against runni
I think somewhere in the manual it warns against running slave and master as
different versions.
=C=
-Original Message-
From: Kannan R [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 7:15 AM
To: [EMAIL PROTECTED]
Subject: replication error
Placed At :
Hi..
I run a replicated mysql server set up..The version i use on the master is
3.23.49 and on the slave is 3.23.46.
following is the problem I'm facing..
the binlog postion on the master and the slave are always in sync with each
other
>Description:
Replication stopped on our MySQL 4.0.1-alpha distribution with the error:
Error executing query '%': got error 127 from table handler.
(This may not be the exact text).
Note the '%', which is what this bug report is referring to. Presumably the text of
the query should be there.
Placed At :
Hi..
I'm facing another problem with replication..I have jus one table with over 4
million records in it. I run mysql-3.23.49 on both my master and slave.following
is the problem am facing..
I had taken a consistent dump from the mast
Placed At :
Hi..
I'm facing another problem with replication..I have jus one table with over 4
million records in it. I run mysql-3.23.49 on both my master and slave.following
is the problem am facing..
I had taken a consistent dump from the mast
On Thu, May 23, 2002 at 10:10:26AM +0530, Kannan R wrote:
>
> I have come across a wierd error in my replication setup..I run
> mysql 3.23.49 on two servers .one is the master and the other the
> slave..I have jus one DB with jus a single table in it. I 'm getting
> the follwoing error on my slav
Placed At :
Hi..
I have come across a wierd error in my replication setup..I run mysql 3.23.49 on
two servers .one is the master and the other the slave..I have jus one DB with
jus a single table in it. I 'm getting the follwoing error on my slave
up to do
So in skipping these transactions, am I losing data?
-Original Message-
From: chad kellerman [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 11:57 AM
To: Luc Foisy
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL replication error
Luc,
The problem is that in the replic
Skip_counter: 0
> 1 row in set (0.00 sec)
>
>
> -Original Message-
> From: chad kellerman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 21, 2002 5:18 PM
> To: Luc Foisy
> Cc: [EMAIL PROTECTED]
> Subject: Re: MySQL replication error
>
>
>
&g
21, 2002 5:18 PM
To: Luc Foisy
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL replication error
Luc,
I new to this mailinglist ( this is my first posting) But I have worked a
little with replication.
Try if the replicator is still down.
set sql_slave_skip_counter = 1; slave start
on the slave as lo
Luc,
I new to this mailinglist ( this is my first posting) But I have worked a little
with replication.
Try if the replicator is still down.
set sql_slave_skip_counter = 1; slave start
on the slave as long as you are sure the master is ok.
Let me know is this worked.
-chad
On Thu, 21
Would anyone be able to tell me why this happened, and how I could fix it?
mysql> show slave status\G
*** 1. row ***
Master_Host: 209.217.92.34
Master_User: repslave2
Master_Port: 3306
Connect_retry: 60
Log_F
Placed At :
Hi..
I have set up a new slave host for my mysql DB..I have just done a create DB on
it and have setup all replication parameters in my /etc/my.cnf..but when i start
the slave i get the following error..has anybody come across this..any
Placed At :
Hi..
I have set up a new slave host for my mysql DB..I have just done a create DB on
it and have setup all replication parameters in my /etc/my.cnf..but when i start
the slave i get the following error..has anybody come across this..any
Hi everybody,
I use Replication on a windows NT4 Server.
There are 1 master and 2 slaves, all on the same machine.
One slave is started with the option skip-name-resolve, not the other.
For the 2 slaves : master-host=localhost
When adding a user (MYSQL.User), the replication is OK but,
when
Hi everybody,
I use Replication on a windows NT4 Server.
There are 1 master and 2 slaves, all on the same machine.
One slave is started with the option skip-name-resolve, not the other.
For the 2 slaves : master-host=localhost
When adding a user (MYSQL.User), the replication is OK but,
when
Hi All,
Sorry if I'm missing something totally daft here...
I've got my master and slave hosts (both runng MySQL 3.23.36) configured
roughly as-per the HOWTO, ( as follows ) to replicate the "test"
database, but not the "mysql" database [btw. it's not clear from the
docs that if you omit both bi
I have two mysql servers, setup to replicate each other.
However, every so often, one or both starts logging;
010226 9:40:27 Slave thread: error connecting to master:Can't connect to MySQL
server on '0' (11)(107), retry in 0 sec
010226 9:40:27 Slave thread: error connecting to master:Can'
97 matches
Mail list logo
