Required a database administrator (MySQL)
System for internal use for the processing of sites and recording data on them.The problem
Over the past six years, the database has doubled its volume.The speed of work leaves you want the best and does not allow you to work quickly.The programming qualifications for the optimization of the database work are already lacking.More professional advice from the database administrator (MySQL SUBD) is needed to solve current problems.List of tasks
1 .It is necessary to analyze the database and write:
a) a list of reasons that have a negative impact on the performance of the database.(b) Possible solutions to optimize the performance of the database and the degree of their positive impact on the speed of operation.(c) the orientative price and the time limits for the implementation of the decisions.d) Write short the basic theses where a database should be developed, taking into account the increase in its volume in the future.If necessary, we will ask you to make a more detailed plan.Attention !It is important to make a list of what the database administrator can do.Request optimization or Redis add-on we are also ready to consider, but only if there are no other methods of optimization.Brief description of the database
Subject to: MySQL
Number of tables: 77
Volume: 36.9 GB
Total number of lines: ~151 621 574
In general, we are interested in long-term cooperation.
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 ∙ 1 day 23 hours back ∙ 22 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 7 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 9 hours back ∙ 21 proposals |
Kyiv