Thanks Erik for correcting. More precisely, this is in context of migration of mysql db to Galera cluster, where there is a limitation with Galera cluster that it supports only InnodDB for replication due to its transactional nature.
Regards, -abhi On 31/08/16, 12:44 PM, "Erik Weber" <[email protected]> wrote: >Just nit-picking, but MyISAM allows replication as well. > >I'm +1 to the change. > >-- >Erik > >On Wed, Aug 31, 2016 at 5:37 AM, Abhinandan Prateek < >[email protected]> wrote: > >> Thanks, Koushik. >> >> Have created a PR to make the engine type consistent for all tables. >> InnoDB allows for replication, that is all the more reason that we change >> the engine type of these few tables to InnoDB. >> >> Regards, >> -abhi >> >> PR: https://github.com/apache/cloudstack/pull/1667 >> >> >> From: Koushik Das <[email protected]<mailto: >> [email protected]>> >> Date: Tuesday, 30 August 2016 at 5:25 PM >> To: Abhinandan Prateek <[email protected]<mailto: >> [email protected]>>, "[email protected]<mailto: >> [email protected]>" <[email protected]<mailto: >> [email protected]>> >> Cc: Rajani Karuturi <[email protected]<mailto:[email protected]>>, Raja >> Pullela <[email protected]<mailto:[email protected]>> >> Subject: Re: Few tables in cloudstack schema use MyISAM engine >> >> I cannot think of any. Most probably in all cases the engine was not >> explicitly specified and the default got used. As per below default was >> myisam before mysql 5.5.5. >> https://dev.mysql.com/doc/refman/5.5/en/storage-engine-setting.html >> >> Thanks, >> Koushik >> From: Abhinandan Prateek <[email protected]<mailto: >> [email protected]>> >> Date: Tuesday, 30 August 2016 at 4:23 PM >> To: "[email protected]<mailto:[email protected]>" < >> [email protected]<mailto:[email protected]>> >> Cc: Rajani Karuturi <[email protected]<mailto:[email protected]>>, Raja >> Pullela <[email protected]<mailto:[email protected]>>, >> Koushik Das <[email protected]<mailto:[email protected] >> >> >> Subject: Few tables in cloudstack schema use MyISAM engine >> >> Hi, >> >> Was there any specific reason that some tables in cloudstack schema use >> MyISAM engine. >> I know of “ quota_account” that I created and put in the diff table type >> unknowingly. I assume such is the case with other such tables – >> load_balancer_cert_map, monitoring_services, nic_ip_alias, sslcerts. >> >> Filed a ticket here to get this fixed or reason for not fixing it captured. >> >> Regards, >> -abhi >> >> [email protected]<mailto:[email protected]> >> www.shapeblue.com >> @shapeblue >> >> >> >> >> DISCLAIMER ========== This e-mail may contain privileged and confidential >> information which is the property of Accelerite, a Persistent Systems >> business. It is intended only for the use of the individual or entity to >> which it is addressed. If you are not the intended recipient, you are not >> authorized to read, retain, copy, print, distribute or use this message. If >> you have received this communication in error, please notify the sender and >> delete all copies of this message. Accelerite, a Persistent Systems >> business does not accept any liability for virus infected mails. >> >> [email protected] >> www.shapeblue.com >> 53 Chandos Place, Covent Garden, London WC2N 4HSUK >> @shapeblue >> >> >> >> [email protected] www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue
