In the News

[binderth (Thomas Binder)]

@markrad

Thanks for the idea. I’m not using persistence at the moment but I do have a Synology too. Putting it on there sounds like a good idea. Does it take much configuration? I’ve not looked at it at all yet.

Easy:

1. Install MariaDB package on Synology
2. Configure oh2 to use that one (ip in mysql.cfg)

And in case you have many items and need persistence for ad hoc rules, but you don’t need historic data:

"Garbage Collection" on MySQL persistence: deleting old Item states

Intro If you’re using OpenHAB2’s persistence for some reason or another, you will sooner or later come to one question: why do I save all those old states, which I don’t Need for. My OH2 was running for nearly a year now and I persist nearly all items and the size of the DB growing by the day. So I wrote basically a stored procedure in MySQL to come up with a garbage collection. Why directly in the database? I don’t use other persistences and I don’t want to mess around with connections, the ri…