# Changing MySQL Default Data directory in Percona XtraDB Cluster.

**URL:** <https://forums.percona.com/t/changing-mysql-default-data-directory-in-percona-xtradb-cluster/6879>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [March 2, 2019, 9:37am UTC](https://forums.percona.com/t/changing-mysql-default-data-directory-in-percona-xtradb-cluster/6879 "2019-03-02T09:37:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![piyush.chaudhari](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/piyush.chaudhari/32/53_2.png) [@piyush.chaudhari](https://forums.percona.com/u/piyush.chaudhari)\
**Post date:** [March 2, 2019, 9:37am UTC](https://forums.percona.com/t/changing-mysql-default-data-directory-in-percona-xtradb-cluster/6879/1 "2019-03-02T09:37:34Z")

</div>

Hello,

We have setup a 3 node Percona MySQL XtraDB Cluster 5.7 under Azure Load Balancer. But, when we deployed, we did not change MySQL data directory. Now, our DB size is increasing day by day. Hence, we have attached a Premium SSD. Now, we want to change default MySQL data directory on all 3 nodes.

Can anyone please drop me step by step procedure to change MySQL data directory on all 3 nodes of Cluster???

Awaiting for your kind response.

---

<div class="post-metadata">

**Author:** ![SebastianG](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sebastiang/32/54_2.png) [@SebastianG](https://forums.percona.com/u/SebastianG)\
**Post date:** [March 10, 2019, 5:27pm UTC](https://forums.percona.com/t/changing-mysql-default-data-directory-in-percona-xtradb-cluster/6879/2 "2019-03-10T17:27:54Z")

</div>

Azure LB? Why would you do that for? But yeah… anything’s possible.

Not quite a big fan to change data-dir but usually I symlink everything.

The way I do it (CentOS 7 let’s say):

```auto

# systemctl stop mysql
# mv /var/lib/mysql /mnt/mysql-data
# ln -s /mnt/mysql-data/mysql mysql
# chown -R mysql:mysql /mnt/mysql-data/

```

Last line is more to make sure that all permissions are in place.

Once that’s completed:

```auto

#systemctl start mysql

```

Job done, nothing else changed.

Never had an issue using this in years.

---

<div class="post-metadata">

**Author:** ![piyush.chaudhari](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/piyush.chaudhari/32/53_2.png) [@piyush.chaudhari](https://forums.percona.com/u/piyush.chaudhari)\
**Post date:** [June 5, 2019, 4:05am UTC](https://forums.percona.com/t/changing-mysql-default-data-directory-in-percona-xtradb-cluster/6879/3 "2019-06-05T04:05:33Z")

</div>

Thanks dude for taking initiative & responding to this thread. I have successfully changed the data directory of MySQL in Percona Cluster. Job done. I have moved it to another Azure premium SSD attached to my cluster nodes.