← Back to team overview

maria-discuss team mailing list archive

Re: R: 'Converting' a myisam to multi-master

 

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

Follow ups

References