Re: Few tables in cloudstack schema use MyISAM engine
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" <terbol...@gmail.com> 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 < >abhinandan.prat...@shapeblue.com> 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 <koushik@accelerite.com> koushik@accelerite.com>> >> Date: Tuesday, 30 August 2016 at 5:25 PM >> To: Abhinandan Prateek <abhinandan.prat...@shapeblue.com> abhinandan.prat...@shapeblue.com>>, "dev@cloudstack.apache.org> dev@cloudstack.apache.org>" <dev@cloudstack.apache.org> dev@cloudstack.apache.org>> >> Cc: Rajani Karuturi <raj...@apache.org<mailto:raj...@apache.org>>, Raja >> Pullela <raja.pull...@accelerite.com<mailto:raja.pull...@accelerite.com>> >> 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 <abhinandan.prat...@shapeblue.com> abhinandan.prat...@shapeblue.com>> >> Date: Tuesday, 30 August 2016 at 4:23 PM >> To: "dev@cloudstack.apache.org<mailto:dev@cloudstack.apache.org>" < >> dev@cloudstack.apache.org<mailto:dev@cloudstack.apache.org>> >> Cc: Rajani Karuturi <raj...@apache.org<mailto:raj...@apache.org>>, Raja >> Pullela <raja.pull...@accelerite.com<mailto:raja.pull...@accelerite.com>>, >> Koushik Das <koushik@accelerite.com<mailto:koushik@accelerite.com >> >> >> 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 >> >> abhinandan.prat...@shapeblue.com<mailto:abhinandan.prat...@shapeblue.com> >> 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. >> >> abhinandan.prat...@shapeblue.com >> www.shapeblue.com >> 53 Chandos Place, Covent Garden, London WC2N 4HSUK >> @shapeblue >> >> >> >> abhinandan.prat...@shapeblue.com www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue
Re: Few tables in cloudstack schema use MyISAM engine
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 < abhinandan.prat...@shapeblue.com> 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 <koushik@accelerite.com koushik@accelerite.com>> > Date: Tuesday, 30 August 2016 at 5:25 PM > To: Abhinandan Prateek <abhinandan.prat...@shapeblue.com abhinandan.prat...@shapeblue.com>>, "dev@cloudstack.apache.org dev@cloudstack.apache.org>" <dev@cloudstack.apache.org dev@cloudstack.apache.org>> > Cc: Rajani Karuturi <raj...@apache.org<mailto:raj...@apache.org>>, Raja > Pullela <raja.pull...@accelerite.com<mailto:raja.pull...@accelerite.com>> > 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 <abhinandan.prat...@shapeblue.com abhinandan.prat...@shapeblue.com>> > Date: Tuesday, 30 August 2016 at 4:23 PM > To: "dev@cloudstack.apache.org<mailto:dev@cloudstack.apache.org>" < > dev@cloudstack.apache.org<mailto:dev@cloudstack.apache.org>> > Cc: Rajani Karuturi <raj...@apache.org<mailto:raj...@apache.org>>, Raja > Pullela <raja.pull...@accelerite.com<mailto:raja.pull...@accelerite.com>>, > Koushik Das <koushik@accelerite.com<mailto:koushik@accelerite.com > >> > 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 > > abhinandan.prat...@shapeblue.com<mailto:abhinandan.prat...@shapeblue.com> > 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. > > abhinandan.prat...@shapeblue.com > www.shapeblue.com > 53 Chandos Place, Covent Garden, London WC2N 4HSUK > @shapeblue > > > >
Re: Few tables in cloudstack schema use MyISAM engine
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 <koushik@accelerite.com<mailto:koushik@accelerite.com>> Date: Tuesday, 30 August 2016 at 5:25 PM To: Abhinandan Prateek <abhinandan.prat...@shapeblue.com<mailto:abhinandan.prat...@shapeblue.com>>, "dev@cloudstack.apache.org<mailto:dev@cloudstack.apache.org>" <dev@cloudstack.apache.org<mailto:dev@cloudstack.apache.org>> Cc: Rajani Karuturi <raj...@apache.org<mailto:raj...@apache.org>>, Raja Pullela <raja.pull...@accelerite.com<mailto:raja.pull...@accelerite.com>> 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 <abhinandan.prat...@shapeblue.com<mailto:abhinandan.prat...@shapeblue.com>> Date: Tuesday, 30 August 2016 at 4:23 PM To: "dev@cloudstack.apache.org<mailto:dev@cloudstack.apache.org>" <dev@cloudstack.apache.org<mailto:dev@cloudstack.apache.org>> Cc: Rajani Karuturi <raj...@apache.org<mailto:raj...@apache.org>>, Raja Pullela <raja.pull...@accelerite.com<mailto:raja.pull...@accelerite.com>>, Koushik Das <koushik@accelerite.com<mailto:koushik@accelerite.com>> 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 abhinandan.prat...@shapeblue.com<mailto:abhinandan.prat...@shapeblue.com> 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. abhinandan.prat...@shapeblue.com www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue
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 <abhinandan.prat...@shapeblue.com> Date: Tuesday, 30 August 2016 at 4:23 PM To: "dev@cloudstack.apache.org" <dev@cloudstack.apache.org> Cc: Rajani Karuturi <raj...@apache.org>, Raja Pullela <raja.pull...@accelerite.com>, Koushik Das <koushik....@accelerite.com> 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 abhinandan.prat...@shapeblue.com 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.
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 abhinandan.prat...@shapeblue.com www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue