You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Nux! <nu...@li.nux.ro> on 2013/02/10 20:03:30 UTC
are all tables InnoDB?
Hello,
Are all the tables in the cloudstack databases of the type InnoDB? I'd
like to know so I can decide on a replication strategy (either Gallera
or regular mysql replication).
Thanks,
Lucian
--
Sent from the Delta quadrant using Borg technology!
Nux!
www.nux.ro
RE: are all tables InnoDB?
Posted by Tariq Iqbal <ta...@shapeblue.com>.
Hi Alex,
Absolutely, in fact this is planned for a ShapeBlue blog article and we'll donate it to the wiki when it's done - as always happy to help the CloudStack community!
I'll keep you posted.
Kind Regards,
Tariq Iqbal
Senior Consultant
S: +44(0)20 3603 0540 | M: +44(0)790 9911600
tariq.iqbal@shapeblue.com | www.shapeblue.com | Twitter:@shapeBlue
ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS
________________________________________
From: Alex Huang [Alex.Huang@citrix.com]
Sent: 11 February 2013 18:48
To: Tariq Iqbal; Jason Davis
Cc: Nux!; cloudstack-dev@incubator.apache.org; Chip Childers
Subject: RE: are all tables InnoDB?
Hi Tariq,
Can you help document this on the wiki? Maybe a page under one of these links?
https://cwiki.apache.org/confluence/display/CLOUDSTACK/CloudStack+Example+Configurations
https://cwiki.apache.org/confluence/display/CLOUDSTACK/Apache+CloudStack+Best+Practices+For+Cloud+Design
I think a lot of people would be interested.
Thanks.
--Alex
> -----Original Message-----
> From: Tariq Iqbal [mailto:tariq.iqbal@shapeblue.com]
> Sent: Monday, February 11, 2013 4:49 AM
> To: Jason Davis
> Cc: Nux!; cloudstack-dev@incubator.apache.org; Chip Childers
> Subject: RE: are all tables InnoDB?
>
> Hi Jason,
>
>
>
> We have used HAproxy and Citrix Netscalers for fronting the clusters.
>
>
> Kind Regards,
>
> Tariq Iqbal
> Senior Consultant
>
> [Description: Mail Logo Bottom Align]
>
> S: +44(0)20 3603 0540<tel:+442036030540> | M: +44(0)790
> 9911600<tel:+447909911600>
>
> tariq.iqbal@shapeblue.com<ma...@shapeblue.com> |
> www.shapeblue.com<http://www.shapeblue.com/> |
> Twitter:@shapeBlue<https://twitter.com/#!/shapeblue>
>
> ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS
>
>
> ________________________________
> From: Jason Davis [scr512@gmail.com]
> Sent: 11 February 2013 02:52
> To: Tariq Iqbal
> Cc: Nux!; cloudstack-dev@incubator.apache.org; Chip Childers
> Subject: RE: are all tables InnoDB?
>
>
> Nice. Are you using MySQL proxy or HAProxy for fronting the cluster? On a
> non CS related implementation of Galera we front our cluster with our A10
> HLBs, works pretty well.
>
> On Feb 10, 2013 5:16 PM, "Tariq Iqbal"
> <ta...@shapeblue.com>> wrote:
> Hi Nux,
>
> The tables in the CS database are of the type InnoDB.
>
> We have successfully implemented both Galera clustering and Mysql
> replication.
>
> Kind Regards,
>
> Tariq Iqbal
> Senior Consultant
>
>
>
> S: +44(0)20 3603 0540<tel:%2B44%280%2920%203603%200540> | M:
> +44(0)790 9911600<tel:%2B44%280%29790%209911600>
>
> tariq.iqbal@shapeblue.com<ma...@shapeblue.com> |
> www.shapeblue.com<http://www.shapeblue.com> | Twitter:@shapeBlue
>
> ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS
>
>
> ________________________________________
> From: Chip Childers
> [chip.childers@sungard.com<ma...@sungard.com>]
> Sent: 10 February 2013 19:23
> To: Nux!
> Cc: cloudstack-dev@incubator.apache.org<mailto:cloudstack-
> dev@incubator.apache.org>
> Subject: Re: are all tables InnoDB?
>
> On Sun, Feb 10, 2013 at 07:03:30PM +0000, Nux! wrote:
> > Hello,
> >
> > Are all the tables in the cloudstack databases of the type InnoDB?
> > I'd like to know so I can decide on a replication strategy (either
> > Gallera or regular mysql replication).
> >
> > Thanks,
> > Lucian
>
> They should be. All of the tables in setup/db/create_schema.sql specify
> the InnoDB storage engine.
>
> -chip
> ShapeBlue provides a range of strategic and technical consulting and
> implementation services to help IT Service Providers and Enterprises to build
> a true IaaS compute cloud. ShapeBlue's expertise, combined with CloudStack
> technology, allows IT Service Providers and Enterprises to deliver true, utility
> based, IaaS to the customer or end-user.
>
> ________________________________
>
> This email and any attachments to it may be confidential and are intended
> solely for the use of the individual to whom it is addressed. Any views or
> opinions expressed are solely those of the author and do not necessarily
> represent those of Shape Blue Ltd. If you are not the intended recipient of
> this email, you must neither take any action based upon its contents, nor
> copy or show it to anyone. Please contact the sender if you believe you have
> received this email in error. Shape Blue Ltd is a company incorporated in
> England & Wales.
> ShapeBlue provides a range of strategic and technical consulting and
> implementation services to help IT Service Providers and Enterprises to build
> a true IaaS compute cloud. ShapeBlue's expertise, combined with CloudStack
> technology, allows IT Service Providers and Enterprises to deliver true, utility
> based, IaaS to the customer or end-user.
>
> ________________________________
>
> This email and any attachments to it may be confidential and are intended
> solely for the use of the individual to whom it is addressed. Any views or
> opinions expressed are solely those of the author and do not necessarily
> represent those of Shape Blue Ltd. If you are not the intended recipient of
> this email, you must neither take any action based upon its contents, nor
> copy or show it to anyone. Please contact the sender if you believe you have
> received this email in error. Shape Blue Ltd is a company incorporated in
> England & Wales.
ShapeBlue provides a range of strategic and technical consulting and implementation services to help IT Service Providers and Enterprises to build a true IaaS compute cloud. ShapeBlue’s expertise, combined with CloudStack technology, allows IT Service Providers and Enterprises to deliver true, utility based, IaaS to the customer or end-user.
________________________________
This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Shape Blue Ltd. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error. Shape Blue Ltd is a company incorporated in England & Wales.
RE: are all tables InnoDB?
Posted by Alex Huang <Al...@citrix.com>.
Hi Tariq,
Can you help document this on the wiki? Maybe a page under one of these links?
https://cwiki.apache.org/confluence/display/CLOUDSTACK/CloudStack+Example+Configurations
https://cwiki.apache.org/confluence/display/CLOUDSTACK/Apache+CloudStack+Best+Practices+For+Cloud+Design
I think a lot of people would be interested.
Thanks.
--Alex
> -----Original Message-----
> From: Tariq Iqbal [mailto:tariq.iqbal@shapeblue.com]
> Sent: Monday, February 11, 2013 4:49 AM
> To: Jason Davis
> Cc: Nux!; cloudstack-dev@incubator.apache.org; Chip Childers
> Subject: RE: are all tables InnoDB?
>
> Hi Jason,
>
>
>
> We have used HAproxy and Citrix Netscalers for fronting the clusters.
>
>
> Kind Regards,
>
> Tariq Iqbal
> Senior Consultant
>
> [Description: Mail Logo Bottom Align]
>
> S: +44(0)20 3603 0540<tel:+442036030540> | M: +44(0)790
> 9911600<tel:+447909911600>
>
> tariq.iqbal@shapeblue.com<ma...@shapeblue.com> |
> www.shapeblue.com<http://www.shapeblue.com/> |
> Twitter:@shapeBlue<https://twitter.com/#!/shapeblue>
>
> ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS
>
>
> ________________________________
> From: Jason Davis [scr512@gmail.com]
> Sent: 11 February 2013 02:52
> To: Tariq Iqbal
> Cc: Nux!; cloudstack-dev@incubator.apache.org; Chip Childers
> Subject: RE: are all tables InnoDB?
>
>
> Nice. Are you using MySQL proxy or HAProxy for fronting the cluster? On a
> non CS related implementation of Galera we front our cluster with our A10
> HLBs, works pretty well.
>
> On Feb 10, 2013 5:16 PM, "Tariq Iqbal"
> <ta...@shapeblue.com>> wrote:
> Hi Nux,
>
> The tables in the CS database are of the type InnoDB.
>
> We have successfully implemented both Galera clustering and Mysql
> replication.
>
> Kind Regards,
>
> Tariq Iqbal
> Senior Consultant
>
>
>
> S: +44(0)20 3603 0540<tel:%2B44%280%2920%203603%200540> | M:
> +44(0)790 9911600<tel:%2B44%280%29790%209911600>
>
> tariq.iqbal@shapeblue.com<ma...@shapeblue.com> |
> www.shapeblue.com<http://www.shapeblue.com> | Twitter:@shapeBlue
>
> ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS
>
>
> ________________________________________
> From: Chip Childers
> [chip.childers@sungard.com<ma...@sungard.com>]
> Sent: 10 February 2013 19:23
> To: Nux!
> Cc: cloudstack-dev@incubator.apache.org<mailto:cloudstack-
> dev@incubator.apache.org>
> Subject: Re: are all tables InnoDB?
>
> On Sun, Feb 10, 2013 at 07:03:30PM +0000, Nux! wrote:
> > Hello,
> >
> > Are all the tables in the cloudstack databases of the type InnoDB?
> > I'd like to know so I can decide on a replication strategy (either
> > Gallera or regular mysql replication).
> >
> > Thanks,
> > Lucian
>
> They should be. All of the tables in setup/db/create_schema.sql specify
> the InnoDB storage engine.
>
> -chip
> ShapeBlue provides a range of strategic and technical consulting and
> implementation services to help IT Service Providers and Enterprises to build
> a true IaaS compute cloud. ShapeBlue's expertise, combined with CloudStack
> technology, allows IT Service Providers and Enterprises to deliver true, utility
> based, IaaS to the customer or end-user.
>
> ________________________________
>
> This email and any attachments to it may be confidential and are intended
> solely for the use of the individual to whom it is addressed. Any views or
> opinions expressed are solely those of the author and do not necessarily
> represent those of Shape Blue Ltd. If you are not the intended recipient of
> this email, you must neither take any action based upon its contents, nor
> copy or show it to anyone. Please contact the sender if you believe you have
> received this email in error. Shape Blue Ltd is a company incorporated in
> England & Wales.
> ShapeBlue provides a range of strategic and technical consulting and
> implementation services to help IT Service Providers and Enterprises to build
> a true IaaS compute cloud. ShapeBlue's expertise, combined with CloudStack
> technology, allows IT Service Providers and Enterprises to deliver true, utility
> based, IaaS to the customer or end-user.
>
> ________________________________
>
> This email and any attachments to it may be confidential and are intended
> solely for the use of the individual to whom it is addressed. Any views or
> opinions expressed are solely those of the author and do not necessarily
> represent those of Shape Blue Ltd. If you are not the intended recipient of
> this email, you must neither take any action based upon its contents, nor
> copy or show it to anyone. Please contact the sender if you believe you have
> received this email in error. Shape Blue Ltd is a company incorporated in
> England & Wales.
RE: are all tables InnoDB?
Posted by Tariq Iqbal <ta...@shapeblue.com>.
Hi Jason,
We have used HAproxy and Citrix Netscalers for fronting the clusters.
Kind Regards,
Tariq Iqbal
Senior Consultant
[Description: Mail Logo Bottom Align]
S: +44(0)20 3603 0540<tel:+442036030540> | M: +44(0)790 9911600<tel:+447909911600>
tariq.iqbal@shapeblue.com<ma...@shapeblue.com> | www.shapeblue.com<http://www.shapeblue.com/> | Twitter:@shapeBlue<https://twitter.com/#!/shapeblue>
ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS
________________________________
From: Jason Davis [scr512@gmail.com]
Sent: 11 February 2013 02:52
To: Tariq Iqbal
Cc: Nux!; cloudstack-dev@incubator.apache.org; Chip Childers
Subject: RE: are all tables InnoDB?
Nice. Are you using MySQL proxy or HAProxy for fronting the cluster? On a non CS related implementation of Galera we front our cluster with our A10 HLBs, works pretty well.
On Feb 10, 2013 5:16 PM, "Tariq Iqbal" <ta...@shapeblue.com>> wrote:
Hi Nux,
The tables in the CS database are of the type InnoDB.
We have successfully implemented both Galera clustering and Mysql replication.
Kind Regards,
Tariq Iqbal
Senior Consultant
S: +44(0)20 3603 0540<tel:%2B44%280%2920%203603%200540> | M: +44(0)790 9911600<tel:%2B44%280%29790%209911600>
tariq.iqbal@shapeblue.com<ma...@shapeblue.com> | www.shapeblue.com<http://www.shapeblue.com> | Twitter:@shapeBlue
ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS
________________________________________
From: Chip Childers [chip.childers@sungard.com<ma...@sungard.com>]
Sent: 10 February 2013 19:23
To: Nux!
Cc: cloudstack-dev@incubator.apache.org<ma...@incubator.apache.org>
Subject: Re: are all tables InnoDB?
On Sun, Feb 10, 2013 at 07:03:30PM +0000, Nux! wrote:
> Hello,
>
> Are all the tables in the cloudstack databases of the type InnoDB?
> I'd like to know so I can decide on a replication strategy (either
> Gallera or regular mysql replication).
>
> Thanks,
> Lucian
They should be. All of the tables in setup/db/create_schema.sql specify
the InnoDB storage engine.
-chip
ShapeBlue provides a range of strategic and technical consulting and implementation services to help IT Service Providers and Enterprises to build a true IaaS compute cloud. ShapeBlue’s expertise, combined with CloudStack technology, allows IT Service Providers and Enterprises to deliver true, utility based, IaaS to the customer or end-user.
________________________________
This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Shape Blue Ltd. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error. Shape Blue Ltd is a company incorporated in England & Wales.
ShapeBlue provides a range of strategic and technical consulting and implementation services to help IT Service Providers and Enterprises to build a true IaaS compute cloud. ShapeBlue’s expertise, combined with CloudStack technology, allows IT Service Providers and Enterprises to deliver true, utility based, IaaS to the customer or end-user.
________________________________
This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Shape Blue Ltd. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error. Shape Blue Ltd is a company incorporated in England & Wales.
RE: are all tables InnoDB?
Posted by Jason Davis <sc...@gmail.com>.
Nice. Are you using MySQL proxy or HAProxy for fronting the cluster? On a
non CS related implementation of Galera we front our cluster with our A10
HLBs, works pretty well.
On Feb 10, 2013 5:16 PM, "Tariq Iqbal" <ta...@shapeblue.com> wrote:
> Hi Nux,
>
> The tables in the CS database are of the type InnoDB.
>
> We have successfully implemented both Galera clustering and Mysql
> replication.
>
> Kind Regards,
>
> Tariq Iqbal
> Senior Consultant
>
>
>
> S: +44(0)20 3603 0540 | M: +44(0)790 9911600
>
> tariq.iqbal@shapeblue.com | www.shapeblue.com | Twitter:@shapeBlue
>
> ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS
>
>
> ________________________________________
> From: Chip Childers [chip.childers@sungard.com]
> Sent: 10 February 2013 19:23
> To: Nux!
> Cc: cloudstack-dev@incubator.apache.org
> Subject: Re: are all tables InnoDB?
>
> On Sun, Feb 10, 2013 at 07:03:30PM +0000, Nux! wrote:
> > Hello,
> >
> > Are all the tables in the cloudstack databases of the type InnoDB?
> > I'd like to know so I can decide on a replication strategy (either
> > Gallera or regular mysql replication).
> >
> > Thanks,
> > Lucian
>
> They should be. All of the tables in setup/db/create_schema.sql specify
> the InnoDB storage engine.
>
> -chip
> ShapeBlue provides a range of strategic and technical consulting and
> implementation services to help IT Service Providers and Enterprises to
> build a true IaaS compute cloud. ShapeBlue’s expertise, combined with
> CloudStack technology, allows IT Service Providers and Enterprises to
> deliver true, utility based, IaaS to the customer or end-user.
>
> ________________________________
>
> This email and any attachments to it may be confidential and are intended
> solely for the use of the individual to whom it is addressed. Any views or
> opinions expressed are solely those of the author and do not necessarily
> represent those of Shape Blue Ltd. If you are not the intended recipient of
> this email, you must neither take any action based upon its contents, nor
> copy or show it to anyone. Please contact the sender if you believe you
> have received this email in error. Shape Blue Ltd is a company incorporated
> in England & Wales.
>
RE: are all tables InnoDB?
Posted by Tariq Iqbal <ta...@shapeblue.com>.
Hi Nux,
The tables in the CS database are of the type InnoDB.
We have successfully implemented both Galera clustering and Mysql replication.
Kind Regards,
Tariq Iqbal
Senior Consultant
S: +44(0)20 3603 0540 | M: +44(0)790 9911600
tariq.iqbal@shapeblue.com | www.shapeblue.com | Twitter:@shapeBlue
ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS
________________________________________
From: Chip Childers [chip.childers@sungard.com]
Sent: 10 February 2013 19:23
To: Nux!
Cc: cloudstack-dev@incubator.apache.org
Subject: Re: are all tables InnoDB?
On Sun, Feb 10, 2013 at 07:03:30PM +0000, Nux! wrote:
> Hello,
>
> Are all the tables in the cloudstack databases of the type InnoDB?
> I'd like to know so I can decide on a replication strategy (either
> Gallera or regular mysql replication).
>
> Thanks,
> Lucian
They should be. All of the tables in setup/db/create_schema.sql specify
the InnoDB storage engine.
-chip
ShapeBlue provides a range of strategic and technical consulting and implementation services to help IT Service Providers and Enterprises to build a true IaaS compute cloud. ShapeBlue’s expertise, combined with CloudStack technology, allows IT Service Providers and Enterprises to deliver true, utility based, IaaS to the customer or end-user.
________________________________
This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Shape Blue Ltd. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error. Shape Blue Ltd is a company incorporated in England & Wales.
Re: are all tables InnoDB?
Posted by Chip Childers <ch...@sungard.com>.
On Sun, Feb 10, 2013 at 07:03:30PM +0000, Nux! wrote:
> Hello,
>
> Are all the tables in the cloudstack databases of the type InnoDB?
> I'd like to know so I can decide on a replication strategy (either
> Gallera or regular mysql replication).
>
> Thanks,
> Lucian
They should be. All of the tables in setup/db/create_schema.sql specify
the InnoDB storage engine.
-chip