Currently on 3.13.5 (3.11.1 DB). When trying to update DB via MySQL script it will run for hours without ending. Even i tried to run single sql commmands the ones which affecting tables users and images wont finish. This result in site crash because after some time sql server stops responding - timeout. The server is powerful enough, many cores raid 10 etc... How to run the update tool on large database without downtime? thanx
-
Welcome to the Chevereto User Community!
Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.
Please keep in mind:
- This community is user-driven. Always be polite and respectful to others.
- Support development by purchasing a Chevereto license, which also gives you priority support.
- Go further by joining the Community Subscription for even faster response times and to help sustain this space
-
Chevereto Support CLST
Support response
- Extra Support is delivered within 24-hours.
- Pro Subscription ticket response time is within 7 days on Software Support, Bug Tracking and RFC.
- Bug Tracking requires an active Chevereto self-hosted subscription.
- Community Help is user driven. Be polite with other users and do not expect official support.
Support checklist
- Got a Something went wrong message? Read this guide and provide the actual error. Do not skip this.
- Confirm that the server meets the System Requirements
- Check for any available Hotfix - your issue could be already reported/fixed
- Read documentation - It will be required to Debug and understand Errors for a faster support response
DB update issue
- Thread starter AshleyUK
- Start date
3.13 (May 2019) added a dashboard option to dump the update query to be able to manually update the database. Unfortunately, 3.11 (Aug 2018) doesn't have such feature.
You will have to manually issue the update by opening /install/?dump and then running these queries directly in your server.
You will have to manually issue the update by opening /install/?dump and then running these queries directly in your server.
That was not my question, i asked how to perform your queries on large tables without downtime. I already found a solution, for everyone who has large tables i DO NOT recommend to run sql queries provided by chevereto system, better use pt-online-schema-change from percona toolkit. This way u can update system without any downtime.
When you issue these queries using a front end (PHP), you are limited to the time execution limits of this front end, which are usually 30-60 seconds. That's why on large installs the recommendation is to manually issue the statements (one by one, not all all the same time). I forgot to mention that this should be made directly in the SQL console, and with the system maintenance turned on. In fact, the system should be all offline if you want to be 100% sure that all peers are disconnected and the database is not wired.
I haven't used Percona and is nice to know that it can be used for this kind of situations (large data-set). I've to mention it because I remember that you host UltraIMG and other users reading this ticket may misunderstand the need for the tool you mention.
I've updated the documentation to remark the pitfalls of carrying a large update: https://chevereto.com/docs/update-guide#manual-db
Cheers.
- Status