Hardware Requirements

MemCP can run on any hardware that is supported by the go compiler.

To find the right hardware dimensions, you need to consider the following:

• The process itself needs at least 8 MiB of RAM
• The size of a 5 GiB MySQL database fits into ~1 GiB of RAM
• To have a decent working set, take the RAM requirements x3, so a 5 GiB MySQL database should run on 3 GiB RAM
• MemCP needs at least 1 CPU core, more is better ;)

Running on Big SMP Machines

MemCP runs best on machiens that have a lot of RAM and CPU cores.

We tested on:

• AMD Ryzen (in various forms)
• HPE Superfome Flex (https://www.hpe.com/us/en/servers/superdome.html)

Running on Raspberry Pi

These are our recommendations to run MemCP on Raspberry Pi:

• Avoid ENGINE=safe. To have a long life for your flash drive, you should choose ENGINE=sloppy. (ENGINE=logging would be a compromise between safe and sloppy) - for more information see Persistency and Performance Guarantees
• Raspberry Pis have very limited RAM. In most cases, the RAM is sufficient though since most databases only take a few megabytes of RAM. For bigger data, you should wait for MMaped shards, see also: Current Status and open issues