Re: Master - master replication

[Carl]

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@stripped 
  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 <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




  -- 
  John Daisley

  Certified MySQL 5 Database Administrator
  Certified MySQL 5 Developer
  Cognos BI Developer

  Telephone: [phone]
  Email: john.daisley@stripped