Skip to content

Instantly share code, notes, and snippets.

@dasl-
Created January 28, 2019 20:22
Show Gist options
  • Save dasl-/dab89ac2fdd72ebba0e522606eb3e66a to your computer and use it in GitHub Desktop.
Save dasl-/dab89ac2fdd72ebba0e522606eb3e66a to your computer and use it in GitHub Desktop.

It is possible to host different parts of a MySQL server files on different partitions. For instance, the data file may reside in flash, while the bin logs and relay logs are on spindle. To achieve this, create a symlink from $VTDATAROOT/<dir name> to the proper location on disk. When MySQL is configured by mysqlctl, it will realize this directory exists, and use it for the files it would otherwise have put in the tablet directory. For instance, to host the binlogs in /mnt/bin-logs:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment