[Maria-discuss] 'Converting' a myisam to multi-master

2013-09-19 Thread Roberto Spadim
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

[Maria-discuss] R: 'Converting' a myisam to multi-master

2013-09-19 Thread Federico Razzoli
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 robe...@spadim.com.br ha scritto: Oggetto: [Maria-discuss]

Re: [Maria-discuss] R: 'Converting' a myisam to multi-master

2013-09-19 Thread Roberto Spadim
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

Re: [Maria-discuss] Galera cluster

2013-09-19 Thread Sergei Golubchik
Hi, Roberto! On Sep 19, Roberto Spadim wrote: Hi guys, the galera cluster code is inside default mariadb-10.0.4 code? or there's a different branch for galera cluster? Different branch. There is mariadb-5.5-galera tree. It was merged into 10.0, but as far as I know, the merge is not quite

[Maria-discuss] Galera cluster

2013-09-19 Thread Roberto Spadim
Hi guys, the galera cluster code is inside default mariadb-10.0.4 code? or there's a different branch for galera cluster? -- Roberto Spadim ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net

Re: [Maria-discuss] Galera cluster

2013-09-19 Thread Roberto Spadim
hummm nice, after the merge... will 10.0 have galera code? or still a different branch? 2013/9/19 Sergei Golubchik s...@mariadb.org Hi, Roberto! On Sep 19, Roberto Spadim wrote: Hi guys, the galera cluster code is inside default mariadb-10.0.4 code? or there's a different branch for

Re: [Maria-discuss] R: 'Converting' a myisam to multi-master

2013-09-19 Thread Federico Razzoli
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

Re: [Maria-discuss] R: 'Converting' a myisam to multi-master

2013-09-19 Thread Roberto Spadim
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

Re: [Maria-discuss] R: 'Converting' a myisam to multi-master

2013-09-19 Thread Roberto Spadim
Hi Federico... wsrep_replicate_myisam=ON i will test galera very soon =) but today i'm using aria :/ maybe i will have problems?! 2013/9/19 Roberto Spadim robe...@spadim.com.br: sorry, i forgot one point important... MariaDB’s multi-source-replication doesn’t have any conflict resolution.