maria-discuss team mailing list archive

[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