GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

How to create separate directory for Databases

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to create separate directory for Databases

    Hello,

    I have just installed Percona XDB Cluster. Currently the datadir is set to /var/lib/mysql.

    I want to have separate directory for Databsase only. Actually on SSD drives.

    How can I do this.

    Thanks

  • #2
    MySQL doesn’t have an option to configure separate storage paths for each database. The usual way is to create database, shutdown mysql, move database to different drive, allow in apparmor/selinux, start mysql service and probably it requires to fix paths in mysqld init script.

    Comment

    Working...
    X