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 ; [email protected] 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 <[email protected]> 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 ; [email protected] 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 <[email protected]> wrote: Walter, Don't know how I missed that but it exactly what I needed. Thanks, Carl ----- Original Message ----- From: "Walter Heck" <[email protected]> To: "Carl" <[email protected]> Cc: <[email protected]> Sent: Monday, May 24, 2010 5:49 AM Subject: Re: Master - master replication Hi Carl, On Mon, May 24, 2010 at 13:42, Carl <[email protected]> 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/[email protected] -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI Developer Telephone: +44 (0)7918 621621 Email: [email protected] -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI Developer Telephone: +44 (0)7918 621621 Email: [email protected]
