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 or
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 th
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 19
On Tue, Oct 19, 2010 at 1:03 PM, Carl 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 you know
> where
,
Carl
- Original Message -
From: "Johan De Meersman"
To: "short cutter"
Cc: "Brent Clark" ;
Sent: Tuesday, October 19, 2010 5:10 AM
Subject: Re: Master Master Replication ... do a fail over and a week agos
data is revealed.
On Tue, Oct 19, 2010 a
On Tue, Oct 19, 2010 at 9:48 AM, short cutter wrote:
> 2010/10/18 Brent Clark :
> > 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
2010/10/18 Brent Clark :
> 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
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 and
mg>zoom down to walters question(s)
> Hi Carl,
>
> On Mon, May 24, 2010 at 13:42, Carl wrote:
>
> 1. Is the data visible during transmission?
>
> Not sure what you mean there?
mg>he means if someone was sharking the line would they be able to see
Financial Information / HealthInformation th
Can anyone see how the data could be
acquired by a bad person? (I understand both servers have to be secured.)
Thanks,
Carl
- Original Message -
From: "Patrick Sherrill"
To: "Carl"
Cc:
Sent: Monday, May 24, 2010 8:09 AM
Subject: Re: Master - master replication
exposed in the same way.
>
> Thanks,
>
> 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
>
, 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 and
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 qu
; 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 wrote:
>
>
ev.mysql.com/doc/refman/5.0/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 wrote:
>
>> Interesting. How is the best way to protect the information while u
; 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 wrote:
Interesting. How is the best way to protect the
http://dev.mysql.com/doc/refman/5.0/en/secure-create-certs.html
Thanks,
On Mon, May 24, 2010 at 6:45 PM, Carl wrote:
> Interesting. How is the best way to protect the information while using
> master - master replication on remote sites? (The data contains the
> information of
You need to check pci compliance rules before you go replicating and
transmitting credit card data.
On 24 May 2010 14:15, Carl wrote:
> Interesting. How is the best way to protect the information while using
> master - master replication on remote sites? (The data contains the
> in
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
> From: c...@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,
&
gt; Thanks,
>
> Carl
> - Original Message - From: "Walter Heck"
> To: "Carl"
> Cc:
> Sent: Monday, May 24, 2010 5:49 AM
> Subject: Re: Master - master replication
>
>
>
> Hi Carl,
>
> On Mon, May 24, 2010 at 13:42, Carl wrote:
>
>&g
Walter,
Don't know how I missed that but it exactly what I needed.
Thanks,
Carl
- Original Message -
From: "Walter Heck"
To: "Carl"
Cc:
Sent: Monday, May 24, 2010 5:49 AM
Subject: Re: Master - master replication
Hi Carl,
On Mon, May 24, 2010 at 13:42
es email peuvent facilement
être sujets à la 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 a
Hi Carl,
On Mon, May 24, 2010 at 13:42, Carl 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: http://dev.mysql.com/doc/refm
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
th 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,
&g
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.
>
>
> --
>
&
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 Replicatio
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
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 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
>
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 on
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
prise-groupware solution. I 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
---
From: Frank Becker [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 que
On Tue, Jan 13, 2009 at 12:32 PM, Frank Becker
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
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
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 forget
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
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 n
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
'./devnagios01-
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
'./devnagios01-re
tname and it is not working now.
> > My new ip 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
&
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=wahoo1-relay-bin
log-bin=
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
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
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 try
osedly replicated,
but neither matches 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
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
