Hi All,
Not sure if anyone has implemented a Proxy for a Master Master Replication
of MySQL, is it doable ? If yes, how, which tools can be used ?
[image: Inline image 1]
Generally Master A will be Master when Proxy hits Master A and Master B
will be slave
When Master A is not able to reach
On Wed, Oct 20, 2010 at 1:37 AM, Walter Heck - OlinData.com
li...@olindata.com wrote:
To Clarify this a bit: You can only reliably do writes to one server.
Also not *entirely* true: nothing prevents you from using the two masters
for distinct databases - or even tables - and just having them
2010/10/18 Brent Clark brentgclarkl...@gmail.com:
Hiya
I run MySQL Master - Master Replication. Ive had an interesting situation
whereby I failed over using heartbeat but whats is interesting is that via
the application (vbulletin), I see that the forums was showing that a weeks
ago data
On Tue, Oct 19, 2010 at 9:48 AM, short cutter shortcut...@126.com wrote:
2010/10/18 Brent Clark brentgclarkl...@gmail.com:
Hiya
I run MySQL Master - Master Replication. Ive had an interesting situation
whereby I failed over using heartbeat but whats is interesting is that
via
,
Carl
- Original Message -
From: Johan De Meersman vegiv...@tuxera.be
To: short cutter shortcut...@126.com
Cc: Brent Clark brentgclarkl...@gmail.com; mysql@lists.mysql.com
Sent: Tuesday, October 19, 2010 5:10 AM
Subject: Re: Master Master Replication ... do a fail over and a week agos
data
On Tue, Oct 19, 2010 at 1:03 PM, Carl c...@etrak-plus.com wrote:
Johan,
You state that master - master is not reliable in dual active environments.
I am in the process of setting up just such an environment (moderate active
on the primary server, lighter activity on the other server.) Do
To Clarify this a bit: You can only reliably do writes to one server.
Your reads can go to both servers with no problems.
For reads that need to read data that was just written though, you
need to read from the 'active' master, as you can not rely on
replication to be instantaneous.
On Tue, Oct
Hiya
I run MySQL Master - Master Replication. Ive had an interesting
situation whereby I failed over using heartbeat but whats is
interesting is that via the application (vbulletin), I see that the
forums was showing that a weeks ago data.
I had to re fail over to the original server
I am setting up master - master replication between two sites that are in
separate facilities that are hundreds of miles apart.
The operating systems are Slackware 13, the MySql version is 5.1.41 (will
probably upgrade to latest.)
I have two questions:
1. Is the data visible during
Hi Carl,
On Mon, May 24, 2010 at 13:42, Carl c...@etrak-plus.com wrote:
1. Is the data visible during transmission?
Not sure what you mean there?
2. Is there a way to encrypt the data during transmission?
MySQL supports SSL encryption of replication. Here's a good starting
point:
manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
From: c...@etrak-plus.com
To: mysql@lists.mysql.com
Subject: Master - master replication
Date: Mon, 24 May 2010 06:42:06 -0500
I am setting up master - master replication between two sites
Walter,
Don't know how I missed that but it exactly what I needed.
Thanks,
Carl
- Original Message -
From: Walter Heck wal...@openquery.com
To: Carl c...@etrak-plus.com
Cc: mysql@lists.mysql.com
Sent: Monday, May 24, 2010 5:49 AM
Subject: Re: Master - master replication
Hi Carl
,
Carl
- Original Message - From: Walter Heck wal...@openquery.com
To: Carl c...@etrak-plus.com
Cc: mysql@lists.mysql.com
Sent: Monday, May 24, 2010 5:49 AM
Subject: Re: Master - master replication
Hi Carl,
On Mon, May 24, 2010 at 13:42, Carl c...@etrak-plus.com wrote:
1
...@etrak-plus.com
To: wal...@openquery.com
CC: mysql@lists.mysql.com
Subject: Re: Master - master replication
Date: Mon, 24 May 2010 07:24:35 -0500
Walter,
Don't know how I missed that but it exactly what I needed.
Thanks,
Carl
- Original Message -
From: Walter Heck wal
Interesting. How is the best way to protect the information while using master
- master replication on remote sites? (The data contains the information of
children, credit cards and bank accounts.)
Thanks,
Carl
- Original Message -
From: John Daisley
To: Carl
Cc: Walter
You need to check pci compliance rules before you go replicating and
transmitting credit card data.
On 24 May 2010 14:15, Carl c...@etrak-plus.com wrote:
Interesting. How is the best way to protect the information while using
master - master replication on remote sites? (The data contains
http://dev.mysql.com/doc/refman/5.0/en/secure-create-certs.html
Thanks,
On Mon, May 24, 2010 at 6:45 PM, Carl c...@etrak-plus.com wrote:
Interesting. How is the best way to protect the information while using
master - master replication on remote sites? (The data contains the
information
; mysql@lists.mysql.com
Sent: Monday, May 24, 2010 7:20 AM
Subject: Re: Master - master replication
You need to check pci compliance rules before you go replicating and
transmitting credit card data.
On 24 May 2010 14:15, Carl c...@etrak-plus.com wrote:
Interesting. How is the best way
/en/replication-options-slave.html
http://dev.mysql.com/doc/refman/5.0/en/secure-create-certs.html
Thanks,
On Mon, May 24, 2010 at 6:45 PM, Carl c...@etrak-plus.com wrote:
Interesting. How is the best way to protect the information while using
master - master replication on remote sites
: Monday, May 24, 2010 7:20 AM
Subject: Re: Master - master replication
You need to check pci compliance rules before you go replicating and
transmitting credit card data.
On 24 May 2010 14:15, Carl c...@etrak-plus.com wrote:
Interesting. How is the best way to protect the information
On 24/05/2010 13:40, Walter Heck wrote:
Carl,
if you want to be secure, do not use the internet to transfer your
data. SSH, VPN and SSL can not give you the kind of security a private
line can give you. That is a tad expensive though :)
That's true, but again that's not really answering the
, May 24, 2010 7:39 AM
Subject: Re: Master - master replication
ssl is not enough for pci dss compliance. If you store credit card
information and are not pci compliant you can be heavily fined and have your
ability to process/accept credit card payments permanently removed.
The storage
,
Carl
- Original Message -
From: John Daisley
To: Prabhat Kumar
Cc: Carl ; Walter Heck ; mysql@lists.mysql.com
Sent: Monday, May 24, 2010 7:39 AM
Subject: Re: Master - master replication
ssl is not enough for pci dss compliance. If you store credit card
: Master - master replication
I beleive the issue is more storage related than anything else.
Multiple servers exponentially increased risk of compromise.
Carl wrote:
This is both interesting and puzzling.
The only way credit card information can be aquired is through SSL
communication
mgzoom down to walters question(s)
Hi Carl,
On Mon, May 24, 2010 at 13:42, Carl c...@etrak-plus.com wrote:
1. Is the data visible during transmission?
Not sure what you mean there?
mghe means if someone was sharking the line would they be able to see
Financial Information /
want to implement MySQL Master Master Replication. But I have read in the
various documentation that in mysql replication it is possible that I loose
data.
Is it also applicable to MySQL Master Master Replication.
Thanks in advance.
--
Regards,
Manasi Save
-- Thanks
Suresh
.
Thanks
Suresh Kuna
MySQL DBA
On Wed, Jan 13, 2010 at 8:20 PM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi All,
I want to implement MySQL Master Master Replication. But I have read in
the
various documentation that in mysql replication it is possible that I
loose
Hi All,I want to implement MySQL Master Master
Replication. But I have read in the various documentation that in mysql
replication it is possible that I loose data.Is it also applicable to
MySQL Master Master Replication.
Thanks in advance.--Regards,
Manasi Save
Hi Manasi,
As both are implemented by replication, there is a possibility for loosing
data.
Thanks
Suresh Kuna
MySQL DBA
On Wed, Jan 13, 2010 at 8:20 PM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi All,
I want to implement MySQL Master Master Replication. But I have read
I have configured 2 MySQL server to do master-master replication. Below
is my config:
Node A
server-id = 1
log_bin = mysql-bin
expire_logs_days= 10
max_binlog_size = 100M
binlog_do_db= clustertest
binlog_do_db= gateway
Hi Craig and others,
On Fri, Mar 27, 2009 at 4:16 PM, Craig Dunn li...@codenation.net wrote:
blue.trapez...@gmail.com wrote:
Hi
I have 2 servers and I am trying to set up (for testing purposes) a
master-master replication environment. I read the instructions in the
manual
for master
Hi
I have 2 servers and I am trying to set up (for testing purposes) a
master-master replication environment. I read the instructions in the manual
for master-slave, but am not able to find any information on how to set up a
master-master system. Can someone on this list point me to any
blue.trapez...@gmail.com wrote:
Hi
I have 2 servers and I am trying to set up (for testing purposes) a
master-master replication environment. I read the instructions in the manual
for master-slave, but am not able to find any information on how to set up a
master-master system. Can someone
Hello together,
I have successfully set up a master-master-replication between two
servers. My question is: It is possible to set up such a replication
between three (or more) servers? Like this
Master3 --- Master1 --- Master2
|
Master4
Thanks for your feedback
Best
On Tue, Jan 13, 2009 at 12:32 PM, Frank Becker
computersac...@beckerwelt.de wrote:
Hello together,
I have successfully set up a master-master-replication between two
servers. My question is: It is possible to set up such a replication
between three (or more) servers? Like this
Master3
[mailto:computersac...@beckerwelt.de]
Sent: Tuesday, January 13, 2009 12:33 PM
To: mysql@lists.mysql.com
Subject: Question about Master-Master replication: Is this possible?
Hello together,
I have successfully set up a master-master-replication between two
servers. My question is: It is possible
started with eGroupware
on a single server. If I or my wife is out of office (e.g. by train) we
have no internet access with our notebook. It's too expensive. Ok.
I then set up a virtual server with vmware and set up a
master-master-replication between server (master1) and virtual server
(master2
I don't think you need to flush your bin logs.
CHANGE MASTER TO MASTER HOST = 'hostname';
Look at this for more info at
http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html
There is a lot more you can add to the statement.
thanks but this gave me a very similar error - I
Hi
I had master-master working fin in dev - i move them to prd now and so
change the hostnames, on starting i see this error
080522 11:53:40 mysqld started
080522 11:53:40 InnoDB: Started; log sequence number 0 213274351
080522 11:53:40 [ERROR] Failed to open the relay log
Hi
I had master-master working fin in dev - i move them to prd now and so
change the hostnames, on starting i see this error
080522 11:53:40 mysqld started
080522 11:53:40 InnoDB: Started; log sequence number 0 213274351
080522 11:53:40 [ERROR] Failed to open the relay log
On Thu, May 22, 2008 at 9:20 AM, Tom Brown [EMAIL PROTECTED] wrote:
Hi
I had master-master working fin in dev - i move them to prd now and so
change the hostnames, on starting i see this error
080522 11:53:40 mysqld started
080522 11:53:40 InnoDB: Started; log sequence number 0
On Thu, May 22, 2008 at 10:00 AM, Tom Brown [EMAIL PROTECTED] wrote:
I don't think you need to flush your bin logs.
CHANGE MASTER TO MASTER HOST = 'hostname';
Look at this for more info at
http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html
There is a lot more you can add to the
is 10.100.1.170 and my hostname is wahoo1. The other ip
address in my master/master replication is 10.100.1.171 and wahoo2
*This is what wahoo1 my.cnf looks like*:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
auto_increment_increment=2
auto_increment_offset=1
relay-log
. The other ip
address in my master/master replication is 10.100.1.171 and wahoo2
*This is what wahoo1 my.cnf looks like*:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
auto_increment_increment=2
auto_increment_offset=1
relay-log=wahoo1-relay-bin
log-bin=wahoo1-bin
master/master replication is 10.100.1.171 and wahoo2
*This is what wahoo1 my.cnf looks like*:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
auto_increment_increment=2
auto_increment_offset=1
relay-log=wahoo1-relay-bin
log-bin=wahoo1-bin
At 12:01 PM 11/27/2007, you wrote:
Who has experience with setting up master-master replication with MySQL
between two Windows-servers. I would like to try setting it up and am
looking for experiences, tips an possibly a hands-on manual.
Arno Bouwman.
Arno,
The search engine is your
hi,
we have 3 inet servers running mysql:
mysql1.mydom.tld
mysql2.mydom.tld
mysql3.mydom.tld
and we also got an dynamicdns entry mysql.mydom.tld.
normaly mysql.mydom.tld directs to mysql1.mydom.tld - but if mysql2
detects mysql1 is down it will use a dyndns script to become
mysql.mydom.tld.
what
the other.
It may be technically possible to set up MySQL to make it appear to
have a master-master replication configuration, but such a
configuration would not be logically valid.
--- Emi Nelson [EMAIL PROTECTED] wrote:
Hello,
I have set up a master/slave replication environment using
Well, not logically valid in the general sense (in that naive
master-master replication can be self-destructive) but can be extremely
useful when utilized knowing all the limitations and potential pitfalls.
On Sun, 2003-08-31 at 10:01, Douglas Granzow wrote:
I think the message they were trying
Hello,
I have set up a master/slave replication environment using
4.0.13 but would like to know if there is a way to set up
master/master replication between two databases, both able
to be inserted/updated/deleted, tables created, etc., with
the changes on both databases propagated to each other
50 matches
Mail list logo
