GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

migrating to Percona Cluster 5.5.24

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • migrating to Percona Cluster 5.5.24

    Hi

    at the moment we have alomost 50GB database, that works on Mysql 5.1.52 (MyISAM). We have one master and one slave (binlog_format=MIXED).

    Some times ago we have decided to migrate to the percona cluster, as we are tired of the instability and we are fed up with the complexity of the recovery of current solution.

    so my question is

    How we can easy migrate to percona cluster without downtime or with minimal downtime as much as possible?
    Can you share your thoughts or recipes?

    thanks in advance

    P.S.
    sorry my english

  • #2
    http://www.codership.com/wiki/doku.p...isam_to_galera

    Note that for best results you need to have primary keys on every table.

    Technically you can minimize downtime even further, by initializing the cluster from slave and then catching up from master (Galera cluster can work as MySQL slave), but that will require a bit of binlog position kungfu and STATEMENT binlog format.

    Comment


    • #3
      Quote:
      Galera cluster can work as MySQL slave
      Is there any docs/faqs how to set it up?

      Quote:
      require a bit of binlog position kungfu and STATEMENT binlog format
      In other words, Galera cluster won't understand MIXED/ROW?
      Any possible workaround?
      /* 'cause I can't get rid of unsafe updates */

      Comment


      • #4
        DmitryK wrote on Wed, 25 July 2012 18:26
        Quote:
        Galera cluster can work as MySQL slave
        Is there any docs/faqs how to set it up?
        Just set up a regular master-slave replication between your master and one of the Galera nodes. And set log_slave_updates=1.

        Quote:
        Quote:
        require a bit of binlog position kungfu and STATEMENT binlog format
        In other words, Galera cluster won't understand MIXED/ROW?
        Any possible workaround?
        /* 'cause I can't get rid of unsafe updates */
        Galera is format agnostic, but works best with ROW format. However you can't use ROW format to replicate from MyISAM to InnoDB. The problem is in your MyISAM master.

        Comment


        • #5
          Sorry for confusion, I thought you were talking in general.
          No, all my tables are InnoDB, so the question is - can I replicate from existing Master to Galera cluster with MIXED format set?
          Thanks!

          Comment


          • #6
            Ok, I was confused too, as the OP said:

            Quote:
            at the moment we have alomost 50GB database, that works on Mysql 5.1.52 (MyISAM)
            so that's what I was having in mind. Yes, theoretically you can use MIXED format, but it is not thoroughly tested. Also ask yourself why do you need Galera cluster as an asynchronous slave: you gain neither data safety nor performance.

            Comment

            Working...
            X