maria-discuss team mailing list archive

[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