One of the benefits of streaming backups and using Unix pipes is that the backups can be automatically encrypted. Just be careful not to assign more memory then you have to spare. Incremental streaming backups can be performed with the xbstream streaming option. Accelerating the backup process Copying with the --parallel and --compress-threads Options When making a local or streaming backup with xbstream option, multiple files can be copied at the same time when using the --parallel option. The MySQL client libraries are used to parse command-line options and configuration file.
nest...