# How to create separate directory for Databases

**URL:** <https://forums.percona.com/t/how-to-create-separate-directory-for-databases/3460>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [May 9, 2014, 5:59am UTC](https://forums.percona.com/t/how-to-create-separate-directory-for-databases/3460 "2014-05-09T05:59:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![brainwhistler](https://avatars.discourse-cdn.com/v4/letter/b/a87d85/32.png) [@brainwhistler](https://forums.percona.com/u/brainwhistler)\
**Post date:** [May 9, 2014, 5:59am UTC](https://forums.percona.com/t/how-to-create-separate-directory-for-databases/3460/1 "2014-05-09T05:59:43Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [May 14, 2014, 12:16am UTC](https://forums.percona.com/t/how-to-create-separate-directory-for-databases/3460/2 "2014-05-14T00:16:30Z")

</div>

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.
