Shard Just One Table Into A Different MYSQL Server?

  • I have a woocommerce site with 80,000 products. It’s on pretty speedy VPS (8GB RAM, 4CPUs, SD hard drives) and it’s configured pretty well (nginx, php-opcode caching, w3 total cache, etc.) but when navigating individual products, it takes several seconds to load. I noticed this starting around the 40,000 product mark and it only worsened from there.

    I’m trouble shot just about every, and the only option left is the mysql database. I’m planning on sharding it with hyperdb to see if that improves performance.

    At the moment I have the original wordpress install on one server, and another blank mysql server where I want to shard the product table onto.

    So ideally I would like the original install to keep everything except the product tables. Anyone know how I would go about sharding out one or two tables? Thanks in advance, I’ve been pounding my head against the wall with this for far too long!

    https://www.ads-software.com/plugins/hyperdb/

Viewing 1 replies (of 1 total)

  • alteredorange:

    Check the Partitioning example configuration: using a callback, you can change the server based in which table is being queried and the dataset value

Viewing 1 replies (of 1 total)
  • The topic ‘Shard Just One Table Into A Different MYSQL Server?’ is closed to new replies.

Tags