Sounds to me like you have no choice but to shard your database in order to reduce the write load on a single database. Or upgrade your database servers' hardw

Sounds to me like you have no choice but to shard your database in order to reduce the write load on a single database. Or upgrade your database servers' hardware (more RAM, faster CPU, faster SSD) to the point where you can dump the database.