Migrating from sqlite to MariaDB with HA running in Docker

Configuration
1

Is there any tutorial or guide how to migrate the data from sqlite to a MariaDB instance when HA is running in a Docker. Would I need to install MariaDB outside of the Docker?

p.s. I’m only vaguely familiar with how Docker works at this point unfortunately
p.p.s. I read a lot of people get better performance when using MariaDB, what about other DB engines?

Thanks!

2

When I did it, I didn’t worry about my legacy data. Realistically if you want long term trending you should be dumping stats into influxdb, even MariaDB will get slow keeping to long of history in it.

3

I see, so what are the advantages of using HA with MariaDB over InfluxDB, if any?

4

I am using both. MariaDB as the DB for HA. I have enabled influxdb so all my stats go there. That allows me to see trends over months/years if I so desire. influxdb is a time series db structure so it allows for storing time series data for a long time without a lot of storage requirements or performance limitations. With the influxdb data export enabled you can decide to push all or only certain counters/values to the DB.

5

I would be interested in this too.

1 Like