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 :)
Walter On Mon, May 24, 2010 at 15:33, Carl <c...@etrak-plus.com> wrote: > 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org