Hi Folks.. I run a woo commerce store with daily 10-15k visitors as of now. I am currently hosted on a decent litespeed based VPS (lets call it A). I have a team of a out 15 people which uses the backend for operation like product listing, order processing, content writing etc thru the day. This causes the website to load slow. I am planning to use an inventory management system along with few other heavy plugins for data analytics. I was thinking of an idea and this is where i need suggestions from you guys. I want to have subdomain hosted on different server on which my team can work (Lets call it server B). The idea is that we leave A as it is and whenever there is a new order it syncs with database of B (some delay is acceptable). Also, the listings and content created by team on B will sync with A on regular intervals. Is it possible and what challenges i might face with this setup.
[ad_2]
You can use seprate admin panels for your woocommerce, popular options include wpfusion and woocommerce admin
you can also use
# Third-party Inventory Management Systems for WooCommerce, popular options include Zoho Inventory,Orderhive,Shopventory
When I think of admin operations that could adversely affect a server’s performance, it’s uploading images that comes first to mind as a culprit and changes to the database is dead last. Are your images being optimized prior to uploading? Are your admins even considering the image dimensions or relying solely on WP to do that?
If you’re still looking to optimize the db performance, instead of the configuration you’re suggesting I would look at either upgrading the web server or moving the db to another server entirely. The former is usually cheaper and easier. Syncing data two-ways, instead of a master/slave configuration is going to always cause problems. You need a ‘single source of truth’.