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 <daisleyj...@googlemail.com> > *To:* Carl <c...@etrak-plus.com> > *Cc:* Walter Heck <wal...@openquery.com> ; 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