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 application (vbulletin), I see that
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.
>
Why using M-M repl
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:
>
>
sing
>> 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
>>
; 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
children, credit cards and bank accounts.)
>
> Thanks,
>
> Carl
> - Original Message -
> From: John Daisley
> To: Carl
> Cc: Walter Heck ; mysql@lists.mysql.com
> Sent: Monday, May 24, 2010 6:47 AM
> Subject: Re: Master - master replication
>
>
>
formation of children, credit cards and bank accounts.)
>
> Thanks,
>
> Carl
>
> - Original Message -
> *From:* John Daisley
> *To:* Carl
> *Cc:* Walter Heck ; mysql@lists.mysql.com
> *Sent:* Monday, May 24, 2010 6:47 AM
> *Subject:* Re: Master - master rep
Heck ; mysql@lists.mysql.com
Sent: Monday, May 24, 2010 6:47 AM
Subject: Re: Master - master replication
also consider that it is much more likely that remote slaves will start
falling behind particularly if you throw encryption into the equation.
Regards
John
On 24 May 2010 13:24
> 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
Hello Carl
MySQL advertises an encryption package using the ENCRYPT('hello') but to date i
have'nt find any information on where to download and configure the encrpytion
package
did you look at http://www.critotech.com
?
Martin Gainty
__
Verzicht u
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
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
>> manual
>> for master-slave, but
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 th
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-
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
I think the message they were trying to convey in the answer is
"two-way replication will result in data corruption and therefore
should not be used." Consider a table with an AUTO_INCREMENT id
field. If two different inserts are done simultaneously, one on each
master, both will get the same id
30 matches
Mail list logo