Re: Master - master replication

[Prabhat Kumar]

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 <carl@stripped> 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@stripped
>  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 <carl@stripped> wrote:
>
>    Walter,
>
>    Don't know how I missed that but it exactly what I needed.
>
>    Thanks,
>
>    Carl
>    ----- Original Message ----- From: "Walter Heck" <walter@stripped>
>    To: "Carl" <carl@stripped>
>    Cc: <mysql@stripped>
>    Sent: Monday, May 24, 2010 5:49 AM
>    Subject: Re: Master - master replication
>
>
>
>    Hi Carl,
>
>    On Mon, May 24, 2010 at 13:42, Carl <carl@stripped> 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=1
>
>
>
>
>
>  --
>  John Daisley
>
>  Certified MySQL 5 Database Administrator
>  Certified MySQL 5 Developer
>  Cognos BI Developer
>
>  Telephone: [phone]
>  Email: john.daisley@stripped
>



-- 
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile     : [phone]
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat