ArcticWolf
Trusted Helper
First up, I've NEVER used MySQL or anything like it before, so please be gentle . Don't go too mad with the whole tech aspect of it up front .
Right now, I have 2 x Synology DS418 NAS boxes on my home network but that will hopefully be increased to 3 x DS418's over the coming days as well. (It's my limited understanding that I'd need to use MariaDB as the MySQL server on a Syno NAS?) Additionally, I use the DSM Web UI to manage all aspects of the NAS's themselves, (no SSH/terminal based access etc.). Presumably, PHPMyAdmin is going to be my best option there too rather than messing around (or messing up) with command lines. (I used to use SSH (PuTTY etc.) to remotely compile/admin IRC servers 15-20 years ago but I've not had anything to do with Linux systems for so long all of that knowledge is just completely gone now .) If it affects MySQL config/access too, the firewalls on the NAS's are also enabled/configured to only allow LAN access.
Obviously, I have several individual devices that are all running the same base version of Kodi (18). They've all been individually configured to have the same libraries from the shares on my NAS boxes. However, it just isn't an option to keep each individual library updated to include the "my ratings" of my movie/TV show collection, or marking media as watched, tracking progress, etc., etc.
As such.... I'd like to attempt setting up a centralised MySQL system.
I've been reading/viewing several different online guides/tutorials for setting up MySQL, but they're all essentially guides for setting up MySQL with a single NAS!!! What I can't find is any info for setting up MySQL if multiple NAS's are in use.
How would that work please? How do I configure MySQL if I have media stored in several different directories across all three NAS boxes? Would I need to install MariaDB on all of the NAS's & each NAS would then become a server & create its own DB? Or, do I still just install MariaDB on one of the NAS's & a single NAS runs as the MySQL server?
I might have stood a chance of successfully setting up MySQL by myself if I was simply following a step by step tutorial & just using a single NAS lol . However, having multiple NAS's in use obviously complicates things.
Any help or info much appreciated .
Cheers,
Wolfy.
Right now, I have 2 x Synology DS418 NAS boxes on my home network but that will hopefully be increased to 3 x DS418's over the coming days as well. (It's my limited understanding that I'd need to use MariaDB as the MySQL server on a Syno NAS?) Additionally, I use the DSM Web UI to manage all aspects of the NAS's themselves, (no SSH/terminal based access etc.). Presumably, PHPMyAdmin is going to be my best option there too rather than messing around (or messing up) with command lines. (I used to use SSH (PuTTY etc.) to remotely compile/admin IRC servers 15-20 years ago but I've not had anything to do with Linux systems for so long all of that knowledge is just completely gone now .) If it affects MySQL config/access too, the firewalls on the NAS's are also enabled/configured to only allow LAN access.
Obviously, I have several individual devices that are all running the same base version of Kodi (18). They've all been individually configured to have the same libraries from the shares on my NAS boxes. However, it just isn't an option to keep each individual library updated to include the "my ratings" of my movie/TV show collection, or marking media as watched, tracking progress, etc., etc.
As such.... I'd like to attempt setting up a centralised MySQL system.
I've been reading/viewing several different online guides/tutorials for setting up MySQL, but they're all essentially guides for setting up MySQL with a single NAS!!! What I can't find is any info for setting up MySQL if multiple NAS's are in use.
How would that work please? How do I configure MySQL if I have media stored in several different directories across all three NAS boxes? Would I need to install MariaDB on all of the NAS's & each NAS would then become a server & create its own DB? Or, do I still just install MariaDB on one of the NAS's & a single NAS runs as the MySQL server?
I might have stood a chance of successfully setting up MySQL by myself if I was simply following a step by step tutorial & just using a single NAS lol . However, having multiple NAS's in use obviously complicates things.
Any help or info much appreciated .
Cheers,
Wolfy.