MySQL: Difference between revisions

From Official Kodi Wiki
Jump to navigation Jump to search
m (Robot: Substituting template: Name)
No edit summary
(14 intermediate revisions by 4 users not shown)
Line 1: Line 1:
{{mininav|[[Syncing and sharing]]}}
{{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 XBMC "client" '''must''' run the same version of XBMC.}}<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 '''[[XBMC databases/Version table|Version table]]''' for more info. }}
{{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]]'''''
{{See also|Databases}}
[[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 XBMC device on your local network then you might want to synchronize them using a MySQL library. Using a MySQL library allows you to store information about your whole video library in a central database, so that multiple XBMC devices can access the same information at the same time.<section end="intro"/>
<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 12: Line 13:
* Stop watching a movie or TV show in one room then finish watching it in another room automatically
* 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
* Only one library to maintain for all devices
{{-}}
;{{big|MySQL Protocol & 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" />


{{next|[[MySQL/Setting up MySQL|Setting up MySQL]]}}
{{next|[[MySQL/Setting up MySQL|Setting up MySQL]]}}
{{Frodo updated}}
 
{{Updated|16}}


[[Category:How-to]]
[[Category:How-to]]

Revision as of 10:18, 28 February 2018

Share libraries w/MySQL, guide:

  1. Introduction
  2. Setting up MySQL
  3. Setting up Kodi
For simple library sharing see: HOW-TO:Share libraries using UPnP
Network.png
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