# migrating to Percona Cluster 5.5.24

**URL:** <https://forums.percona.com/t/migrating-to-percona-cluster-5-5-24/2451>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [July 18, 2012, 1:57am UTC](https://forums.percona.com/t/migrating-to-percona-cluster-5-5-24/2451 "2012-07-18T01:57:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lexand](https://avatars.discourse-cdn.com/v4/letter/l/c6cbf5/32.png) [@lexand](https://forums.percona.com/u/lexand)\
**Post date:** [July 18, 2012, 1:57am UTC](https://forums.percona.com/t/migrating-to-percona-cluster-5-5-24/2451/1 "2012-07-18T01:57:36Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ayurchen](https://avatars.discourse-cdn.com/v4/letter/a/35a633/32.png) [@ayurchen](https://forums.percona.com/u/ayurchen)\
**Post date:** [July 19, 2012, 1:34am UTC](https://forums.percona.com/t/migrating-to-percona-cluster-5-5-24/2451/2 "2012-07-19T01:34:28Z")

</div>

[URL][http://www.codership.com/wiki/doku.php?id=myisam\_to\_galera[/URL]](http://www.codership.com/wiki/doku.php?id=myisam_to_galera%5B/URL%5D)

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.

---

<div class="post-metadata">

**Author:** ![DmitryK](https://avatars.discourse-cdn.com/v4/letter/d/e47c2d/32.png) [@DmitryK](https://forums.percona.com/u/DmitryK)\
**Post date:** [July 25, 2012, 9:56am UTC](https://forums.percona.com/t/migrating-to-percona-cluster-5-5-24/2451/3 "2012-07-25T09:56:20Z")

</div>

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 ☹ \*/