# Databases on different harddrives

**URL:** <https://forums.percona.com/t/databases-on-different-harddrives/4737>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [February 22, 2016, 5:16am UTC](https://forums.percona.com/t/databases-on-different-harddrives/4737 "2016-02-22T05:16:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![drak](https://avatars.discourse-cdn.com/v4/letter/d/c2a13f/32.png) [@drak](https://forums.percona.com/u/drak)\
**Post date:** [February 22, 2016, 5:16am UTC](https://forums.percona.com/t/databases-on-different-harddrives/4737/1 "2016-02-22T05:16:58Z")

</div>

Hello,

In my setup i put databases onto a different harddrives

In my /var/lib/mysql folder i got symbolic links linking to storages on external drives.

Problem is that during SST, whole /var/lib/mysql directory is beeing cleared along with symbolic links. The harddrive on which folder /var/lib/mysql is located does not contain enough storage space to fit all databases therefore whole node recovery procedure fails.

I increased galera cache to reduce the probability of SST, but in case of serious problem when i have to keep node down for longer time, SST may be necessary. In case of SST i have to attach additional storage to fit all databases, wait for SST complete, take node down, move databases to apropriate storages, move /var/lib/mysql to apropriate stoarge and restart node.  
I would preferer SST not to be such a hassle in my configuration.

What is the correct setup for such case ? (Databases on multiple hard drives) ?

Regards  
Piotr

---

<div class="post-metadata">

**Author:** ![umarzuki](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/umarzuki/32/1064_2.png) [@umarzuki](https://forums.percona.com/u/umarzuki)\
**Post date:** [February 22, 2016, 8:46am UTC](https://forums.percona.com/t/databases-on-different-harddrives/4737/2 "2016-02-22T08:46:27Z")

</div>

use LVM with those drives

---

<div class="post-metadata">

**Author:** ![drak](https://avatars.discourse-cdn.com/v4/letter/d/c2a13f/32.png) [@drak](https://forums.percona.com/u/drak)\
**Post date:** [February 22, 2016, 2:06pm UTC](https://forums.percona.com/t/databases-on-different-harddrives/4737/3 "2016-02-22T14:06:50Z")

</div>

> [@umarzuki;43739](#):
>
> use LVM with those drives

Hi umarzuki. I am using it but do not know how is it supposed to help.

What is the connection between lvm and percona database ?

---

<div class="post-metadata">

**Author:** ![umarzuki](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/umarzuki/32/1064_2.png) [@umarzuki](https://forums.percona.com/u/umarzuki)\
**Post date:** [March 3, 2016, 3:30am UTC](https://forums.percona.com/t/databases-on-different-harddrives/4737/4 "2016-03-03T03:30:51Z")

</div>

LVM is used to group hard disks so next time you just insert a new hard disk and add it to your DBs LVM group and increase partitions/logical volume’s size