2014/1/17 Richard Reina gatorre...@gmail.com
I have 3 relay MySQL database servers on my small office LAN backing up a
master and 3 more machines backing up each relay (1 each). They are all
replicating all databases and all tables. The master although running fine
is almost eight years old.
Manuel,
Thank you very much for this information. This sounds like a very good
strategy. I think I will try switching some slaves from one relay to another to
familiarize myself and get practice and them do it to deploy a new master.
Again, thank you very much.
Richard
El Jan 18, 2014, a
Am 17.01.2014 22:42, schrieb Richard Reina:
I have 3 relay MySQL database servers on my small office LAN backing up a
master and 3 more machines backing up each relay (1 each). They are all
replicating all databases and all tables. The master although running fine
is almost eight years old.
On 24/07/2013 19:52, Rick James wrote:
4) 3 tables from the slaves are to be replicated back to the master
NO.
However, consider Percona XtraDb Cluster or MariaDB+Galera. They allow
multiple writable masters. But they won't let you be so selective about tables
not being replicated.
Here
4) 3 tables from the slaves are to be replicated back to the master
NO.
However, consider Percona XtraDb Cluster or MariaDB+Galera. They allow
multiple writable masters. But they won't let you be so selective about tables
not being replicated.
Here are the gotchas for Galera usage:
2012/10/25 Sabika M sabika.makhd...@gmail.com
I have replication setup in the following way:
A - B -C
I am making updates to server A. I want to stop all my updates and point
them to server C. After I start writing to server C, can I use the change
master statement to make the C the master
Sound right.
Be sure there are no writes during certain critical times. And that
replication is caught up.
If you want to verify the sameness see Percona's pt-table-checksum.
-Original Message-
From: Sabika M [mailto:sabika.makhd...@gmail.com]
Sent: Thursday, October 25, 2012 10:16
Am 24.08.2012 17:25, schrieb Richard Reina:
I have a couple of mysql database slaves and would like to make one of them
be a master as well so that I can set another machine to replicate from it.
Can anyone tell me how I should go about it or know of any howtos for this
specific task?
add
Pointing the other slave to the new master is a bit tricky.
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Friday, August 24, 2012 8:29 AM
To: mysql@lists.mysql.com
Subject: Re: Replication question: How to make a slave a master?
Am 24.08.2012 17
.
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Friday, August 24, 2012 8:29 AM
To: mysql@lists.mysql.com
Subject: Re: Replication question: How to make a slave a master?
Am 24.08.2012 17:25, schrieb Richard Reina:
I have a couple of mysql database
-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Friday, August 24, 2012 2:43 PM
To: mysql@lists.mysql.com
Subject: Re: Replication question: How to make a slave a master?
what would be tricky?
remove all relay-logs, remove master.info adn that was it done this
many times in the last
@lists.mysql.com
Subject: Re: Replication question: How to make a slave a master?
what would be tricky?
remove all relay-logs, remove master.info adn that was it done this
many times in the last years and it takes 30 seconds if you are fast
enough to type the slave-commands
Am 24.08.2012 23:35
Are you trying to promote a slave as a new master and replace current master or
create intermediate slave? If it is the latter all you need to do is to:
1. Stop the slave
2. Add log_slave_updates = 1 in the slave's config file
3. Copy the slave files to the new slave(s)
4. Start your
On Mon, Oct 13, 2008 at 11:43 AM, AM Corona [EMAIL PROTECTED] wrote:
In mysql 4, can one replicate a database to another server but have the DB
name on the slave server be different?
Master : dbname1
Slave: dbname1
AND
Slave : dbname2 (but contains data from db2name1)
A project
In the last episode (Oct 13), AM Corona said:
In mysql 4, can one replicate a database to another server but have the DB
name on the slave server be different?
Master : dbname1
Slave: dbname1
AND
Slave : dbname2 (but contains data from db2name1)
So you want the same data in two
In the last episode (Jul 03), mos said:
If I'm replicating a master database to a slave (MyISAM tables), but
the slave is busy serving up web pages, how does it get write access
to the slave's table if it is always being read? TIA
Mysql places inserts in front of selects in its internal
- Original Message -
From: Kishore Jalleda
as per
http://dev.mysql.com/doc/mysql/en/replication-compatibility.html
there should be no problems
On 8/17/05, Jeff [EMAIL PROTECTED] wrote:
Does anyone know if there are any problems replicating from a master
database on version 4.0.16 to a
Hello.
According to:
http://dev.mysql.com/doc/mysql/en/replication-compatibility.html
you shouldn't have any problems, but 4.0.16 is a very old version.
I strongly recommend you to upgrade.
Jeff [EMAIL PROTECTED] wrote:
Does anyone know if there are any problems replicating from a
as per
http://dev.mysql.com/doc/mysql/en/replication-compatibility.html
there should be no problems
Kishore Jalleda
On 8/17/05, Jeff [EMAIL PROTECTED] wrote:
Does anyone know if there are any problems replicating from a master
database on version 4.0.16 to a slave running version 4.1.13?
Jason Lixfeld [EMAIL PROTECTED] wrote on 03/12/2004 03:32:32:
I'm very new to mysql and replication. I've got a case where I have 2
servers, each have database A and database B. I want server 1 to be
master for database A and slave for database B and I would like server
2 to be slave for
Jonas,
It's recommended in the docs that you upgrade your slaves to 5.0.0 before your Master
(http://www.mysql.com/doc/en/Replication_upgrade_5.0.html)
You shouldn't run into any problems with replicating InnoDB
tables.(http://www.mysql.com/doc/en/InnoDB_and_MySQL_Replication.html)
good
Jonas Lindén [EMAIL PROTECTED] wrote on 26/03/2004 07:56:18:
Hello list, I am about to embark on a little repliction mission;) I
was thinking about setting up a MySQL slave on my Windows box and
replicate my MySQL 5.0 Master which runs on my Linux box. Could the
mix of architectures
On Mon, 22 Dec 2003, Jeff McKeon wrote:
Is it possible to have 2 database on one server replicating from the
same Master server?
yes.
In other words. DB01 is the Master on System01,
System02 has DB01_rep1 and DB01_rep2, each with their own replication
from DB01.
Shouldn't be a problem.
I
-Original Message-
From: Tobias Asplund [mailto:[EMAIL PROTECTED]
Sent: Monday, December 22, 2003 11:21 AM
To: Jeff McKeon
Cc: [EMAIL PROTECTED]
Subject: Re: Replication Question
On Mon, 22 Dec 2003, Jeff McKeon wrote:
Is it possible to have 2 database on one server
Try slave start
-Original Message-
From: Andrew Hall [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 2:46 PM
To: [EMAIL PROTECTED]
Subject: replication question
Greetings,
Firstly I have searched the archives and received exactly 0 results
returned for 'START SLAVE 1064'
DUH!! I should have tried that...
Thank you!
Drew
On Fri, 2003-12-05 at 15:49, Victor Pendleton wrote:
Try slave start
-Original Message-
From: Andrew Hall [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 2:46 PM
To: [EMAIL PROTECTED]
Subject: replication question
Didn't have the list cc-ed.
-Forwarded Message-
From: Andrew Hall [EMAIL PROTECTED]
To: Mike Johnson [EMAIL PROTECTED]
Subject: RE: replication question
Date: Fri, 05 Dec 2003 16:17:14 -0500
Ok, at this point it appears my replication is working, but I have two
questions
SQL
Andrey Kotrekhov [EMAIL PROTECTED] wrote:
Sorry. I am wrong. Situation is worse.
Both tables aren't replicate to the slave.
But query try run it on slave :(
slave: mysql-4.0.13
master: mysql-4.0.14
What replication options do you use?
Full scheme is:
|
+-A|
I'm pretty sure you need to sync the entire database (all tables) to all
slaves before starting replication..Your servers are technically
already out of sync..
And no wonder it crashes, tables are missing in it's view..You need to
hit the initial replication setup manual pages..
On
Hi, All!
SQL, mysql
Sorry. I am wrong. Situation is worse.
Both tables aren't replicate to the slave.
But query try run it on slave :(
slave: mysql-4.0.13
master: mysql-4.0.14
I have 2 servers. 1-st is master, 2-d - slave.
But slave store only some tables of master.
For example, master has
Andrey Kotrekhov [EMAIL PROTECTED] wrote:
Sorry. I am wrong. Situation is worse.
Both tables aren't replicate to the slave.
But query try run it on slave :(
slave: mysql-4.0.13
master: mysql-4.0.14
What replication options do you use?
I have 2 servers. 1-st is master, 2-d - slave.
Should be fine as long as the column on C has a default and is not a
unique index.
---Original Message-
--From: Jeff McKeon [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, August 20, 2003 6:05 AM
--To: MySql
--Subject: RE: Replication question
--
--Nobody has any advice for this one
Replication just executes the commands in the binary log (i.e INSERT,
UPDATE, DELETE, ...). So if you make sure that you do not issue a DDL
for creation/altering in the master DB, everything should work fine.
However, I would advice against it (it is not a supported feature, but a
trick)
Cheers
Chris Petersen [EMAIL PROTECTED] wrote:
I work for a small (but very fast-growing) company, and we're about to
start deploying our new website. Because it has a live inventory
setup, and because our internal tools are so integrated with the
ecommerce side of things, I figure that replication
At 04:02 AM 7/4/2003 -0500, woody at nfri dot com wrote:
What kind of traffic volume is generated with replication, our database
has a pretty steady read/update volume throughout the day and its pretty
much 50/50 read/write. I do plan to offload some of the reads (such as
for daily reports and
Hi Woody,
I can't answer your question, but I just wanted you to know that I like your
signature ;-). Thats definitely a good one.!!
Best regards
Nils Valentin
Tokyo/Japan
2003 7 4 18:02woody at nfri dot com :
I am in the process of setting up replication for my mysql servers, and
had a
Hello everybody,
Is it possible to set up this kind of replication and what parameters I have
to set in the my.cnf file ?
Table A own by server A and replicated to server B and C
Table B own by server B and replicated to server A
Table C own by server C and replicated to server A
The mysql
On Wed, Feb 05, 2003 at 10:37:29AM +0100, RAHARD Matthieu wrote:
Hello everybody,
Is it possible to set up this kind of replication and what parameters I have
to set in the my.cnf file ?
Table A own by server A and replicated to server B and C
Table B own by server B and replicated to
Matthieu
Cc : mysql
Objet : Re: Replication question
On Wed, Feb 05, 2003 at 10:37:29AM +0100, RAHARD Matthieu wrote:
Hello everybody,
Is it possible to set up this kind of replication and what parameters I
have
to set in the my.cnf file ?
Table A own by server A and replicated to server B
I set up two-way replication with two servers, A and B.
Since all queries go to only one server, it seems not to matter.
Anyway.
When A starts it registers itself to B, and vice versa.
I thought query SHOW SLAVE HOSTS to A should shows only about
B and B should do about A, but both show
Alexander,
Saturday, September 28, 2002, 12:47:19 PM, you wrote:
AS Is it feasible to use replication to keep the database which powers my
AS website up-to-date? The database itself is on the hosting companies server
AS and contacted via dialup so the connection isn't there all of the time.
AS
That would be a great way to keep your website up to date.
The slave can handle loss of connection (though some data may not make sense if part
of it is missing), and resume where it has left of previously.
Or you could also manually start and stop the slave process when you know there is a
Keith,
Tuesday, August 13, 2002, 12:20:28 AM, you wrote:
KJ Is this command supported under version 3.23.51?
Nope. This command is supported since 4.0
KJ SHOW NEW MASTER FOR SLAVE WITH MASTER_LOG_FILE='logfile' AND
KJ MASTER_LOG_POS=pos AND MASTER_LOG_SEQ=log_seq AND
KJ
At 11:10 -0700 8/13/02, Vicky Gonzalez wrote:
Hi all,
I am a newbie here. I was hoping someone would be able to tell me if
hostnames for the Linux OS is required for MySql Replication, and if
so why? I have been combing the manual and archives, but had no luck
in finding this answer.
When
From: Paul DuBois on August 13, 2002 11:13 AM wrote in response:
At 11:10 -0700 8/13/02, Vicky Gonzalez wrote:
Hi all,
I am a newbie here. I was hoping someone would be able to tell me if
hostnames for the Linux OS is required for MySql Replication, and if
so why? I have been combing the
At 11:28 -0700 8/13/02, Vicky Gonzalez wrote:
From: Paul DuBois on August 13, 2002 11:13 AM wrote in response:
At 11:10 -0700 8/13/02, Vicky Gonzalez wrote:
Hi all,
I am a newbie here. I was hoping someone would be able to tell me if
hostnames for the Linux OS is required for MySql Replication,
On Thu, Jul 04, 2002 at 09:33:54AM +0100, David Shields wrote:
The MySQL manual for 3.23.38, Section 11.4 states that you can have a
replication chain A - B - C - A.
I guess this means
A Master B Slave
B Master C Slave
C Master A Slave
Can this loop be reduced to the most trivial case A
I am replicating to NT Server system from Red Hat Linux
was not aware of any issues to win2k from linux with replication
Is there something I am not aware of?
-Original Message-
From: Bartomiej Dolata [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 9:44 AM
To: Mysql@Lists.
hello,
I am replicating to NT Server system from Red Hat Linux
was not aware of any issues to win2k from linux with replication
Is there something I am not aware of?
i dont know, but i am having major problems with it.
i keep getting Slave: Failed reading log event, reconnecting to retry,
Are you positive that you are running compatible versions of MySql on both
platforms?
- Original Message -
From: Terry [EMAIL PROTECTED]
To: Luc Foisy [EMAIL PROTECTED]; MYSQL-List (E-mail)
[EMAIL PROTECTED]
Sent: Monday, June 10, 2002 9:59 AM
Subject: RE: replication question
| hello
Subject: Re: replication question
Are you positive that you are running compatible versions
of MySql on both
platforms?
linux: mysql rebuild from source rpm:
/usr/sbin/mysqld, Version: 3.23.49-log, started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
openbsd: mysql build from
Jeremy
You can set it up so that the slave only gets updates to certain
databases. Have you looked at the replication docs in the manual yet?
Yes I did, but what put me off slightly was the concept of a master
and slave. My requirement is per sql database not per sql server.
Am I being stoopid
Hi Rob
Read the manual, you can do exactly what you need to and it is explained in
the manual. I am doing it myself.
Regards
Warren
You can set it up so that the slave only gets updates to certain
databases. Have you looked at the replication docs in the manual yet?
Yes I did, but what
On Wed, Mar 20, 2002 at 11:51:47AM -, Rob Moore wrote:
Jeremy
You can set it up so that the slave only gets updates to certain
databases. Have you looked at the replication docs in the manual yet?
Yes I did, but what put me off slightly was the concept of a master
and slave. My
On Wed, Mar 20, 2002 at 02:02:49AM -, Rob Moore wrote:
Hi there
Apologies if this has been asked before; couldnt find anything
in archives...
We have a mysql database on a web server that I transfer manually to
an office machine, and a different database on the office machine
that I
On Fri, Feb 15, 2002 at 10:32:06AM +, Simon Windsor wrote:
Currently, I maintain two mysql server, hosted by separate ISPs, and
keep them synchronised using standard MySQL replication.
Great!
Server A is master+slave to server B, and likewise server B is master
+slave to server A.
The problem is still occurring. As I said in my earlier message, it
tends to (but is not limited to) the beginning of a binary log file.
Here is an example:
mysql show slave status;
On Sun, Sep 02, 2001 at 11:40:08AM -0700, Mike Wexler wrote:
I have a slave server and a master server both running 3.23.38.
Every once in a while the slave stops updating:
| db1.tias.com | slave | 3306| 60|
spode-bin.005 | 912992502 | No|
Jeremy Zawodny wrote:
On Sun, Sep 02, 2001 at 11:40:08AM -0700, Mike Wexler wrote:
I have a slave server and a master server both running 3.23.38.
Every once in a while the slave stops updating:
| db1.tias.com | slave | 3306| 60|
spode-bin.005 |
On Mon, Apr 30, 2001 at 02:24:53PM +1200, Desmond Armstrong wrote:
Hi everyone,
I was wondering if anyone could help me/or has come across the following
problem:
It appears to have nothing to do with MySQL, so you might try asking
in a more on-topic forum.
Jeremy
--
Jeremy D. Zawodny,
wrote:
Hi...
I Have a Master(version 3.23.33) and
one Slave(version 3.23.32)
When I shutdown the slave,
And make some change Master.
then I restart the slave.
But, Slave didn't catch the change on Master.
bug or feature?
thank you for advanced answer.
3.23.32 has a
On Sun, Feb 25, 2001 at 03:29:37PM +0900, wrote:
It sounds like you are using a version of MySQL that had a
replication bug in it. I suspect that if you upgrade to 3.23.33 the
problem will go away.
No, Master is 3.23.33, and slave is 3.23.32
3.23.32 was troublesome for slaves.
Here
62 matches
Mail list logo