On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
+--+--+--+--+
| File
On 8/29/2014 5:11 PM, wagnerbianchi.com wrote:
Hello guys, some points to check here:
1-) Is the master server configured with sync_binlog=1 ?
It was not, I reconfigured and restarted mysql and...
2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading
events from
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
after a more complex transaction;
There's a duplicate key on the audit table, 18699. Delete it and restart
slave (start slave). Check slave status again, might be more rows in there
duplicated.
You might want to compare the row to master to ensure it's a duplicate
before deleting from slave.
On Aug 30, 2014 7:52 AM, william
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously ) global var, below
+--+--+--+--+
|
Based on the SHOW SLAVE STATUS output you've sent us, I'd suggest that you
check what the application is doing, understand *why* the application is
violating the PK of the table information_server.audit, repair the possible
application problem and the, reconfigure the replication.
It seems that
On 30/08/14 09:39, william drescher wrote:
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on
Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
mysql show global variables like 'log_bin%';
+-+---+
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position,
and restarted the slave.
Now all works fine and I am much better equipped next time to
debug the loss of the link.
When is the Last Error data deleted from the show slave
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equipped next time to debug the
loss of the link.
When is the
On 8/30/2014 12:53 PM, Jose Julian Buda wrote:
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equipped next
Replication novice
I have a master server at the office and a replication server at
home. This setup has been working for a couple of years.
Occasionally the replication server gets out of sync (usually
following a internet problem and the vpn going down.)
I just stop the slave, make sure
Whilst there are a few possibilities, check on the master that your binary
logs are being written to. Another possible reason could be filtering.
On 29 Aug 2014 21:36, william drescher will...@techservsys.com wrote:
Replication novice
I have a master server at the office and a replication
Hello guys, some points to check here:
1-) Is the master server configured with sync_binlog=1 ?
2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading
events from master, is the Exec_Master_Log_Pos incrementing or not?
3-) Why are you reconfiguring all the replication just
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
On Fri, Aug 29, 2014 at 5:11 PM, wagnerbianchi.com m...@wagnerbianchi.com
wrote:
Hello guys, some points to check here:
1-) Is
On 12/3/2012 7:24 AM, Trimurthy wrote:
hi list, i am trying to set up replication but i couldn't
complete because of the following error
Could not find first log file name in binary log index file can any one
please help me.
... snipped ...
This one should have been easy for the
directory are the binlogs in?
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: Monday, December 03, 2012 8:53 AM
To: trimur...@tulassi.com
Cc: mysql@lists.mysql.com
Subject: Re: replication problem
Trimurthy,
you will have to describe the method
Trimurthy,
you will have to describe the method you are using to setup
replication. The error message seems plain but an observer could not
reasonably guess what caused it without more information.
- michael dykman
On Mon, Dec 3, 2012 at 7:24 AM, Trimurthy trimur...@tulassi.com wrote:
hi
SHOW SLAVE STATUS\G
SHOW MASTER STATUS;
What directory are the binlogs in?
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: Monday, December 03, 2012 8:53 AM
To: trimur...@tulassi.com
Cc: mysql@lists.mysql.com
Subject: Re: replication problem
Trimurthy
Here is steps take to get to the problem. Version is 5.1.35
To be on the safe side, I did this prior to executing the scripts. I deleted
the mysql directory and the mysql-log directory, recreated them, chowned them,
ran mysql_install_db, chowned them again. So, I know at least I'm working
though the tables are qualified.
Can anyone confirm this?
Gary
From: Gary Smith [g...@primeexalia.com]
Sent: Friday, July 10, 2009 5:12 PM
To: mysql@lists.mysql.com
Subject: Crazy replication problem
Here is steps take to get to the problem. Version
-Original Message-
From: Gary Smith
Sent: Friday, July 10, 2009 5:26 PM
To: Gary Smith; mysql@lists.mysql.com
Subject: RE: Crazy replication problem
One quick follow up note:
In the top of the big script, I'm doing:
CREATE DATABASE x;
CREATE TABLE x.whatever
Hi.
Can you give me a flow of your master/slave?
On Wed, Jun 24, 2009 at 7:45 PM, 赵琦 tyzha...@gmail.com wrote:
hi all:
I have three mysql database,tow run as master and the other one runs as
slave.
Some tables in the database have an autoincreament field named as 'rowid'.
These
tables
hi all:
I have three mysql database,tow run as master and the other one runs as
slave.
Some tables in the database have an autoincreament field named as 'rowid'.
These
tables have 100 records on master, but some of these tables on the
slave only have thousands
of record. The tables on the
I have configured 2 MySQL server to do master-master replication. Below
is my config:
Node A
server-id = 1
log_bin = mysql-bin
expire_logs_days= 10
max_binlog_size = 100M
binlog_do_db= clustertest
binlog_do_db= gateway
We have a windows server running our main database and an IIS server. We also
have a linux box with apache/php that uses the same database server.
We have configured a replication from that host to another windows server. Then
we verified that not all the queries were replicated properly. We
Hi,
Jorge Martínez wrote:
We have a windows server running our main database and an IIS server. We also
have a linux box with apache/php that uses the same database server.
We have configured a replication from that host to another windows server. Then we verified that not all the queries
: Replication problem Hi, Jorge Martínez wrote: We have a windows
server running our main database and an IIS server. We also have a linux box
with apache/php that uses the same database server.We have configured a
replication from that host to another windows server. Then we verified that not
all
---
-Original Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 13 December 2006 10:55 AM
To: Ed Pauley II
Cc: mysql@lists.mysql.com
Subject: Re: Replication Problem?
Ed, this is unfortunately
---
-Original Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 13 December 2006 10:55 AM
To: Ed Pauley II
Cc: mysql@lists.mysql.com
Subject: Re: Replication Problem?
Ed, this is unfortunately
We recently upgraded to MySQL 5.0. Since upgrading I have noticed that
queries of the form INSERT INTO test.test_table VALUES('test','1') no
longer replicate. If you connect to or change to the test database and
then execute INSERT INTO test_table VALUES('test','1') the query
replicates. Is
Ed, this is unfortunately by design. Personally I don't get why this
choice was made...
Reference:
http://lists.mysql.com/mysql/190869
Regards,
Atle
FCI, Inc. - Unix Systems Administrator
On Tue, 12 Dec 2006, Ed Pauley II wrote:
We recently upgraded to MySQL 5.0. Since upgrading I
Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 13 December 2006 10:55 AM
To: Ed Pauley II
Cc: mysql@lists.mysql.com
Subject: Re: Replication Problem?
Ed, this is unfortunately by design. Personally I don't get why this
choice was made...
Reference:
http
Hi All,
I need small help from you. I am using Replication, i am using this
technique to give live support to Support team. But my Server and Slave are
not in LAN. So some times i am getting network delay. Can anybody tell me a
good suggestion to over come this.
regards,
balaraju
t
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 1:49 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
Hello David,
Reset how? I
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 9:28 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
Dave,
I tried reset slave as you mentioned - no change. Nothing
David,
mysql show master status\g
+---+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---+--+--+--+
| FMSweb-bin.01 | 903763 | |
: Monday, 24 July 2006 9:51 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
David,
mysql show master status\g
+---+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB
nt
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 9:51 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
David,
mysql show master
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 11:06 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
David,
I could try and create a table. But I've got it set just
David,
Thanks for attempting to help.
When I look at my show slave status, its updating. When I look at
the FMSbuilding-relay-bin, its updating! It has the information
that's taken place on the master server. I can see information in
the FMSbuilding-relay-bin on the slave server that I
@lists.mysql.com
Subject: RE: Replication Problem
David,
Thanks for attempting to help.
When I look at my show slave status, its updating. When I look at
the FMSbuilding-relay-bin, its updating! It has the information
that's taken place on the master server. I can see information in
the FMSbuilding
David,
It is pointing correctly. Plus, I can use a mysql browser and 3rd
party tools on the slave server and read the databases/tables
properly.
I've tried stopping and restarting. I've rebooted... I'm baffled
too, obviously. lol
Thanks!
Brett
I am absolutely baffled as to how the
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 25 July 2006 10:18 AM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
David,
It is pointing correctly. Plus, I can use
David,
that error is only when doing a stop/shutdown. So it doesnt make a
lot of sense that would be the problem.
Here's the log where I did a stop and start.
060724 20:54:25 [Note] C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt: Normal shutdown
060724 20:54:25 [ERROR] Error
Well, I successfully setup replication for one server/slave. Now I'm
trying to do the same for another set.
I've tried both the tar method and load data from master and can't
seem to get either to work.
Nothing replicates to the slave.
I'm running Mysql 5.022.
===
My error
Hi,
Did u mention what all databases has to be replicated in ur cnf file as
(replicate-do-db=database-name).
Thanks Regards
Dilipkumar
- Original Message -
From: Brett Harvey [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, July 24, 2006 8:49 AM
Subject: Replication
Hi,
Thanks for the response.
Yes - I have that in my config also.
replicate-do-db=FMS
Thanks
Brett
Hi,
Did u mention what all databases has to be replicated in ur cnf file
as (replicate-do-db=database-name).
Thanks Regards
Dilipkumar
--
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 1:36 PM
To: mysql@lists.mysql.com
Subject: Re: Replication Problem
Hi,
Thanks for the response.
Yes - I have that in my config also.
replicate-do-db=FMS
Thanks
Brett
Hi,
Did u
Hi,
Check whether u have starting with the correct master position from slave.
Thanks Regards
Dilipkumar
- Original Message -
From: Brett Harvey [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, July 24, 2006 9:36 AM
Subject: Re: Replication Problem
Hi,
Thanks
@lists.mysql.com
Subject: Re: Replication Problem
Hi,
Thanks for the response.
Yes - I have that in my config also.
replicate-do-db=FMS
Thanks
Brett
Hi,
Did u mention what all databases has to be replicated in ur cnf file
as (replicate-do-db=database-name).
Thanks Regards
Dilipkumar
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 1:49 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
Hello David,
Reset how? I did the CHANGE MASTER TO and set it as what was
specified from the Show Master command after I
We are running 4.1.13 standard on Linux as a master, and 4.1.14 on NT4
as a slave.
Replication seems to work extremely well, except in the following
circumstance.
On the master server, running a query similar to:
insert into zmast.leagueinfo
(countieslist, defaultleaguecode, leaguename
Hello.
However, this does not seem to replicate to the slave, and no error shows
Have you compared the slave's relay logs and master's binary logs? Does
this query present in both logs? See:
http://dev.mysql.com/doc/mysql/en/slave-logs.html
- Original Message -
However, this does not seem to replicate to the slave, and no error
shows
Have you compared the slave's relay logs and master's binary logs? Does
this query present in both logs?
The hint was what I needed, Gleb. Spasibo. It turns out that the
If nothing helps, trace files could spill the light on your problem.
many thanks for your help. With tracing I found the problem. Like almost
every time it was just a typing error :-(
Regards Jan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello.
If nothing helps, trace files could spill the light on your problem.
See:
http://dev.mysql.com/doc/mysql/en/making-trace-files.html
Jan Roehrich [EMAIL PROTECTED] wrote:
--skip-networking can be specified as the command line option. Use:
show variables like
Hello.
Please send your configuration files for master and slave. Check that
you don't have skip-networking in your slave's configuration file.
Jan Roehrich [EMAIL PROTECTED] wrote:
I have a strange problem setting up replication. I followed each step of
setting up replication in the
Please send your configuration files for master and slave. Check that
you don't have skip-networking in your slave's configuration file.
Master:
--
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-bin=bin-log
server-id=1
[mysql.server]
Hello.
Could not see skip-networking anywhere.
--skip-networking can be specified as the command line option. Use:
show variables like 'skip_networking';
to check if it is enabled.
Jan Roehrich [EMAIL PROTECTED] wrote:
Please send your configuration files for master and
--skip-networking can be specified as the command line option. Use:
show variables like 'skip_networking';
to check if it is enabled.
mysql show variables like 'skip_networking';
+-+---+
| Variable_name | Value |
+-+---+
| skip_networking | OFF |
Jan Roehrich wrote:
--skip-networking can be specified as the command line option. Use:
show variables like 'skip_networking';
to check if it is enabled.
mysql show variables like 'skip_networking';
+-+---+
| Variable_name | Value |
+-+---+
|
I have a strange problem setting up replication. I followed each step of
setting up replication in the mysqld documentation
(http://dev.mysql.com/doc/mysql/en/replication-howto.html).
But there are some error messages on the salve:
050828 13:22:58 [ERROR] Slave I/O thread: error connecting to
Hello.
I suggest you to check what query was written to the master binary log
and then report a bug. Please include all information you've found in the
report.
Weicheng Pan [EMAIL PROTECTED] wrote:
Dear Gleb:
The problem has occured again, and I grab some output.
This box run
very much.
With best regards,
Weicheng Pan
Jun 3, 2005.
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, June 02, 2005 4:51 PM
Subject: Re: Replication problem
Hello.
I suggest you to check what query was written to the master
] [ /home/mysql ]
With best regards,
Weicheng.
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, May 30, 2005 5:20 PM
Subject: Re: Replication problem
Hello.
Not enough information to make a conclusion. What version of
MySQL do you use
/en/slave-logs.html
http://dev.mysql.com/doc/mysql/en/binary-log.html
Please, next time include the output of SHOW SLAVE STATUS
(executed on the slave) and SHOW MASTER STATUS (executed on
the master) as well.
Weicheng Pan [EMAIL PROTECTED] wrote:
Hi all:
I have replication
Hi all:
I have replication problem on my FreeBSD 5.4 AMD64 box.
Sometimes replication will stop and throw an error code 1054,
but the query is not the original one in the master.
A query like UPDATE table_a SET col_a = 'abc' where col_b = 234
the right most character will become a strange
Hello.
Error: 'Unknown MySQL server host
'server5.domain.com' (1)' errno: 2005
Does the problem remain if you remove the following line
from the my.cnf on the server8:
skip-networking
Chris Mason [EMAIL PROTECTED] wrote:
I have two servers, server5.mydomain.com and
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to
replicate one database on server5 to server 8.
I did the whole proceedure as recommended in
http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set
Up Replication
I setup the GRANT statement on server5
Hi all
We have the following setup:
- Master mySQL Server 4.0.11-gamma (sun-solaris2.9-sparc-64bit)
- Slave mySQL Server 4.1.7 (sun-solaris2.9-sparc-64bit)
Everything worked fine with both servers having the same Version
(4.0.11-gamma). As a first step in updating to Rel. 4.1 we migrated the
://www.mysql.com/support/index.html
..
From: Don MacAskill ([EMAIL PROTECTED])
Subject: InnoDB backup + replication problem?
This is the only article in this thread
View: Original Format
Newsgroups: mailing.database.myodbc
Date: 2004-09-29 09:58:02 PST
I've got an interesting (well, I think
On 10/06/2004 6:23 PM, Bill Thomason [EMAIL PROTECTED] wrote:
I originally posted a query about a problem entitled Table doesn't
exist on query replication problem...
The original title might be a little misleading. The slave replication
is halting on a transaction that contains a query
Hi,
I have a mysql 4.0.21 master and a 4.0.18 slave.
I am trying to maintain a replication of a DB named masterdb.
My goal is to have multiple slaves with a copy of masterdb.
On the master I specified in my.cnf binlog-do-db=masterdb.
On the slave I specified replicate-do-db=masterdb in
Hello,
I suggest to you have the same version of mysql in both servers.
regards
El Miércoles, 6 de Octubre de 2004 13:07, Bill Thomason escribió:
Hi,
I have a mysql 4.0.21 master and a 4.0.18 slave.
I am trying to maintain a replication of a DB named masterdb.
My goal is to have
I originally posted a query about a problem entitled Table doesn't
exist on query replication problem...
The original title might be a little misleading. The slave replication
is halting on a transaction that contains a query that spans two
databases - one that is being replicated and the other
I've got an interesting (well, I think so anyway) problem with my
replication.
The slave chugs along just fine, then spits out:
Query caused different errors on master and slave. Error on master:
'Can't execute the query because you have a conflicting read lock'
(1223), Error on slave: 'no
did you get an answer to your problem yet? If not I may be able to help..
Andrew
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Sent: Fri 03/09/2004 15:29
To: [EMAIL PROTECTED]
Subject: Slave replication problem
Hello all,
We had a power outage this morning
Hello all,
We had a power outage this morning and before we could shut down our
main MySQL server, power to it was lost. Bad UPS battery. Long
story.
We replicate this server to two others. On one I get the following
error...
Jeff McKeon
IT Manager*** 1. row
Hi,
All
Is replication of database in MySQL is possible. Actually i want to
replicate the changes to the database to different servers located at
different locations.
Please tell me if any suggestions, or available resources for this
Replication Topic.
From:
Smitesh S. Damdoo
(Mob. No.)
On Friday 20 August 2004 07:08, [EMAIL PROTECTED] might have typed:
Is replication of database in MySQL is possible. Actually i want to
replicate the changes to the database to different servers located at
different locations.
A tiny bit of legwork would have answered it for you.
Hi Friends:
We are using mysql version 4.0.17 on Linux with a master and a single
slave both running on the same node.
We have encountered a problem in replication in the following scenario:
First the slave got abnormally terminated while there were some active
connections to the master.
The
On Tue, Aug 03, 2004 at 12:44:05PM +0530, [EMAIL PROTECTED] wrote:
Hi Friends:
We are using mysql version 4.0.17 on Linux with a master and a single
slave both running on the same node.
We have encountered a problem in replication in the following scenario:
First the slave got
We have suddenly run into a replication problem between our master and
our slave databases. It had been running without a problem for atleast
several months since our last upgrade, and for several years before
that. I've tried a number of debugging techniques, and now I'm hoping
somebody
somebody here can make sense of it. On the slave I get error messages
like:
040630 2:43:52 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'mysql-bin.163' at
position 37919441
It does that several times between 2:20am and 4:30am. and every few
Ah..
Running 4.0.20-standard-log on Fedora Core 1 on two boxes. Running with a
largely untouched my-huge.cnf - innodb configs uncommented.
Followed
http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.html
to setup replication. On the master I see:
mysql show master status;
Hi,
On Wed, Apr 21, 2004 at 06:35:53PM +0200, Mechain Marc wrote:
Add this in your my.cnf slave file:
slave-skip-errors = 1062
Ahh, that's what i was looking for. Seems as if i had not read chapter 6
of the documentation thoroughly enough...
Thanks,
Georg
--
MySQL General Mailing List
Hi,
i'm new to this list, but i use mysql for years an are very happy with it.
However, today i ran into a problem that i couldn't find a solution for:
I set up database replication with a master and one slave, and it works
fine so far. I rewrote my application (web based written in php) so that
Add this in your my.cnf slave file:
slave-skip-errors = 1062
Marc.
-Message d'origine-
De : Georg Horn [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 21 avril 2004 17:31
À : [EMAIL PROTECTED]
Objet : Replication problem
Hi,
i'm new to this list, but i use mysql for years an are very
You need to shutdown mysql, delete the master.info and
relay-log.info files and then start mysql again.
The reason for this is because if the info files are
present then mysql uses them as is and only recreates them
from my.ini or my.cnf if absent.
This should get your replication going again.
of the server
changing, but that isn't the case here, the hostname is the same as always
(should have added that in the first place).
thanks,
Andrew
From: Lightware Software [EMAIL PROTECTED]
Date: Thu, 29 Jan 2004 08:53:48 +0200
To: [EMAIL PROTECTED]
Subject: Re: weird replication problem
Maybe you should check if the ip address resolved for the
master's url is correct ?
Also try using CHANGE MASTER TO
MASTER_HOST='master host name',
MASTER_USER='replication user name',
MASTER_PASSWORD='replication password';
and then START SLAVE; and see what
start
it'll tell you: ERROR 1201: Could not initialize master info structure,
check permisions on master.info
Hope that helps someone down the line!
Andrew
From: Lightware Software [EMAIL PROTECTED]
Date: Thu, 29 Jan 2004 10:25:24 +0200
To: [EMAIL PROTECTED]
Subject: Re: weird replication
Hi all,
Have a problem, running a master/slave setup which worked until tonight and
mysteriously broke with no changes to the setup at all. My server starts up
fine, but the master.info and relay-log.info that are created are 0 bytes
and empty. In the logfile, I get this:
040128 23:00:29 Error
Hi
I understand the concept of master n slave
relationship but have certain queries regarding
this...
1) In case the master is down i do i configure my
system so that a present active slave becomes the
master or any other way to tackle this
situation.How
does the clients know
, December 03, 2003 6:41 AM
Subject: Drop foreign key replication problem
Hi,
I am running a master and a slave. When I created a foreign key in
master, it looked like this:
CONSTRAINT `0_373` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture`
(`id`)
But on the slave it was like
Hi,
I am running a master and a slave. When I created a foreign key in
master, it looked like this:
CONSTRAINT `0_373` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture`
(`id`)
But on the slave it was like:
CONSTRAINT `0_451` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture`
(`id`)
The
I found the problem which I will outline here just in case anyone else
runs across it in the future:
It appears that a slave will not replicate data from it's own server-id.
In my case, a large portion of the binary logs on my slave had originally
come from the master, so when the master
I have one master and one slave which I am upgrading to 4.0.14 from
4.0.12. To start the upgrade I stopped the slave, took a snapshot of it's
data directory, cleared it's binary logs, and switched to the 4.0.14
binaries. I then restarted the slave thread to get it caught up with the
master.
nobody have answer ?
For me it is very urgent to kwow when the .15 version will be avalaible .
Tks
- Original Message -
From: Massimo Petrini [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: I.P. [EMAIL PROTECTED]
Sent: Friday, August 22, 2003 1:16 PM
Subject: Re: Replication Problem (XP
1 - 100 of 240 matches
Mail list logo
