# Rancher Mysql data

**URL:** <https://forums.suse.com/t/rancher-mysql-data/11657>\
**Category:** SUSE Rancher Prime\
**Created:** [August 31, 2018, 6:10pm UTC](https://forums.suse.com/t/rancher-mysql-data/11657 "2018-08-31T18:10:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![imanco67](https://avatars.discourse-cdn.com/v4/letter/i/b5ac83/32.png) [@imanco67](https://forums.suse.com/u/imanco67)\
**Post date:** [August 31, 2018, 6:10pm UTC](https://forums.suse.com/t/rancher-mysql-data/11657/1 "2018-08-31T18:10:27Z")

</div>

I am trying to figure out how Rancher 2.0.4 handles its mysql data store.

I didnt setup a remote mysql server or pointing my container to a local mount.

I restarted my rancher container and my data came back, but it took 30 mins.

I though that running the rancher docker without a remote mysql of local mount, my config will be lost forever.

Thanks!

---

<div class="post-metadata">

**Author:** ![imanco67](https://avatars.discourse-cdn.com/v4/letter/i/b5ac83/32.png) [@imanco67](https://forums.suse.com/u/imanco67)\
**Post date:** [September 4, 2018, 2:58pm UTC](https://forums.suse.com/t/rancher-mysql-data/11657/2 "2018-09-04T14:58:52Z")

</div>

Does ETCD somehow maintain the rancher data?

---

<div class="post-metadata">

**Author:** ![marcqualie](https://sea2.discourse-cdn.com/flex022/user_avatar/forums.suse.com/marcqualie/32/921_2.png) [@marcqualie](https://forums.suse.com/u/marcqualie)\
**Post date:** [September 7, 2018, 3:42pm UTC](https://forums.suse.com/t/rancher-mysql-data/11657/3 "2018-09-07T15:42:17Z")

</div>

I’ve recently been looking into this myself migrating from Rancher 1.6 and found that the etc data is persisted to `/var/lib/rancher` on disk.

In the single node example there’s a section on persisting this data at the following link:

- [https://rancher.com/docs/rancher/v2.x/en/installation/single-node/#persistent-data](https://rancher.com/docs/rancher/v2.x/en/installation/single-node/#persistent-data)

I currently have this as an external volume so that I can create new hosts and mount the disk to retain this information. I’m also backing this up regularly to S3 as a tar archive using the method detailed in the following link:

- [https://rancher.com/docs/rancher/v2.x/en/backups/backups/single-node-backups/](https://rancher.com/docs/rancher/v2.x/en/backups/backups/single-node-backups/)

---

<div class="post-metadata">

**Author:** ![imanco67](https://avatars.discourse-cdn.com/v4/letter/i/b5ac83/32.png) [@imanco67](https://forums.suse.com/u/imanco67)\
**Post date:** [September 18, 2018, 1:25pm UTC](https://forums.suse.com/t/rancher-mysql-data/11657/4 "2018-09-18T13:25:52Z")

</div>

Thank you I verified and its persisting locally