MySQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{divbox|orange||<big>'''NOTICE:''' This is considered an advanced (complicated) and experimental feature.</big>}} | {{divbox|orange||<big>'''NOTICE:''' This is considered an advanced (complicated) and experimental feature.</big>}} | ||
{{divbox|red||{{huge|'''NOTICE:''' Every {{kodi}} "client" '''must''' run the same version of {{kodi}}.}}<br />Otherwise they will not be sharing the same library. There can even be differences between [[development builds]], so make sure you always use the same build dates. See '''[[ | {{divbox|red||{{huge|'''NOTICE:''' Every {{kodi}} "client" '''must''' run the same version of {{kodi}}.}}<br />Otherwise they will not be sharing the same library. There can even be differences between [[development builds]], so make sure you always use the same build dates. See '''[[Databases#Database_Versions|Version table]]''' for more info. }} | ||
{{:MySQL/Contents}} | {{:MySQL/Contents}} | ||
:''For simple library sharing see: '''[[HOW-TO:Share libraries using UPnP]]''''' | :''For simple library sharing see: '''[[HOW-TO:Share libraries using UPnP]]''''' | ||
| Line 8: | Line 7: | ||
[[File:Network.png|200px|left]] | [[File:Network.png|200px|left]] | ||
;<big><u>Introduction</u></big> | ;<big><u>Introduction</u></big> | ||
<section begin="intro"/>If you have more than one {{kodi}} device on your local network then you might want to synchronize them | <section begin="intro"/>If you have more than one {{kodi}} device on your local network then you might want to synchronize them by sharing the Kodi library databases via the MySQL protocol. Using shared library databases allows you to store information for either your video or music library in a central database, so that multiple devices can access the same information at the same time.<section end="intro"/> | ||
This gives you the ability to do things like: | This gives you the ability to do things like: | ||
| Line 16: | Line 15: | ||
{{-}} | {{-}} | ||
;{{big| | ;{{big|MySQL Protocol & MariaDB}} | ||
<section begin="MariaDB" /> | <section begin="MariaDB" />When setting up shared Library databases either MySQL or Maria DB can be used as they both use the same MySQL protocol. Since many Linux distributions have dropped including MySQL and now instead now ship MariaDB it is being more common to use MariaDB for shared Library databases.<section end="MariaDB" /> | ||
Revision as of 10:18, 28 February 2018
|
Share libraries w/MySQL, guide: |
- For simple library sharing see: HOW-TO:Share libraries using UPnP
See also: Databases
- Introduction
If you have more than one Kodi device on your local network then you might want to synchronize them by sharing the Kodi library databases via the MySQL protocol. Using shared library databases allows you to store information for either your video or music library in a central database, so that multiple devices can access the same information at the same time.
This gives you the ability to do things like:
- Share watched and unwatched status for your media on all devices
- Stop watching a movie or TV show in one room then finish watching it in another room automatically
- Only one library to maintain for all devices
- MySQL Protocol & MariaDB
When setting up shared Library databases either MySQL or Maria DB can be used as they both use the same MySQL protocol. Since many Linux distributions have dropped including MySQL and now instead now ship MariaDB it is being more common to use MariaDB for shared Library databases.
| Next step: | Setting up MySQL |