Re: [Maria-discuss] R: 'Converting' a myisam to multi-master
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 robe...@spadim.com.br ha scritto: Oggetto: Re: [Maria-discuss] R: 'Converting' a myisam to multi-master A: Federico Razzoli federico_...@yahoo.it Cc: Maria Discuss maria-discuss@lists.launchpad.net 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_...@yahoo.it: 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 robe...@spadim.com.br ha scritto: Oggetto: Re: [Maria-discuss] R: 'Converting' a myisam to multi-master A: Federico Razzoli federico_...@yahoo.it Cc: Maria Discuss maria-discuss@lists.launchpad.net 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_...@yahoo.it 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] 'Converting' a myisam to multi-master A: Maria Discuss maria-discuss@lists.launchpad.net 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net 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@lists.launchpad.net 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] 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_...@yahoo.it 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] 'Converting' a myisam to multi-master A: Maria Discuss maria-discuss@lists.launchpad.net 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] R: 'Converting' a myisam to multi-master
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 robe...@spadim.com.br ha scritto: Oggetto: Re: [Maria-discuss] R: 'Converting' a myisam to multi-master A: Federico Razzoli federico_...@yahoo.it Cc: Maria Discuss maria-discuss@lists.launchpad.net 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_...@yahoo.it 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] 'Converting' a myisam to multi-master A: Maria Discuss maria-discuss@lists.launchpad.net 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] R: 'Converting' a myisam to multi-master
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_...@yahoo.it: 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 robe...@spadim.com.br ha scritto: Oggetto: Re: [Maria-discuss] R: 'Converting' a myisam to multi-master A: Federico Razzoli federico_...@yahoo.it Cc: Maria Discuss maria-discuss@lists.launchpad.net 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_...@yahoo.it 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] 'Converting' a myisam to multi-master A: Maria Discuss maria-discuss@lists.launchpad.net 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net 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@lists.launchpad.net 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Re: [Maria-discuss] R: 'Converting' a myisam to multi-master
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. The assumption is that there are no conflicts in data between the different masters. Which is the case here, all standalone servers handle different schemas. in this case i don't know if i will have conflict... that's why a multi master (sync) should be used and not a async replication 2013/9/19 Roberto Spadim robe...@spadim.com.br: 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_...@yahoo.it: 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 robe...@spadim.com.br ha scritto: Oggetto: Re: [Maria-discuss] R: 'Converting' a myisam to multi-master A: Federico Razzoli federico_...@yahoo.it Cc: Maria Discuss maria-discuss@lists.launchpad.net 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_...@yahoo.it 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] 'Converting' a myisam to multi-master A: Maria Discuss maria-discuss@lists.launchpad.net 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp -- Roberto Spadim SPAEmpresarial -- Roberto Spadim SPAEmpresarial -- Roberto Spadim SPAEmpresarial ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp