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
2014/1/17 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. I'm thinking it's
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 ol
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 ar
> 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:
http:
2012/10/25 Sabika M
> 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 of A (take B out
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 1
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 intermedia
nge.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
>>
Message-
> 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 th
cky.
>
>> -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?
>>
>>
>>
>&
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: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?
ad
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 d
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 proj
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
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 fr
- 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 t
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 slav
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 architectur
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 lu
> -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 i
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.
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 rep
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 questio
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' so...
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:
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
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 h
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 Thu,
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 an
Nobody has any advice for this one?
Jeff
> -Original Message-
> From: Jeff McKeon
> Sent: Tuesday, August 19, 2003 8:22 AM
> To: [EMAIL PROTECTED]
> Subject: Replication question
>
>
> Hey all,
>
> I have 3 databases replicating (ver 3.23) A to B and B to C
>
> On C I want to modify
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 repli
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:02、woody at nfri dot com さんは書きました:
> I am in the process of setting up replication for my mysql servers
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 in
003 03:05
À : RAHARD 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 ?
>
> Tab
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
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 leve
> 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 bot
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
li
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
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> MASTER_SERVER_ID=ser
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 Repl
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 m
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.
Wh
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 triv
> 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
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
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 retr
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.
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 slav
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
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 stoo
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
>
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;
+--+-+-+---+---+-+---+
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.0
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|
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 answe
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
On Sun, Feb 25, 2001 at 09:49:43AM +0900, ÇãÁ¤¼ö wrote:
>
> If slave went down, while master worked and some update made on
> master. after slave restart, slave could not get update information
> and slave's data unchanged.
It sound like you are using a version of MySQL that had a replication
bu
On Wed, Jan 24, 2001 at 10:45:53PM -0500, Scott Vanderweyst wrote:
>
> I have a couple of questions regarding replication in MySQL:
>
> 1) does it work well/handle loss of connections due to network
> outages/delays; we have a geographically diverse environment, and were
> hoping to be able to re
65 matches
Mail list logo
