However, i already reached the max by default (100) which is not pretty enormous.
And i've seen in the manuals downloaded from cloudstack.org that the mysql server should be configured with a max connections depending of differents elements such as nodes, vms, networks (i don't remember which elemnt exactly, but sure that there is a dependency of the configuration of mysql according to the size of the deployment. So i need to cover the disaster scenarios in order to be sure to apply the good disaster recovery procedures. Also i need to to be sure not to loss datas acording to differents scenarios. The mysql server being the brain of the cloud you build, it must absolutely keeping fully stable. Here are the reasons why i need to know if the code protect (transactions, exception managing loss of connection or crash or querie out of the mysql query cache) againt mysql failures. Si if there is still a doubt, so okay no problem, i will deploy a redundant solution and will consolidate my installation with per example a very big cluster (lot of ram with an expensive configuration) under xcp covering the crash. Regards, Benoit. 2013/2/14 Nik Martin <nik.mar...@openfra.me> > I'm pretty sure the amount of connections to the DB is very low, even for a > large scale CS deployment. > > Nik Martin > > > > On Thu, Feb 14, 2013 at 11:44 AM, benoit lair <kurushi4...@gmail.com> > wrote: > > > Per example, if i reach the max connections, does it will compromise the > db > > and so cs mgmt server ? > > > > 2013/2/14 benoit lair <kurushi4...@gmail.com> > > > > > Okay guys, > > > > > > > > > MariaDB would be an intersting alternative, but concerning the failures > > > managements ? Cs code does protect the db integrity against mysql's > > (oracle > > > or mariadb one) failures ? Does cs manages transaction so anyway mysql > > > crashes, i can go sleep quietly, cs won't have a corrupted database (a > > > missing record, or a insert not terminated belong 2 tables, so there > > will > > > missing a record so it will generating bugs (unrecoverable i mean) of > the > > > platform. > > > > > > > > > Regards, Benoit > > > > > > > > > 2013/2/14 Alexey Zilber <alexeyzil...@gmail.com> > > > > > >> David, > > >> > > >> I have CS 3 running with MariaDB 5.2. I'll have to test with CS 4 and > > the > > >> latest MariaDB though. A lot of the Oracle enterprise features are in > > the > > >> latest version. Without the Oracle pricetag. Personally I'd rather > > >> support Monty then Ellison. :) > > >> > > >> With CS 3, my management server is below minimum specs and still does > a > > >> decent job. It's subjective though. > > >> > > >> -Alex > > >> On Feb 14, 2013 11:10 PM, "David Nalley" <da...@gnsa.us> wrote: > > >> > > >> > On Thu, Feb 14, 2013 at 10:07 AM, Alexey Zilber < > > alexeyzil...@gmail.com > > >> > > > >> > wrote: > > >> > > CS should really switch to and recommend MariaDB instead of > straight > > >> > mysql. > > >> > > > > >> > > You will find your hardware goes much farther with it. > > >> > > > > >> > > -Alex > > >> > > > >> > While I am not personally a mysql fan, I'd love to hear your > > >> > experiences with MariaDB and CloudStack. > > >> > > > >> > --David > > >> > > > >> > > > > > > > > >
