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
