On 7 Mar 2007, at 06:39, Cabbar Duzayak wrote:
I am particularly interested in master-to-master replication (not even
sure if this is possible with mysql) and/or real-world usage
scenarios/examples as to how much load it can handle, how reliable it
is, etc?
I've had some success with it.
I fo
link for more info:
http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html
hope this helps
Adrian
Cabbar Duzayak wrote:
Hi All,
Would it be possible to provide some advanced pointers
(articles/books/tutorials/sites) for learning more about replication?
I am particularly
Hi All,
Would it be possible to provide some advanced pointers
(articles/books/tutorials/sites) for learning more about replication?
I am particularly interested in master-to-master replication (not even
sure if this is possible with mysql) and/or real-world usage
scenarios/examples as to how
Here are two posts on list that you might find relevant:
http://lists.mysql.com/mysql/182017
http://lists.mysql.com/mysql/180889
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Tue, 12 Apr 2005, Luis Calero wrote:
> Hello, I've been discussing with a coworker if it's possible to
>
Hello.
Similar questions are often asked in the list. Search in
archives about various solutions at http://lists.mysql.com/mysql.
See:
http://dev.mysql.com/doc/mysql/en/replication-faq.html
Luis Calero <[EMAIL PROTECTED]> wrote:
> Hello, I've been discussing with a coworker if it's
Hello, I've been discussing with a coworker if it's possible to
setup the following replication scenario: We've got two boxes, machine
A that has machine B as his master, and machine B that has machine A
as his master (A->B B->A), both boxes are masters and slaves. Over
this two boxes there's an
]
Sent: 19 November 2004 08:01
To: [EMAIL PROTECTED]
Subject: Re: 2 questions about Replication
Hello.
MySQL only supports one master and many slaves.
As I saw in comments at:
http://dev.mysql.com/doc/mysql/en/Replication_Options.html
You may use replicate-rewrite-db for tables:
replicate
Hello.
MySQL only supports one master and many slaves.
As I saw in comments at:
http://dev.mysql.com/doc/mysql/en/Replication_Options.html
You may use replicate-rewrite-db for tables:
replicate-rewrite-db = RemoteTableName ->LocalTableName
>i have 2 questions about Repli
Hello,
i have 2 questions about Replication.
1) I managed to make one slave and one master. The replication works fine and
it updates only one table from one database (cause of the
replicate-do-table=db.table1). The first question is can I tell mysql that
table1 from master to be named table2
On Mon, Feb 16, 2004 at 02:41:30PM -0300, Ronan Lucio wrote:
> Hi All,
>
> A short question:
> If I have a slave MySQL Server (updating via logs).
>
> Supposing the master MySQL (for any reason) goes down.
> The users start using (and updating) the slave database.
>
> When the master MySQL goes
Hi All,
A short question:
If I have a slave MySQL Server (updating via logs).
Supposing the master MySQL (for any reason) goes down.
The users start using (and updating) the slave database.
When the master MySQL goes up. Does it will update it´s data
from the slave database?
Thank´s
Ronan
--
Hi,
I have done a show processlist\G right after I start slave.
*** 1. row ***
Id: 1
User: martin
Host: localhost:1110
db: NULL
Command: Query
Time: 0
State: NULL
Info: show processlist
*** 2. row
nal Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 11, 2004 6:50 AM
Subject: Re: question about replication
> "Liying Huang" <[EMAIL PROTECTED]> wrote:
> >
> > I have tried to upgrade my
"Liying Huang" <[EMAIL PROTECTED]> wrote:
>
> I have tried to upgrade mysql to 4.0.17 version, still
> have the same problem. All queries shown in relay-bin
> file at slave, but slave database is not updating. I
> read documentation, but can't find helpful information
> on this.
Do you use any re
I have tried to upgrade mysql to 4.0.17 version, still
have the same problem. All queries shown in relay-bin
file at slave, but slave database is not updating. I
read documentation, but can't find helpful information
on this.
Liying
--
MySQL General Mailing List
For list archives: http://list
I only replicate the simplest, master->slave.
I used MySQL 4.0.11 version in both PCs.
Liying
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 10, 2004 5:32 AM
Subject: Re: question about repl
"Liying Huang" <[EMAIL PROTECTED]> wrote:
> I tried to create replication. I have edited my.cnf on master and slave side.
>
> Grant necessary privileges on master side, then start both servers, when I update
>
> the database in master side, I could see the query showed up in ***-bin.001,
>
> a
Hi,
I tried to create replication. I have edited my.cnf on master and slave side.
Grant necessary privileges on master side, then start both servers, when I update
the database in master side, I could see the query showed up in ***-bin.001,
and it is passed to slave side successfully, shown
I've followed the http://www.mysql.com/doc/en/Replication_HOWTO.html but
i've this error
:-(
***
030710 22:36:43 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'webser
"MaFai" <[EMAIL PROTECTED]> wrote:
>
> I would also like to know the impact when:-
> - the master db fail
> - a lot of insert/update transactions in the master, would it replicate
> immediately to the 2nd database
If the mater db fail, how can be many inserts/updates?
> - when the secondary db f
Hello, mysql,
I would also like to know the impact when:-
- the master db fail
- a lot of insert/update transactions in the master, would it replicate
immediately to the 2nd database
- when the secondary db fail, the master cannot send the data to the 2nd,
would the data queue up ?
- Any chance fo
et. You are welcome to inquire off-list about it if you
are so inclined.
Dane Foster
- Original Message -
From: "MaFai" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 00:00
Subject: about replication
Hello,
On Thu, Jun 12, 2003 at 09:51:06AM +0800, MaFai wrote:
> Hello, mysql,
>
> 2 Mysql 4.0.12 windows version with INNODB replciate
> sucessfully,both in myisam and innodb table.
> According to mysql manual(PDF),there is only one master database in
> the same time,but with many slave server.
Right.
Hello, mysql,
2 Mysql 4.0.12 windows version with INNODB replciate sucessfully,both in
myisam and innodb table.
According to mysql manual(PDF),there is only one master database in the same
time,but with many slave server.
Master for query,and slave for update or insert op
- Original Message -
From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Thursday, January 23, 2003 12:31 PM
Subject: Re[2]: Limitations of InnoDB about REPLICATION
> Dobrý den,
> quinta-feira, 23 de
Dyego,
- Original Message -
From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, January 23, 2003 12:13 PM
Subject: Limitations of InnoDB about REPLICATION
> Hello guy !
>
> The limit
Hello guy !
The limitations about InnoDB on replication is present in >= 4.0.9 release
?
* THE LOAD TABLE FROM MASTER DOES NOT WORK ON INNODB TABLES
* THE TABLES ARE LOADED AUTOMATICALLY ON SET REPLICATION
is true this limitations on >= 4.0.9 ?
sql,query
--
On Mon, Jan 06, 2003 at 04:56:38PM +0100, Chambon wrote:
> Hello
>
> I am using Mysql and Innodb tables since one year
> with great success. Everything works fine.
>
> Now I try to set up a master/slave replication architecture.
>
> master slave
> pc Linux rh 6.2
Hello
I am using Mysql and Innodb tables since one year
with great success. Everything works fine.
Now I try to set up a master/slave replication architecture.
master slave
pc Linux rh 6.2 pc Linux rh 6.2
version 3.23.47 version 3.23.54
I have read
On Mon, Nov 04, 2002 at 02:04:35PM -0500, Ray Zimmerman wrote:
> I'm looking into options to improve performance of mysql in our app
> and have a question about replication. I need the following
> guarantee, which I believe is not possible with replication ...
>
> If a
I'm looking into options to improve performance of mysql in our app
and have a question about replication. I need the following
guarantee, which I believe is not possible with replication ...
If a client successfully updates the master, any subsequent read from
a slave must reflect that u
Norris,
Wednesday, August 21, 2002, 6:44:51 PM, you wrote:
N> I have just got into a situation in which I need to explore replication and
N> I know nothing about it. Can any one direct me to specific documentation on
N> this and maybe a simple tutorial for the "greener" of us?
Check the appropri
(filter bypass words - Mysql, sql, query)
Group,
I have just got into a situation in which I need to explore replication and
I know nothing about it. Can any one direct me to specific documentation on
this and maybe a simple tutorial for the "greener" of us?
Thanks.
--
HI, everyone,
I met a problem about setting up replication(master/slave) of mysql sever on unix
boxes.
Mysql servers are installed under "/usr/local/" on master and slave and they can be
run under "/usr/local/mysql/bin".
It seems to me that I have three choices where to put my configuration f
34 matches
Mail list logo
