Magento Centos linux server - Install Percona and get sphinx search engine working

Job ID: 33933270

Budget: $30 – $250 AUD

Hi I have a Centos 7 server and need somebody to do the following

1) - Install Percona sql to replace current Mysql 8 (without breaking existing website)

2) - Get Sphinx search engine working again as this stopped after we upgraded mysql from 5.7 to 8.0

currently if we run "searchd" getting the following error

searchd: error while loading shared libraries: libmysqlclient.so.20: cannot open shared object file: No such file or directory

You must be very good with Linux and server optimisation

The server should be running fast but we find that the load often goes up even with hardly any traffic so wanted to look into this as well.

When the load doesn't spike generally the server is running pretty well so i would like to work out what is causing the load to go up so we can look at that issue.

Current specs are

64 GB RAM
16 cores
600 GB SSD
Litespeed webserver
Related categories: Linux Apache MySQL CentOs Magento 2