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 <[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: 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 <[email protected]>: > 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 -- 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
