We have some medium size MySQL databases (500 GB) on Oracle MySQL community edition, version 5.7.30.
How can we perform point-in-time recovery with mysqlpump?
It doesn't seem to have any option to specify binary log information in the dumped data like mysqldump or mydumper does.
However, neither mysqldump nor mydumper fits well our situation. mysqldump is single threaded and too slow for us. mydumper has only "standard" gzip compression, which wastes too much space and in addition, if compression is requested, takes all CPU resources which is causing monitoring alerts. With external compressor utility I can limit number of cores used, but I don't know how to pipe mydumper output to an external utility. There is currently no space available to handle uncompressed backup which could be compressed later. Also, this then is a two step process, dump first, compress later.