Keywords: OpenCart - Google Cloud Platform - Technical issue - Other
Description:
We are facing latency issues between Master and 2 Slave DB's.
Platform - GCP
Installation - GCP Marketplace - MariaDB with Replication
Server Config - n1-standard-4 (4 vCPUs, 15 GB memory)
Location - Mumbai Region, India
Following are the queries we have:-
1. If we increase the server config (vCPU's, Memory and HDD) will it help us with improving "latency" between Master and Slave
2. Is there a way we can avoid syncing of specific tables on slave? We want to avoid syncing log tables which has a lot of data.
3. We use Opencart with Redis/Elastic but the number of workers/crons running choke the db, hence what config is recommended?
4. If we move to CloudSQL will it help in improving the master>slave latency issues?