maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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