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
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
easier solution that i didn't know yet...
2013/9/19 Federico Razzoli <federico_raz@yahoo.it>:
The link explains how Percona replicated 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
It's easy to know if you have conflicts: if you replicate db1 from server1 and db2 from server2, there is no conflict. If you want to replicate db1 and db2 from server1, and db2 from server2, there are conflicts Federico -------------------------------------------- Ven 20/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: Venerdì 20 settembre 2013, 01:54 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>: problem the app there's a tables in a multimaster environment using XtraDB Cluster + MariaDB. The article also says that Galera supports but doesn't recommend MyISAM. 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