Re: Master - master replication

[Carl]

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