I highly recommend you update the slave to the same version as the master.
Mark D. Wallace wrote:
I'm trying to set up a replication database and cannot get the slave
to parse the log files on the master.
The slave is connecting to the master as indicated in the log file.
I have tried to
I'm trying to set up a replication database and cannot get the slave to
parse the log files on the master.
The slave is connecting to the master as indicated in the log file.
I have tried to connect directly to the master database from the mysql
client on the slave and have no problem using
All,
How can I notify an application running on the slave server that the slave
database has just updated itself by means of replication. The reason I ask
is that I know MySql currently doesn't support triggers, but my application
needs to be notified when an update on the slave has just taken
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote:
All,
How can I notify an application running on the slave server that the
slave database has just updated itself by means of replication. The
reason I ask is that I know MySql currently doesn't support
triggers, but my application
PROTECTED]]
Sent: Thursday, March 07, 2002 10:42 AM
To: Thi Cao
Cc: MySQL
Subject: Re: MySql Database Replication Question
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote:
All,
How can I notify an application running on the slave server that the
slave database has just updated itself
privileges. For example, to create a user named repl
which can access your master from any host, you might use this command:
GRANT FILE ON *.* TO repl@% IDENTIFIED BY 'password';
Thi Cao wrote:
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get
11:02 AM
To: Thi Cao
Cc: MySQL
Subject: RE: MySQL Database Replication
On Wed, 2002-03-06 at 14:26, Thi Cao wrote:
When I grant privileges as follows, the slave gets updated:
GRANT FILE ON *.* to repl@'%' identified by 'some_password';
Could someone please tell me why I must grant the FILE
-Original Message-
From: Thi Cao [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 12:04 PM
To: Thi Cao
Cc: MySQL
Subject: RE: MySQL Database Replication
ds,
If I understand you correctly, that also means that the user repl can access
the mysql database where all the privilege info
Yes, I did flush the privileges when nothing else worked but that didn't do
the trick either. Thanks for trying.
-Original Message-
From: James Housley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 6:00 PM
To: Thi Cao
Cc: MySQL
Subject: Re: MySQL Database Replication
Thi
-Original Message-
From: James Housley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 6:00 PM
To: Thi Cao
Cc: MySQL
Subject: Re: MySQL Database Replication
Thi Cao wrote:
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get
it to work
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get
it to work yet. The problem reported in the error log of the slave server
is as follows:
Error reading packet from server: Access denied for user 'repl@slave_host'
(Using password: YES) (read_errno 0
Thi Cao wrote:
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get
it to work yet. The problem reported in the error log of the slave server
is as follows:
Error reading packet from server: Access denied for user 'repl@slave_host'
(Using
On Sat, May 19, 2001 at 01:18:42PM -0500, David Gullett wrote:
I have 10 or so MySQL servers in the field, all writing data to a
database of the same name. I would like to set up replication from
all masters back to a single slave server and have each master write
to a different database.
I have 10 or so MySQL servers in the field, all writing data to a database
of the same name. I would like to set up replication from all masters back
to a single slave server and have each master write to a different database.
Is there an easy way to do this, short of running multiple instances
14 matches
Mail list logo