Hi Vivek We are using the --single-transaction flag and --skip-lock-tables flag Could there be something other than mysqldumps causing the cs mgmt. server to be losing the connection to the database ?
BR Gary Hello, You can use --single-transaction Option while taking the dump or you can schedule to take dump from a slave server if you have. Regards, Vivek Kumar On Tue, Dec 20, 2022, 7:25 PM Gary Dixon <[email protected]> wrote: > Hi all > > > > CS v4.15.2 > > Hypervisor = KVM > > > > We have started to experience an issue on a frequent basis where the > CS mgmt. service is losing the connection to the database and believe > it is being caused by mysqldumps locking the tables. > > Looking at the db.properties file there are tuning parameters : > > # CloudStack database tuning parameters > > db.cloud.maxActive=250 > > db.cloud.maxIdle=30 > > db.cloud.maxWait=10000 > > db.cloud.validationQuery=SELECT 1 > > db.cloud.testOnBorrow=true > > db.cloud.testWhileIdle=true > > db.cloud.timeBetweenEvictionRunsMillis=40000 > > db.cloud.minEvictableIdleTimeMillis=240000 > > db.cloud.poolPreparedStatements=false > > > db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true&sessionV > ariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ER > ROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'&serverTimezone=UTC > > > > would changing the ‘maxwait’ value to a higher value stop the mgmt. > service losing the db connection whilst dumps are taken ? > > BR > > > > Gary > > > > > Gary Dixon > Senior Technical Consultant > T: +44 161 537 4990 > E: *v* <+44%207989717661>ms@quadris‑support.com > W: > https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.q > uadris.co.uk%2F&data=05%7C01%7CGary.Dixon%40quadris.co.uk%7Cc508487920 > c948fa441908dae2949e38%7Cf1d6abf3d3b44894ae16db0fb93a96a2%7C0%7C0%7C63 > 8071425209591727%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV > 2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=SAj0nkOY53 > 6UUokgQPzXfdGH6Jp2pJ1hxlqA5hAJiwY%3D&reserved=0 > The information contained in this e-mail from Quadris may be > confidential and privileged for the private use of the named > recipient. The contents of this e-mail may not necessarily represent the > official views of Quadris. > If you have received this information in error you must not copy, > distribute or take any action or reliance on its contents. Please > destroy any hard copies and delete this message. > -- This message is intended only for the use of the individual or entity to which it is addressed and may contain confidential and/or privileged information. If you are not the intended recipient, please delete the original message and any copy of it from your computer system. You are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited unless proper authorization has been obtained for such action. If you have received this communication in error, please notify the sender immediately. Although IndiQus attempts to sweep e-mail and attachments for viruses, it does not guarantee that both are virus-free and accepts no liability for any damage sustained as a result of viruses. Gary Dixon Senior Technical Consultant T: +44 161 537 4990 E: [email protected] W: www.quadris.co.uk The information contained in this e-mail from Quadris may be confidential and privileged for the private use of the named recipient. The contents of this e-mail may not necessarily represent the official views of Quadris. If you have received this information in error you must not copy, distribute or take any action or reliance on its contents. Please destroy any hard copies and delete this message.
