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 t
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
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 slav
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%';
+-+---+
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:
+--+--+--
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 th
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
+--+--+--+--+
| File
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 dre
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;
+--+--+--+---
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 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 )
Master:
+--+--+--+--+
| File
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
wrote:
> Hello guys, some points to check here:
>
> 1-) Is the master server con
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 bec
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" wrote:
>
> Replication novice
>
> I have a master server at the office and a replication server at home.
> Thi
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 th
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 list
y 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
>
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: r
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 wrote:
> hi list, i am tr
> -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
specified, even 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 probl
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 wit
Hi.
Can you give me a flow of your master/slave?
On Wed, Jun 24, 2009 at 7:45 PM, 赵琦 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 have 100
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 s
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
binlog_do_
: mysql@lists.mysql.com> Subject:
Re: 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
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 wer
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 f
ia
invent
---
-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 Probl
ia
invent
---
-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 Probl
ia
invent
---
-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 "by design". Personally I don't get why thi
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
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
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
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 readin
---
-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 a
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
AM
To: mysql@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 i
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 did
nt
---
-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
Australia
invent
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 9:51 PM
To: mysql@lists.mysql.com
Subject: RE: Repli
CTED]
Sent: 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 | Bi
David,
mysql> show master status\g
+---+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---+--+--+--+
| FMSweb-bin.01 | 903763 | |
nvent
---
-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
nt
---
-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 ho
nt
---
-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
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 mention what all databases has to be replicated in ur cnf file
as (replicate-do-db=database-name).
Thanks & Regards
D
Hi,
Check whether u have starting with the correct master position from slave.
Thanks & Regards
Dilipkumar
- Original Message -
From: "Brett Harvey" <[EMAIL PROTECTED]>
To:
Sent: Monday, July 24, 2006 9:36 AM
Subject: Re: Replication Problem
Hi,
Thanks for th
---
-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,
>
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
--
-
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:
Sent: Monday, July 24, 2006 8:49 AM
Subject: Replicatio
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
- 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
admi
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
http://dev.mysql.com/doc/mysql/en
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 ...
> 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 'skip_ne
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 |
+-+---+
| skip_ne
> --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
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 s
> 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]
user=m
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 t
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 mas
)
VALUES ( 'lty0105', '8', 2p);
I took your suggestion and have sent a report.
And thank you very much.
With best regards,
Weicheng Pan
Jun 3, 2005.
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: Thursday, June 02, 2005
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 b
-relay-bin.60 | grep "(
'lty0105', '8', 2p)"
INSERT LOW_PRIORITY INTO `statistics`.`search` ( `userid` , `id` , `func` )
VALUES ( 'lty0105', '8', 2p);
[EMAIL PROTECTED] [ /home/mysql ]>
With best regards,
Weicheng.
- Original Message
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 ch
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
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 a
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
repl
://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
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 halt
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 rep
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
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 my.cnf.
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 erro
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 *
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.
http://dev
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.) 922
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 go
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 m
> 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
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 hopin
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
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 a
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
D]>
> Date: Thu, 29 Jan 2004 10:25:24 +0200
> To: [EMAIL PROTECTED]
> Subject: Re: weird replication problem with master.info being created empty
>
> Maybe you should check if the ip address resolved for the
> master's url is correct ?
>
> Also try using CHANGE MA
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_USER='',
MASTER_PASSWORD='';
and then START SLAVE; and see what happens.
regards Jurgen
> Tried that, but no luck, they get r
f 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]
> Subje
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.
re
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 r
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 ab
base.myodbc
Sent: Wednesday, 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`
>
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 pr
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 trie
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:
1 - 100 of 248 matches
Mail list logo
