Hi Federico... wsrep_replicate_myisam=ON i will test galera very soon =) but today i'm using aria :/ maybe i will have problems?! 2013/9/19 Roberto Spadim <roberto@spadim.com.br>:
sorry, i forgot one point important...
MariaDB’s multi-source-replication doesn’t have any conflict resolution. The assumption is that there are no conflicts in data between the different masters. Which is the case here, all standalone servers handle different schemas.
in this case i don't know if i will have conflict... that's why a multi master (sync) should be used and not a async replication
2013/9/19 Roberto Spadim <roberto@spadim.com.br>:
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
-- Roberto Spadim SPAEmpresarial
-- Roberto Spadim SPAEmpresarial