John,
I am familiar with the PCI regs and am trying to accomodate them. Our process
requires that the card information is available on both servers so it is more a
question of how than if.
Thanks,
Carl
----- Original Message -----
From: John Daisley
To: Carl
Cc: Walter Heck ; 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 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 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, Carl <c...@etrak-plus.com> wrote:
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,
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:
http://dev.mysql.com/doc/refman/5.1/en/replication-solutions-ssl.html
cheers,
Walter Heck
Engineer @ Open Query (http://openquery.com)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk
--
John Daisley
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer
Telephone: +44 (0)7918 621621
Email: john.dais...@butterflysystems.co.uk
--
John Daisley
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer
Telephone: +44 (0)7918 621621
Email: john.dais...@butterflysystems.co.uk
