maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #01036
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