I think setting up few more configuration variable in replication will secure the data in plain text transmission .
#--master-ssl #--master-ssl-ca #--master-ssl-capath #--master-ssl-cert #--master-ssl-cipher #--master-ssl-key http://dev.mysql.com/doc/refman/5.0/en/replication-options-slave.html http://dev.mysql.com/doc/refman/5.0/en/secure-create-certs.html Thanks, On Mon, May 24, 2010 at 6:45 PM, 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 > -- Best Regards, Prabhat Kumar MySQL DBA Datavail-India Mumbai Mobile : 91-9987681929 www.datavail.com My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat