[Maria-developers] Galera and aria
Hi again guys! =) I have a doubt, i was using a diff -u galera-5.33a mariadb-5.33a | grep -i "myisam" and found some lines... well could we add the aria storage to 'work' like myisam with galera cluster? i don't know if it's the right way (changing "== MYISAM_ENGINE" to something like (== myisam_engine OR == maria_engine)) if yes... i could make this patch and send? should i create a mdev to this task (allow aria engine with galera cluster)? today it's not a trasational engine, but it's better than myisam with the crash safe feature that's all :) thanks guys -- Roberto Spadim
Hi, Yes, there is wsrep_replicate_myisam, this variable controls if /MyISAM/ will be replicated or not. /MyISAM/ replication is still experimental and that is one of the reasons why this variable is set to OFF by default. Aria could be used on Galera Cluster similarly as InnoDB if there is support for aborting any transactions and you should add support for update/delete. Note that changes you see for myisam might not be enough for Aria, there is also the wsrep library where the actual replication is done. R: Jan
Hi again guys! =) I have a doubt, i was using a diff -u galera-5.33a mariadb-5.33a | grep -i "myisam"
and found some lines... well could we add the aria storage to 'work' like myisam with galera cluster?
i don't know if it's the right way (changing "== MYISAM_ENGINE" to something like (== myisam_engine OR == maria_engine)) if yes... i could make this patch and send? should i create a mdev to this task (allow aria engine with galera cluster)? today it's not a trasational engine, but it's better than myisam with the crash safe feature
-- Jan Lindström Principal Engineer MariaDB | MaxScale | skype: jan_p_lindstrom www.skysql.com <http://www.skysql.com/> Twitter <http://twitter.com/skysql> Blog <http://www.skysql.com/blog/> Facebook <http://www.facebook.com/skysql> LinkedIn <http://www.linkedin.com/company/1214250> Google+ <https://plus.google.com/117544963211695643458/posts>
Hi Jan! This job is something more dificullt than just copy/paste the myisam "if"s ? i don't know how wsrep works, just trying to use aria as myisam with galera cluster 2013/10/1 Jan Lindström <jplindst@mariadb.org>
Hi,
Yes, there is wsrep_replicate_myisam, this variable controls if *MyISAM*will be replicated or not. *MyISAM* replication is still experimental and that is one of the reasons why this variable is set to OFF by default.
Aria could be used on Galera Cluster similarly as InnoDB if there is support for aborting any transactions and you should add support for update/delete.
Note that changes you see for myisam might not be enough for Aria, there is also the wsrep library where the actual replication is done.
R: Jan
Hi again guys! =) I have a doubt, i was using a diff -u galera-5.33a mariadb-5.33a | grep -i "myisam"
and found some lines... well could we add the aria storage to 'work' like myisam with galera cluster?
i don't know if it's the right way (changing "== MYISAM_ENGINE" to something like (== myisam_engine OR == maria_engine)) if yes... i could make this patch and send? should i create a mdev to this task (allow aria engine with galera cluster)? today it's not a trasational engine, but it's better than myisam with the crash safe feature
--
Jan Lindström Principal Engineer
MariaDB | MaxScale | skype: jan_p_lindstrom
www.skysql.com
[image: Twitter] <http://twitter.com/skysql> [image: Blog]<http://www.skysql.com/blog/> [image: Facebook] <http://www.facebook.com/skysql> [image: LinkedIn]<http://www.linkedin.com/company/1214250> [image: Google+] <https://plus.google.com/117544963211695643458/posts>
-- Roberto Spadim SPAEmpresarial
On 10/01/2013 06:57 AM, Roberto Spadim wrote:
Hi Jan! This job is something more dificullt than just copy/paste the myisam "if"s ? i don't know how wsrep works, just trying to use aria as myisam with galera cluster
Hi, I have not tried myself, thus I do not know, but I expect that it is more difficult than just copy/paste the myisam "if"s. It seems that my earlier email was not totally correct. I think the biggest problem is the fact that in the current development phase Aria tables created with TRANSACTIONAL=1 are crashsafe and atomic but not transactional because changes in Aria tables can't be rolled back with the ROLLBACK command. R: -- Jan Lindström Principal Engineer MariaDB | MaxScale | skype: jan_p_lindstrom www.skysql.com <http://www.skysql.com/> Twitter <http://twitter.com/skysql> Blog <http://www.skysql.com/blog/> Facebook <http://www.facebook.com/skysql> LinkedIn <http://www.linkedin.com/company/1214250> Google+ <https://plus.google.com/117544963211695643458/posts>
Yes, i think it works like a myisam, not? maybe the copy/paste could work? i didn't tried yet, maybe at weekend i will try and send a patch to everybody test and report errors if anyone know if just copy/paste don't work please report :) 2013/10/1 Jan Lindström <jplindst@mariadb.org>
On 10/01/2013 06:57 AM, Roberto Spadim wrote:
Hi Jan! This job is something more dificullt than just copy/paste the myisam "if"s ? i don't know how wsrep works, just trying to use aria as myisam with galera cluster
Hi, I have not tried myself, thus I do not know, but I expect that it is more difficult than just copy/paste the myisam "if"s. It seems that my earlier email was not totally correct. I think the biggest problem is the fact that in the current development phase Aria tables created with TRANSACTIONAL=1 are crashsafe and atomic but not transactional because changes in Aria tables can't be rolled back with the ROLLBACK command.
R:
--
Jan Lindström Principal Engineer
MariaDB | MaxScale | skype: jan_p_lindstrom
www.skysql.com
[image: Twitter] <http://twitter.com/skysql> [image: Blog]<http://www.skysql.com/blog/> [image: Facebook] <http://www.facebook.com/skysql> [image: LinkedIn]<http://www.linkedin.com/company/1214250> [image: Google+] <https://plus.google.com/117544963211695643458/posts>
-- Roberto Spadim SPAEmpresarial
participants (2)
-
Jan Lindström -
Roberto Spadim