maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

I think there is a misunderstanding here: XtraDB Cluster may have a confusing name, but it is not XtraDB, it is a cluster solution. The article explains it can work with MyISAM.

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