Archives
MySQL on Docker Swarm revisited
Posted on September 25, 2020 Leave a Comment
It all started with a central database for my Kodi media players. Then I migrated the setup from a dedicated Raspberry Pi to running MySQL on docker swarm. That gave me much more stability and availability for the solution but it still needed backup. The setup ended up with limiting the docker container to a […]
MySQL on Docker Swarm
Posted on February 26, 2020 1 Comment
For several applications around the house, I need a MySQL backend. The biggest database I run is about 60Mb of data for my Kodi media players. By using centralized storage like this I only need to update one of them when I add new media. Also convenient if I watch a movie in the living […]
Kodi central db backup
Posted on March 20, 2017 2 Comments
Using a central database for all your Kodi media players is convenient. Only one of them need to scan for new content or you can even update the database straight away. It holds state across all the devices like paused movies, watched episodes etc. If you have a large library it takes time to scan […]
Raspberry PI: Central kodi database
Posted on February 16, 2016 8 Comments
When you run more then one Kodi device with a shared media repository you should also run a shared library. With a shared library you only need to update the library on one of the Kodi devices when new media is added. There are a few other great benefits of running a shared library like […]
Move MySQL database storage location
Posted on February 4, 2015 1 Comment
It’s always a good idea to keep storage away from the boot device. If you run out of space on the boot device the system will halt. If you make a new install it’s easy enough to move your storage and you can do it from a cloud-init script like this: [shell] – mkdir /var/db […]
Unattended use of mysql_secure_installation
Posted on February 3, 2015 Leave a Comment
After installing MySQL on any Linux distribution you run the mysql_secure_installation script, or at least you should! It will prompt you to set a new root password, remove anon access and a few other things. But if you want this configuration to be done in a deployment or cloud-init script? The mysql_secure_installation command/script doesn’t accept […]
Hackviking aka Kristofer Källsbo 