hello, I would like to set that option in mysql 5.0.45 on my slave server:
|master-retry-count=800
my slave status:
Slave_IO_State: Queueing master event to the relay log
Master_Host: xx.xx.xx.xx
Master_User: fmRepl
Master_Port: 3306
Hi,
I keep getting the below in the error log. I can't see any problems (no
other errors and replication is working) and the master DB is available
the whole time.
070928 12:07:31 [Note] Slave: received end packet from server, apparent
master shutdown:
070928 12:07:31 [Note] Slave I/O thread:
round up
the hardware to test a 50 node configuration.
On 6/8/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi sol,
sol beach wrote:
I have limited experience with MYSQL replication; which is why I am
hoping
others with more experience can answer a question or two.
Let's say I have a MASTER
://blog.irwan.name/?p=118
Jimmy Guerrero
Sr Product Manager
MySQL, Inc
Houston, TX
sol beach wrote:
I have limited experience with MYSQL replication; which is why I am
hoping
others with more experience can answer a question or two.
Let's say I have a MASTER MYSQL database.
Let's say there are 50 - 60 other
also gives you failover capabilities.
Mohd posted a blog on his experience yesterday.
See: http://blog.irwan.name/?p=118
Jimmy Guerrero
Sr Product Manager
MySQL, Inc
Houston, TX
sol beach wrote:
I have limited experience with MYSQL replication; which is why I am hoping
others with more
Hi sol,
sol beach wrote:
I have limited experience with MYSQL replication; which is why I am hoping
others with more experience can answer a question or two.
Let's say I have a MASTER MYSQL database.
Let's say there are 50 - 60 other systems where I'd like to have MYSQL
running on these slave
I have limited experience with MYSQL replication; which is why I am hoping
others with more experience can answer a question or two.
Let's say I have a MASTER MYSQL database.
Let's say there are 50 - 60 other systems where I'd like to have MYSQL
running on these slave systems.
These slave systems
Replication Chapter Revamped
We have completely reworked the replication chapter for the 5.1 manual.
This targets a number of issues, including a major redesign (to make it
easier to read and find topics), some updates to the information and
processes, and
Very cool - looking forward to reading it with the new replication
options in 5.1
David
Stefan Hinz wrote:
Replication Chapter Revamped
We have completely reworked the replication chapter for the 5.1 manual.
This targets a number of issues, including a major
Thought this might be of interest to some on the list:
http://www.oreilly.com/catalog/hpmysql/chapter/ch07.pdf
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
i have a problem with my replication setup and SET statments.
The SET statments seem to be not logged with the queries.
An example:
CREATE TABLE blablub (ID INT NOT NULL auto_increment PRIMARY KEY, bla text,
blub text);
SET @bla='bla';
SET @blub='blub';
INSERT INTO blablub VALUES(NULL,
/mysql/en/replication-features.html
--Ware
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
It seems like a documented bug. Switch to 4.1.12. See:
http://dev.mysql.com/doc/mysql/en/replication-features.html
Markus Benning [EMAIL PROTECTED] wrote:
Hello,
i have a problem with my replication setup and SET statments.
The SET statments seem to be not logged
Hi All!
I'm using the latest mysql 4.0.x and I've successfully
set-up database replication on it over 2 machines.
I have noticed though that mysql doesn't seem to
replicate CREATE TABLE operations on the master to the
slave. Is this a limitation? Or I just missed
something. If so, can someone
Hello.
In my replication setup with 4.1.11 master and 5.0.4 slave
CREATE TABLE and CREATE DATABASE statements are replicated
perfectly.
Shannon R. [EMAIL PROTECTED] wrote:
Hi All!
I'm using the latest mysql 4.0.x and I've successfully
set-up database replication on it over 2
I use Debian Sarge as my Linux distribution on two servers who replicate MySQL.
Every time I upgrade the MySQL package my replication dies.
Any ideas why?
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
MySQL.
Every time I upgrade the MySQL package my replication dies.
Any ideas why?
Thanks,
Jacob
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net
check next time.
Thanks,
Jacob
Jacob Friis Larsen [EMAIL PROTECTED] wrote:
I use Debian Sarge as my Linux distribution on two servers who replicate
MySQL.
Every time I upgrade the MySQL package my replication dies.
Any ideas why?
Thanks,
Jacob
--
For technical
Hello,
I found a question about Oracle 2 MySQL replication in the
archive on Sep. 2001 but no mention since?
We have a department using Oracle 8.1.7 and I'm running MySQL
4.0 and neither of us wants to change :-)
I could call a Perl, C++ or Java program from cron to periodically
update
On Tue, Jul 13, 2004 at 06:11:22PM -0700, Carl Edwards wrote:
Hello,
I found a question about Oracle 2 MySQL replication in the
archive on Sep. 2001 but no mention since?
We have a department using Oracle 8.1.7 and I'm running MySQL
4.0 and neither of us wants to change :-)
I could
.
--- Jeremy Zawodny [EMAIL PROTECTED] wrote:
On Tue, Jul 13, 2004 at 06:11:22PM -0700, Carl
Edwards wrote:
Hello,
I found a question about Oracle 2 MySQL
replication in the
archive on Sep. 2001 but no mention since?
We have a department using Oracle 8.1.7 and I'm
running MySQL
4.0
Hi,
I am new to mysql and having some trouble with replication. Simple stuff like,
1. How to restart the stopped resplication,
2. How to check if the replication is working,
3. How to bring the slave into master status when master crashes,
4. How to restore master and re-enable
Victoria Reznichenko wrote:
relay-log-purge is available from 4.1.1. Do you use 4.1.1 or 4.1.0?
Is it in the manual because relay-log-purge is available in 4.0.x?
AFAICT, 4.1.1 isn't available for download from the mysql.com site.
4.1.0-alpha is. How would one obtain 4.1.1?
Would this work to
At 13:26 -0500 10/11/03, Christopher L. Everett wrote:
Victoria Reznichenko wrote:
relay-log-purge is available from 4.1.1. Do you use 4.1.1 or 4.1.0?
Is it in the manual because relay-log-purge is available in 4.0.x?
Sorry, what?
AFAICT, 4.1.1 isn't available for download from the mysql.com
Christopher L. Everett [EMAIL PROTECTED] wrote:
The online manual at http://www.mysql.com/doc/en/Replication_Options.html
says that these two variables:
max-relay-log-size=#
relay-log-purge=0|1
exist to control the size of the relay log. But when I try to start my
slave server
with:
The online manual at http://www.mysql.com/doc/en/Replication_Options.html
says that these two variables:
max-relay-log-size=#
relay-log-purge=0|1
exist to control the size of the relay log. But when I try to start my
slave server
with:
set-variable = max-relay-log-size=192MB
set-variable =
Hi folks,
I just set up a slave server and it seemed to be working alright,
catching up with the new data, and then the server suddenly went away.
Looking at the slave's data directory, there are approximately 2
relay-bin files. I can't even restart the server now, because it gets a
No one has replied to my post.
- Original Message -
From: I.P. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 18, 2003 1:01 PM
Subject: mysql 4.0.14 + replication + windows XP PROF
Hi, it's my story.
I have two 4.0.14 mysql server on one machine with win XP
Hi, it's my story.
I have two 4.0.14 mysql server on one machine with win XP Professional
polish version.
First acts as master: on port 3300
Second acts as slave: on port 3301
below my configuration:
### FOR MASTER #
# This will be passed to all mysql clients
[client]
Ivan Hoo wrote:
how do you secure the replication link between the master and the slave
using SSH. i understand that you can do that over mysql client and its
server. pls enlighten me coz i m looking high and low for a solution on this issue.
On the slave:
ssh --local-forward(?)
On Wed, Jan 22, 2003 at 02:27:40PM -0500, Michael T. Babcock wrote:
Ivan Hoo wrote:
how do you secure the replication link between the master and the slave
using SSH. i understand that you can do that over mysql client and its
server. pls enlighten me coz i m looking high and low for a
On Fri, 2003-01-17 at 08:51, Ivan Hoo wrote:
is there any way you can implement a secure replication via ssh or sth else?
Who can implement?
As user you can use SSH tunnel with it. There are many tutorial about
making SSH tunneling in the internet. I believe if MySQL will have some
kind of
there seem to be a lack of documentation on this part.
Mostly because it can't be done (that I'm aware of).
if it can't be done, why is it in the documentation already. i can
understand that if 4.0.x is still in alpha or beta stage. but now it is
almost near release (gamma).
the official
On Tue, 2003-01-14 at 20:47, Jeremy Zawodny wrote:
has anyone been able to setup ssl secure replication for mysql?
I don't believe you can do that yet. There's now way to specify the
necessary credentials in the slave setup.
how do i know whether the replication is actually done over
At 23:17 +0800 1/16/03, Ivan Hoo wrote:
there seem to be a lack of documentation on this part.
Mostly because it can't be done (that I'm aware of).
if it can't be done, why is it in the documentation already. i can
understand that if 4.0.x is still in alpha or beta stage. but now it is
is there any way you can implement a secure replication via ssh or sth else?
regards,
ivan
At 23:17 +0800 1/16/03, Ivan Hoo wrote:
there seem to be a lack of documentation on this part.
Mostly because it can't be done (that I'm aware of).
if it can't be done, why is it in the
Jeremy Zawodny wrote:
there seem to be a lack of documentation on this part.
Mostly because it can't be done (that I'm aware of).
Except with stunnel (often recommended) or SSH (which I've had running
for months doing this). PS, as with the MySQL daemon, I run my ssh
tunnel under
Mostly because it can't be done (that I'm aware of).
Except with stunnel (often recommended) or SSH (which I've had running
for months doing this).
Another option is CIPE, a method for secure tunnelling of any IP protocol
using virtual network interfaces. I believe CIPE comes as standard with
On Wed, Jan 15, 2003 at 09:18:50AM -0500, Michael T. Babcock wrote:
Jeremy Zawodny wrote:
there seem to be a lack of documentation on this part.
Mostly because it can't be done (that I'm aware of).
Except with stunnel (often recommended) or SSH (which I've had running
for
On Wed, Jan 15, 2003 at 04:49:03PM -, Basil Hussain wrote:
Mostly because it can't be done (that I'm aware of).
Except with stunnel (often recommended) or SSH (which I've had running
for months doing this).
Another option is CIPE, a method for secure tunnelling of any IP protocol
Except with stunnel (often recommended) or SSH (which I've had running
for months doing this). PS, as with the MySQL daemon, I run my ssh
tunnel under 'supervise' so as to make sure its always there and
restarts if it gets killed / dies / is stupid / upgraded.
Right. I should have
On Mon, Jan 13, 2003 at 02:46:45PM +0800, Ivan Hoo wrote:
hi All,
has anyone been able to setup ssl secure replication for mysql?
I don't believe you can do that yet. There's now way to specify the
necessary credentials in the slave setup.
how do i know whether the replication is actually
hi All,
has anyone been able to setup ssl secure replication for mysql? how do i
know whether the replication is actually done over ssl? there seem to be a
lack of documentation on this part. appreciate a lot if someone could
provide some feedback on this. i m currently running mysql-4.0.7-gamma
Dear Sir/Madam,
I have tried the config below, and I successfully see the replicated record in
client side but only ONCE.
After I have seen the replication works. I continued with my normal
transactional work including altering table structure.
But later when I checked the replication status.
MySQL Bothway Replication - Fail Back - Hold Master while Slave is
Synchronizing.
I have the following question:
Is it possible to have a slave on machine M1 synchronizing with a master
on another machine M2 while the master on the first machine M1 does not
accept requests yet (i.e
Hello all,
I was check up 4.0.3 (from the Development Source Tree), bug still exist.
Description:
aor I use replication circle (A-B, B-A) with 3.23.51 - all ok.
aor But I got problem, when upgrade both my servers to 4.0.2.
aor Mysqld create 30 new bin-log files every
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
Description:
I use replication circle (A-B, B-A) with 3.23.51 - all ok.
But I got problem, when upgrade both my servers to 4.0.2.
Mysqld create 30 new bin-log files every second at both servers:
---
[www2:/opt/mysql-dev/var]:1303# ls -1
On Wed, Jul 17, 2002 at 12:02:08PM +0300, Heikki Tuuri wrote:
Jon,
replication 4.0.1 - 4.0.2 does not work because the format in the 4.0
series has evolved. Currently, if your master of the 4.0 series, your slave
must be of the exact same release.
How likely is that to happen again? I
Jeremy,
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: Jon Frisby [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 19, 2002 7:17 AM
Subject: Re: MySQL 4.0.2 replication going bonkers?
On Wed, Jul 17, 2002 at 12:02:08PM +0300
AM
Subject: RE: MySQL 4.0.2 replication going bonkers?
This seems to have not gotten through... Perhaps the spam filter ate it?
(sql, query)
-JF
-Original Message-
From: Jon Frisby [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 4:27 PM
To: [EMAIL PROTECTED]
Subject
We recently set up a 4.0.2 slave, which worked fine -- we loaded our data
snapshot (taken via mysqldump) and were able to perform complex queries
without problems...
However, as soon as we tried to get this machine to act as a slave to a
4.0.1 server it crashed. Immediately upon executing SLAVE
This seems to have not gotten through... Perhaps the spam filter ate it?
(sql, query)
-JF
-Original Message-
From: Jon Frisby [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 4:27 PM
To: [EMAIL PROTECTED]
Subject: MySQL 4.0.2 replication going bonkers?
We recently set up
Hi, all,
May i know is mySQL support replication
regards,
alice
/---\
Confidential and/ or privileged information may be contained in this
e-mail and any attachments transmitted with it ('Message'). If you
Yes it does.
http://www.mysql.com/doc/R/e/Replication_Implementation.html
- Original Message -
From: Alice [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 6:52 PM
Subject: Is mySQL support replication ??
Hi, all,
May i know is mySQL support replication
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
Hello,
I have 2 application running in a master/slave mode.
- Application A linked to a database D
- Application A' linked to a database D'
While A is master, A' is in standby mode and D' replicates D.
If a problem occurs on A, A' becomes master and D must replicate D'.
1) Is it possible for
Duc Chau ([EMAIL PROTECTED]) writes:
Can anyone tell me or point me to documentation on how to securely do
database replication over the internet?
I need to replicate to machines in datacenters in diffrent states. How
feasible is this? Has anyone done it? What are the security concerns
Can anyone tell me or point me to documentation on how to securely do
database replication over the internet?
I need to replicate to machines in datacenters in diffrent states. How
feasible is this? Has anyone done it? What are the security concerns with
doing this via the net? Thanks
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 3:50 PM
To: Duc Chau
Subject: Re: mysql db replication security across the internet
Your message cannot be posted because it appears to be either spam or
simply off topic to our
Anyone has any experience with mySQL in combination with data replication? Are there
products available out there that allows this?
Thanks
Daniel Åkerud
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
73 matches
Mail list logo