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 <robe...@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 <robe...@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_...@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 <robe...@spadim.com.br> ha scritto: >>> >>> Oggetto: Re: [Maria-discuss] R: 'Converting' a myisam to multi-master >>> A: "Federico Razzoli" <federico_...@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_...@yahoo.it> >>> >>> >>> 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 <robe...@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 _______________________________________________ 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