- How long do you expect the storage device to last for it? Is it OK to replace the storage device once per month because you need too many DWPD?
- Do you have network capacity to support that QPS load on a master? Assume all servers in the rack get that QPS and the QPS source is not rack local.
- Do you have network capacity to replicate that write load to a replica? Assume some replicas are far away.
- Can the replica replay those writes fast enough to avoid lag?
- Will you be able to keep enough replication log archives to support PITR?
- How will you take backups?
- Will restore ever finish applying logs during the catch up phase?
Monday, November 6, 2017
Questions I have about workloads with high write rates
I am sure I borrowed some of these from co-workers. When I read discussions about write-heavy workloads I ask myself some questions. I assume VoltDB and Tarantool has answers, but these are hard problems. I know that many of my write heavy MySQL tests ignore many of these problems because I usually run them with replication disabled.