Hi Federico! yes, but they don't recommend because the table lock level (not row level) and no transaction support in this case (app using myisam/aria today) it's not a problem the app works nice, but myisam/aria don't have a solution for multimaster yet :/ i used DRBD some time but it's a master-slave solution
using xtradb cluster, is a problem since index, row size, no begin/commit at app, and xtradb don't have good min/max/count optimizations :/ i'm considering reading the galera cluster and maybe add some support to aria/myisam, but i didn't start anything yet, maybe there's a easier solution that i didn't know yet... 2013/9/19 Federico Razzoli <[email protected]>: > The link explains how Percona replicated MyISAM tables in a multimaster > environment using XtraDB Cluster + MariaDB. The article also says that Galera > supports but doesn't recommend MyISAM. > I didn't try myself. > > Federico > > -------------------------------------------- > Gio 19/9/13, Roberto Spadim <[email protected]> ha scritto: > > Oggetto: Re: [Maria-discuss] R: 'Converting' a myisam to multi-master > A: "Federico Razzoli" <[email protected]> > Cc: "Maria Discuss" <[email protected]> > Data: Giovedì 19 settembre 2013, 20:44 > > Hi Federico!I was > considering a multi master (in same network), without > xtradb/innodb, since i think i will have problems with row > size and index, and maybe less performace with > MIN/MAX/COUNT(*) optimizations of myisam/aria > anyother solution? async isn't a solution here, i > was considering a sync solution (near to ndb/galera > cluster) > > 2013/9/19 Federico > Razzoli <[email protected]> > > > http://www.mysqlperformanceblog.com/2012/12/18/migrating-several-single-standalone-mysql-server-to-one-percona-xtradb-cluster-mariadb-to-the-rescue/ > > > > > Federico > > > > > > -------------------------------------------- > > Gio 19/9/13, Roberto Spadim <[email protected]> > ha scritto: > > > > Oggetto: [Maria-discuss] 'Converting' a myisam to > multi-master > > A: "Maria Discuss" <[email protected]> > > Data: Giovedì 19 settembre 2013, 19:24 > > > > Hi guys, there's one > > easy way to implement a multi-master cluster using > > myisam/aria ?i know that galera cluster use innodb > as > > backend, there's anything > similar to aria/myisam? > > scaledb? ndb? others? > > > > the main problem switching from aria/myisam to > > innodb is the MIN/MAX/COUNT(*) optimization and the rows > > sizes/index considerations > (https://mariadb.com/kb/en/converting-tables-from-myisam-to-innodb/) > > and since it's myisam/aria many apps don't use > begin > > transaction / commit (maybe this is a problem for > > cluster/multi master?) > > > > thanks guys :) > > > > -- > > Roberto Spadim > > > > > > -----Segue allegato----- > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~maria-discuss > > Post to : [email protected] > > Unsubscribe : https://launchpad.net/~maria-discuss > > More help : https://help.launchpad.net/ListHelp > > > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~maria-discuss > > Post to : [email protected] > > Unsubscribe : https://launchpad.net/~maria-discuss > > More help : https://help.launchpad.net/ListHelp > > > > > -- > Roberto Spadim > SPAEmpresarial > > > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp -- Roberto Spadim SPAEmpresarial _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
