Budget: 5000 UAH Deadline: 30 days
Hello!
Trying to prepare a server for 10+ websites solely through tuning Nginx and MySQL configurations is treating symptoms instead of addressing the architectural problem. As my current work on resolving a similar conflict between OpenCart and a heavy SAP integration module shows, the main "resource killer" when scaling is not server limits, but monolithic synchronous processing of massive data exchanges.
Isolating heavy processes instead of "juggling" loads: On 10 websites, peak loads (imports, feeds) will inevitably overlap. Instead of simply spreading tasks over time in the scheduler, it is necessary to move these processes to background asynchronous queues; otherwise, they will start "eating" each other, completely blocking the CPU.
Optimizing writes, not just reads: Adding indexes to the database will speed up page delivery on the frontend, but will proportionally slow down import operations. It is critically important to analyze transactions so that bulk updates of balances on one site do not create global database locks (Table Locks) that "crash" neighboring stores.
Architectural, not infrastructural caching: Redis will not save overall performance if the underlying CMS logic clears the entire catalog cache when changing the status or price of a single product during synchronization. Point caching needs to be configured to isolate the processes of 10 different projects from each other at the application level, not just at the server level.
Are you considering the possibility of intervening directly in the logic of the backend and OkayCMS modules if the audit confirms that the problem lies in the CMS architecture's inability to process data streams in parallel for 10+ projects, and that this cannot be resolved with just FASTPANEL configurations?
Sincerely, Arseniy.
Budget: 5000 UAH Deadline: 1 day
Organization and coordination of the DevOps team
Design and support of CI/CD processes
Management of Infrastructure as Code (Terraform, Ansible)
Cross-functional collaboration between development and operations teams
Monitoring, logging, and security assurance
Mentoring and team development
Key experience:
System Engineer at Rubygarage & Devico (2022-2024):
Development of server infrastructure (nginx, MongoDB, Node.js)
Management of cloud services (DigitalOcean, AWS)
Automation of processes and CI/CD
Configuration of network infrastructure (Mikrotik, RADIUS, VPN)
Technical skills:
Cloud platforms: AWS (4/5), DigitalOcean
Containerization: Docker (4/5), Kubernetes (3/5)
CI/CD: Jenkins (5/5), GitLab (5/5), GitHub (5/5)
Infrastructure as Code: Terraform (3/5), Ansible (3/5)
Networks: DNS (5/5), VPN (5/5), networking equipment
Databases: MongoDB (4/5), ClickHouse (3/5)
OS: Linux (5/5)
Monitoring: configuration of resource monitoring systems
Budget: 5000 UAH Deadline: 1 day
Hello.
We have experience optimizing the stack of Ubuntu, Nginx, PHP-FPM, and MySQL for e-commerce, including projects with multiple sites on one dedicated server. We can access via SSH, conduct a performance audit, identify real bottlenecks through logs and metrics, and then carefully implement optimizations with backups and documentation so that you understand what has been changed and how to roll back.
In terms of time, it is approximately as follows: audit 4-8 hours, implementation 8-20 hours depending on what we find in slow queries, imports, cron jobs, and searches. We work hourly or can fix stages after the audit.
We are ready to start in the near future.
Budget: 20000 UAH Deadline: 7 days
Good day
My name is Dmytro, from King Kong Web
We have practical experience in optimizing dedicated servers on Ubuntu for real workloads, as well as working with MySQL/MariaDB, slow query log, indexes, and web stack configuration. We have worked with e-commerce projects where there were issues with imports, feeds, cron jobs, image resizing, and peak loads.
We are ready to start with a full technical audit: we will collect metrics, analyze CPU/RAM/I/O, check Nginx/Apache configs, PHP-FPM, OPcache, MySQL, review logs and the slow query log. Based on the results, we will prepare a brief report with issues, priorities, and a change plan.
Next, we will perform optimization: we will configure the web server and PHP-FPM for the actual server resources, optimize the database (indexes, heavy queries, locking), check OkayCMS caching, and if necessary, connect Redis or other acceleration mechanisms. We will also separately address cron jobs, imports, and feeds to eliminate peak loads and 504 errors.
We work carefully: before making changes, we create backups, document all edits, and provide a brief instruction on configs and monitoring. We are ready to work via SSH with prior agreement on the change plan.
We can discuss the payment format — hourly or fixed after the audit.
We are ready to answer additional questions and start with the technical analysis.
Proposals are currently absent
Current freelance projects in the category Databases & SQL
-
Not specified
Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service
Gaming Apps 18 proposals 3 August
-
Not specified
Development of the CRM module "Requests" in custom 1C (bus center)
Client Management & CRM 19 proposals 31 July
-
22 USD
Support for Samotur and its servers
17 proposals 27 July
-
179 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities
Client Management & CRM 42 proposals 27 July
-
Not specified
Client registration and visit confirmation system (MVP)
Web Programming 162 proposals 10 July