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
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
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
: 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
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
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: Replication Problem
Well, I suc
- 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
> 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
)
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
Hello.
Not enough information to make a conclusion. What version of
MySQL do you use? Usually debugging of replication problems
begins from researching of binary logs with mysqlbinlog. See:
http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html
http://dev.mysql.com/doc/mysql/
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
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
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
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
> 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
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 an are very happ
I have your same problem in my network where the master i 3.23.52 and then
slave are 4.0.14; before, in all 4.0.13, it was ok, without this bug.
It will be solved in 4.0.15 ?
Best regards
Massimo
- Original Message -
From: "I.P." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday,
You can use an option in my.cnf slave-skip-error= error nums
separated by ,.
The error below means that the master had a shutdown event and the slave
can't tell if it added / deleted / changed that row or not. I wouldn't
advise in skipping this error less you want your data to be inconsistent
or
"System" <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> I have setup Replication on two Redhat linux box 7.3 and 9.0 with
> MySQL-4.0.13 Running..
>
> On Master the my.cnf is
> ==
> [client]
> port= 3306
> socket = /var/lib/mysql/mysql.sock
> # The MySQL server
>
On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote:
> On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote:
> > Andy,
> > I don't see
> > "log-slave-updates"
> > in your master setup. I see log-bin, but I "think" that only applies to
> > updates done directly to the database (not replicat
On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote:
> Andy,
> I don't see
> "log-slave-updates"
> in your master setup. I see log-bin, but I "think" that only applies to
> updates done directly to the database (not replication updates). I'm not 100%
> sure about that, but it may be worth looki
On Wed, Aug 06, 2003 at 11:23:31AM -0400, walt wrote:
> On Wednesday 06 August 2003 11:13 am, Andy Smith wrote:
> > On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote:
> > > On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote:
> > > > Andy,
> > > > I don't see
> > > > "log-slave-updates"
>
On Wed, Aug 06, 2003 at 07:00:33PM -0700, Steven Roussey wrote:
> > So does anyone else have any ideas what is going on here? Shall I
> > report this as a bug?
>
> Did you post how you setup the servers to load the different my.cnf
> files? Hopefully you don't have one at a default location.
I d
On Wed, Aug 06, 2003 at 12:16:40PM -0400, walt wrote:
> On Wednesday 06 August 2003 11:50 am, Andy Smith wrote:
> > $ cat mysql/master.info
> > angora-bin.001
> > 20102800
> > 127.0.0.1
> > repl
> > removed
> > 3306
> > 60
> >
> > Looks fine to me. :(
>
> Looks fine to me as well
> Are you sti
On Wednesday 06 August 2003 11:50 am, Andy Smith wrote:
> > There is one more thing I can think of to check...
> > Can you send me a copy of the
> > "master.info" file. I've had to manually change it before after changing
> > the master in the my.cnf file. I found out later that you could do
> > "C
On Wed, Aug 06, 2003 at 11:39:26AM -0400, walt wrote:
> On Wednesday 06 August 2003 11:26 am, Andy Smith wrote:
> > > Andy,
> > > I just noticed that you have
> > > a mix of port numbers. Can you try
> > > `netstat -an | grep 3306`
> > > from the command line and see if the master is indeed listeni
So does anyone else have any ideas what is going on here? Shall I
report this as a bug?
On Wed, Aug 06, 2003 at 02:19:21PM +0100, Andy Smith wrote:
> Hi folks, trying to set up replication and I'm getting this problem
> which I can't see how to fix despite reading of the manual and
> google.
>
>
On Thu, Aug 07, 2003 at 07:54:18AM +0100, Andy Smith wrote:
> On Wed, Aug 06, 2003 at 07:00:33PM -0700, Steven Roussey wrote:
> > > So does anyone else have any ideas what is going on here? Shall I
> > > report this as a bug?
> >
> > Did you post how you setup the servers to load the different my
> So does anyone else have any ideas what is going on here? Shall I
> report this as a bug?
Did you post how you setup the servers to load the different my.cnf
files? Hopefully you don't have one at a default location.
Otherwise, it sounds like the config information is not properly set --
eithe
On Wednesday 06 August 2003 11:26 am, Andy Smith wrote:
> > Andy,
> > I just noticed that you have
> > a mix of port numbers. Can you try
> > `netstat -an | grep 3306`
> > from the command line and see if the master is indeed listening on that
> > port?
>
> $ netstat -an | grep 3306
> tcp0
On Wed, Aug 06, 2003 at 10:32:23AM -0400, walt wrote:
> Andy,
> Can you send a copy of your my.cnf file for both the slave and master
> database.
Sure.
Slave:
[client]
port=3307
socket=/data/mysql-backup/mysql.sock
[mysqld]
port=3307
socket=/data/mysql-backup/mysql.sock
server-id=4
log-warnings
On Wednesday 06 August 2003 11:13 am, Andy Smith wrote:
> On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote:
> > On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote:
> > > Andy,
> > > I don't see
> > > "log-slave-updates"
> > > in your master setup. I see log-bin, but I "think" that only
o help the opens source comunity ...
- Original Message -
From: "Jonathan Fowler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 31, 2003 4:34 AM
Subject: Re: replication problem
> www.kapadiaz.com = download free movies songs and also free 5 gb
www.kapadiaz.com = download free movies songs and also free 5 gb hosting
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Naoufal Rih <[EMAIL PROTECTED]> wrote:
> Hi
> I have 3 machines M1 M2 and M3, i need to setup the following :
> M1 is the master
> M2 is reading from M1
> M2 is a master for M3
> M3 is reading from M2
> The problem i got, is when i run a command in M2, it's replicated in M3,
> but when the command
Andrew Staples wrote:
I've setup my my.cnf file on the slave as:
[mysql.server]
user=mysql
basedir=/var/lib
socket=/var/lib/mysql/mysql.sock
server-id=2
master-host=206.xxx.xxx.xxx
master-user=replicateuser
master-password=replicatepassword
Master.info is:
tux-bin.001
3109
206.xxx.xxx.xxx
repli
On Wednesday 26 February 2003 10:19, Kirill Peskov (WEB-EU) wrote:
> Looks like we've mixed up two threads into one ;-)
>
> As I understood from various forums and maillists, versions 4.x are
> still in development state.
Yup, 4.0.X is gamma.
> The newest production version is 3.23.55,
> am
Looks like we've mixed up two threads into one ;-)
As I understood from various forums and maillists, versions 4.x are
still in development state. The newest production version is 3.23.55,
am I right? Do you recommend this version for testing?
Regards,
Kirill
Egor Egorov wrote:
On Tuesday 25
TECTED]
> Sent: Tuesday, February 25, 2003 8:28 AM
> To: [EMAIL PROTECTED]
> Subject: re: Replication problem (alter table fails)
>
> On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote:
> > Coud you, please, give an advice to solve following problem:
> >
> &
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 8:28 AM
To: [EMAIL PROTECTED]
Subject: re: Replication problem (alter table fails)
On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote:
> Coud you, please, give an advice to solve follow
On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote:
> Coud you, please, give an advice to solve following problem:
>
> I've got two Mysql Servers:
>
> * Master: Sparc Solaris 8, MySQL 3.23.32
> * Slave: RedHat Linux 7.2, MySQL 3.23.32
>
> Replication of data runs fine, all "in
I've narrowed it down a lot. We have two different PHP interfaces for the
database. One is for employees to access the data, and the other is for
customers. The UPDATEs and INSERTs on the system that customers use is not
being replicated, but the one that employees is working perfectly.
Th
On Friday 22 November 2002 17:19, RAHARD Matthieu wrote:
> I set up replication on my servers since the version 3.23.43. Recently I
> upgrade all my servers to version 4.0.3.
> The replication work fine for insert and delete queries (also alter table)
> but doesn't take care of update queries.
re
Piasecki
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 8:34 AM
To: [EMAIL PROTECTED]
Subject: re: replication problem
David,
Monday, September 23, 2002, 6:03:58 PM, you wrote:
DP> We are having a problem which seems to h
David,
Monday, September 23, 2002, 6:03:58 PM, you wrote:
DP> We are having a problem which seems to have appeared recently with
DP> replication on our mysql servers.
DP> - We have 3 servers set up with mysql 3.23.52 (they were running .49 but
DP> we upgraded in an attempt to fix this problem,
r/lib/mysql/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
---
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 08, 2002 3:45 PM
To: Jamie Beu
Cc: [EMAIL PROTECTED]
Subject: Re: Replication problem: slave can't lo
On Thu, Sep 05, 2002 at 09:52:05AM -0400, Jamie Beu wrote:
>
> I am attempting to setup MySQL replication between the ctiadb1 (master)
> server and the ctiadb2 (slave) server.
>
> When I look at the mysql.log file on the slave, I see the following
> (repeated every 60 seconds):
> 020904 12:00:30
al Message-
From: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 11:02 PM
To: Jamie Beu
Cc: [EMAIL PROTECTED]
Subject: Re: Replication problem: slave can't log into master (update)
Pada Thu, 5 Sep 2002 12:35:45 -0400
"Jamie Beu" <[EMAIL PROT
Pada Thu, 5 Sep 2002 12:35:45 -0400
"Jamie Beu" <[EMAIL PROTECTED]> menulis :
> I am still having problems with the slave server being able to connect to
> the master, but a thought occured to me while we were working another topic.
>
> Please let me know what I'm missing. I can do the following
At 05:27 PM 8/20/2002 -0400, walt wrote:
> > I have added this one, thanks.
>Hmmm...
>When you set up the master database, did you copy all the *.frm, *.MYD, *.MYI
>to the slave database?
Ok, after a lot of hair-pulling, I downgraded and used 3.23, and what do
you know, replication worked out fi
On Tuesday 20 August 2002 09:02 pm, Froilan Mendoza wrote:
> Walt,
>
> At 01:09 PM 8/20/2002 -0400, walt wrote:
> >on the slave you should run
> >show slave status
>
> on slave:
> mysql> show slave status;
> +-+-+-+---+
>-+---
Walt,
At 01:09 PM 8/20/2002 -0400, walt wrote:
>on the slave you should run
>show slave status
on slave:
mysql> show slave status;
+-+-+-+---+-+-+--+---+---
Froilan Mendoza wrote:
> Hello,
>
> I have two machines that I am trying to use replication on. Here are their
> configurations:
> master (my.cnf)
> log-bin
> serveri-d = 1
>
> slave:
> server-id = 2
> master-host=master.domain.com
> master-user=replicate
> master-password=replicatedb
> lo
Apparently I had list File permissions with my user. Thanks anyway.
-James
-Original Message-
From: James Kelty [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:06 AM
To: [EMAIL PROTECTED]
Subject: Replication Problem
Hello,
I have this replication problem. I am getting thi
1 - 100 of 126 matches
Mail list logo
