maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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 <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



-- 
Roberto Spadim
SPAEmpresarial