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 <federico_raz@yahoo.it>:
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 <roberto@spadim.com.br> ha scritto:
Oggetto: Re: [Maria-discuss] R: 'Converting' a myisam to multi-master A: "Federico Razzoli" <federico_raz@yahoo.it> Cc: "Maria Discuss" <maria-discuss@lists.launchpad.net> 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 <federico_raz@yahoo.it>
http://www.mysqlperformanceblog.com/2012/12/18/migrating-several-single-stan...
Federico
--------------------------------------------
Gio 19/9/13, Roberto Spadim <roberto@spadim.com.br> ha scritto:
Oggetto: [Maria-discuss] 'Converting' a myisam to multi-master
A: "Maria Discuss" <maria-discuss@lists.launchpad.net>
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 : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
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 : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial