# How To Manage MyIsam and Innodb?

**URL:** <https://forums.percona.com/t/how-to-manage-myisam-and-innodb/3610>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [July 11, 2014, 5:37am UTC](https://forums.percona.com/t/how-to-manage-myisam-and-innodb/3610 "2014-07-11T05:37:00Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![saidassoumani](https://avatars.discourse-cdn.com/v4/letter/s/b19c9b/32.png) [@saidassoumani](https://forums.percona.com/u/saidassoumani)\
**Post date:** [July 11, 2014, 5:37am UTC](https://forums.percona.com/t/how-to-manage-myisam-and-innodb/3610/1 "2014-07-11T05:37:00Z")

</div>

Hi ,  
with percona , what solutions i have to manage a lot of Databases with MyIsam en InnoDb Table ??

I have think : use Percona for innodb HA (/var/lib/mysql/innodb) and use DRBD to replicate MyIsam files ( /var/lib/mysql/myisam)…

---

<div class="post-metadata">

**Author:** ![rennschnecke](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rennschnecke](https://forums.percona.com/u/rennschnecke)\
**Post date:** [July 12, 2014, 12:45pm UTC](https://forums.percona.com/t/how-to-manage-myisam-and-innodb/3610/2 "2014-07-12T12:45:13Z")

</div>

If the question is how to replicate myisam(???):  
wsrep\_replicate\_myisam = 1

---

<div class="post-metadata">

**Author:** ![saidassoumani](https://avatars.discourse-cdn.com/v4/letter/s/b19c9b/32.png) [@saidassoumani](https://forums.percona.com/u/saidassoumani)\
**Post date:** [July 15, 2014, 11:22pm UTC](https://forums.percona.com/t/how-to-manage-myisam-and-innodb/3610/3 "2014-07-15T23:22:45Z")

</div>

even if , I set wsrep\_replicate\_myisam = 1  
some tables not replicate ( Large table \> 53 000 000 rows)

---

<div class="post-metadata">

**Author:** ![rennschnecke](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rennschnecke](https://forums.percona.com/u/rennschnecke)\
**Post date:** [July 16, 2014, 4:27pm UTC](https://forums.percona.com/t/how-to-manage-myisam-and-innodb/3610/4 "2014-07-16T16:27:30Z")

</div>

> [@saidassoumani;18837](#):
>
> even if , I set wsrep\_replicate\_myisam = 1  
> some tables not replicate ( Large table \> 53 000 000 rows)

Something in the logfile(s)?  
Is this always the same amount of rows which will be replicated?  
If so what is the exact number?  
 → different: logfile? my.cnf?  
 → always same: a number like 2^n or 2^n-1 ???

To test I would insert rows of different type or number of columns (or both) in two different tables.  
Then insert 60.000.000 rows and watch what happened on the client.

---

<div class="post-metadata">

**Author:** ![saidassoumani](https://avatars.discourse-cdn.com/v4/letter/s/b19c9b/32.png) [@saidassoumani](https://forums.percona.com/u/saidassoumani)\
**Post date:** [July 16, 2014, 11:04pm UTC](https://forums.percona.com/t/how-to-manage-myisam-and-innodb/3610/5 "2014-07-16T23:04:37Z")

</div>

Nothing in the logfiles…  
The cluster replicate the structure of the myisam table (ddl) but in node2 and node3 there is 0 row .  
It’s weird because I have another myisam table iwth 20,000 rows and replication is done.  
Here is my my.cnf file (this is a “the same” thing on other nodes):

[mysqld]

datadir=/var/lib/mysql  
user=mysql

# Path to Galera library

wsrep\_provider=/usr/lib/libgalera\_smm.so

# Cluster connection URL contains the IPs of node#1, node#2 and node#3

wsrep\_cluster\_address=gcomm://192.168.1.95,192.168.1.96,192.168.1.97

# In order for Galera to work correctly binlog format should be ROW

binlog\_format=ROW

# MyISAM storage engine has only experimental support

default\_storage\_engine=InnoDB

# This changes how InnoDB autoincrement locks are managed and is a requirement for Galera

innodb\_autoinc\_lock\_mode=2

#cache size of innodb log  
innodb\_log\_file\_size=67108864

#Disable control of autoincrement by percona  
#wsrep\_auto\_increment\_control=off

#Enable MyIsam  
wsrep\_replicate\_myisam=1

# Node #1 address

wsrep\_node\_address=192.168.1.95

# SST method

wsrep\_sst\_method=xtrabackup-v2

# Cluster name

wsrep\_cluster\_name=\*\*\*\*\_cluster

# Authentication for SST method

wsrep\_sst\_auth=“sstuser:\*\*\*\*\*\*”

---

<div class="post-metadata">

**Author:** ![rennschnecke](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rennschnecke](https://forums.percona.com/u/rennschnecke)\
**Post date:** [July 23, 2014, 6:55am UTC](https://forums.percona.com/t/how-to-manage-myisam-and-innodb/3610/6 "2014-07-23T06:55:49Z")

</div>

try:

log-slave-updates