Optimize MariaDB and install free MariaDB monitoring software
Budget: €250 – €750 EUR
I have a Woocommerce installation with currently 50,000 products. It must be able to hold around 300,000 products.
What must be done:
- Optimize the MariaDB 10.5 server
- Optimize Nginx (reverse proxy) and Apache
- Optimize any other relevant program
- Install a MariaDB monitoring software, like https://www.percona.com/software/database-tools/percona-monitoring-and-management
Results that must be delivered:
- Very fast import with the WP All Import plugin (it’s currently taking around 2 seconds for 1 product, it should be able to create multiple products per second)
This setup is currently hosted in Azure, 128 GB SSD, 4 core 16 GB (I am using B4ms: https://azure.microsoft.com/en-us/blog/introducing-b-series-our-new-burstable-vm-size/).
OS = CentOS 7.9
What must be done:
- Optimize the MariaDB 10.5 server
- Optimize Nginx (reverse proxy) and Apache
- Optimize any other relevant program
- Install a MariaDB monitoring software, like https://www.percona.com/software/database-tools/percona-monitoring-and-management
Results that must be delivered:
- Very fast import with the WP All Import plugin (it’s currently taking around 2 seconds for 1 product, it should be able to create multiple products per second)
This setup is currently hosted in Azure, 128 GB SSD, 4 core 16 GB (I am using B4ms: https://azure.microsoft.com/en-us/blog/introducing-b-series-our-new-burstable-vm-size/).
OS = CentOS 7.9