maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

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@xxxxxxxxxxxxx> ha scritto:

 Oggetto: Re: [Maria-discuss] R: 'Converting' a myisam to multi-master
 A: "Federico Razzoli" <federico_raz@xxxxxxxx>
 Cc: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 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@xxxxxxxxxxxxx>:
 > 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@xxxxxxxx>:
 >> 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@xxxxxxxxxxxxx>
 ha scritto:
 >>
 >>  Oggetto: Re: [Maria-discuss] R: 'Converting'
 a myisam to multi-master
 >>  A: "Federico Razzoli" <federico_raz@xxxxxxxx>
 >>  Cc: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 >>  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@xxxxxxxx>
 >>
 >>  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 <roberto@xxxxxxxxxxxxx>
 >>  ha scritto:
 >>
 >>
 >>
 >>   Oggetto: [Maria-discuss]
 'Converting' a myisam to
 >>  multi-master
 >>
 >>   A: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 >>
 >>   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@xxxxxxxxxxxxxxxxxxx
 >>
 >>   Unsubscribe : https://launchpad.net/~maria-discuss
 >>
 >>   More help   : https://help.launchpad.net/ListHelp
 >>
 >>
 >>
 >>
 >>
 >> 
 _______________________________________________
 >>
 >>  Mailing list: https://launchpad.net/~maria-discuss
 >>
 >>  Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
 >>
 >>  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@xxxxxxxxxxxxxxxxxxx
 >> Unsubscribe : https://launchpad.net/~maria-discuss
 >> More help   : https://help.launchpad.net/ListHelp
 >
 >
 >
 > --
 > Roberto Spadim
 > SPAEmpresarial
 
 
 
 -- 
 Roberto Spadim
 SPAEmpresarial