Optimization of the server (find backup, Nginx, PHP, MySql)
Intel(R) Core(TM) i7-8700 CPU @ 3.20GHz (12 cores), Operating memory 63795 MB
The ISP Manager 6
Site on Magento 1.9.4.5
After the restart of the OS (for this was CentOS 7 + MySQL 5) problems began in the work of the BD:
- Problems with indexing BD: either it is indexed for a very long time, or the site is "loading" at all ( error 503)
Lost connection to MySQL (Lost connection to MySQL)
The site works slowly than before the restart of the OS.
Maybe there are other mistakes.
Mistakes in performing Cron tasks:
- PDOException: SQLSTATE[08S01]: Communication link failure: 1053 Server shutdown in progress
- PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
What to do:
- Analyze logs, loads, remove narrow places and errors in the work of the BD server
- If necessary - to create PHP, Nginx
- Optional: transfer the server from MySQL 8.0.3 to MariaDb 10.6 (which is more optimized for Magento) - you need to decide whether it is really necessary
- Set up the storage backup on the Storage Box Hetzner
Client's review of cooperation with Mykhailo A.
Optimization of the server (find backup, Nginx, PHP, MySql)Mikhail is clearly a professional in his business. I recommend cooperation.
Freelancer's review of cooperation with Oleksandr Kniazik
Optimization of the server (find backup, Nginx, PHP, MySql)Everything went well! Clean TZ, timely payment and pleasant communication.
Thank you for the project! I recommend it!)
Current freelance projects in the category DevOps
Rescue + backup for Hetzner dedicated serverWe have a dedicated server on Hetzner with a website on Docker (+ Laravel framework) Contact with the developers has been lost Need to: - restore and change server access (probably SSH) - recommend a storage location and set up a full server backup with easy recovery, probably… DevOps, System & Network Administration ∙ 2 days 1 hour back ∙ 24 proposals |
Transfer email from Google Workspace to another platform
111 USD
I'm looking for a specialist who can help transfer corporate email from Google Workspace to another email platform. We want to switch because Google Workspace is currently quite expensive for us. We have about 30 users. We haven't finalized which platform to switch to yet, so we… DevOps, System & Network Administration ∙ 4 days 9 hours back ∙ 18 proposals |
Integration of Google Analytics into CRM via n8nGood day, I need help connecting Google Analytics and CRM through n8n. All settings on the CRM side are done. Now we just need to set up the analytics through n8n to transmit sales events. DevOps, System & Network Administration ∙ 10 days 11 hours back ∙ 21 proposals |