MySQL

From Official Kodi Wiki
Revision as of 09:22, 21 February 2018 by Karellen (talk | contribs) (Modified v18 note)
Jump to navigation Jump to search
Home icon grey.png   ▶ Syncing and sharing ▶ MySQL

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 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 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


Note for v18

As of v18, Kodi has moved to supporting MariaDB instead of MySQL for sharing databases across multiple Kodi client installs, but still using the same MySQL protocol. MariaDB is an Open Source project and is currently one of the world's most popular database servers. It is a fork of MySQL and fully compatible with it.

As updates to MySQL have slowed over recent years, the Kodi Team felt it necessary to seek an alternative or risk encountering issues in the future. An end user of Kodi will not be aware of any changes to the underlying databases.

Many Linux distributions have dropped MySQL and ship MariaDB instead. MariaDB also ships with compatibility files that will allow seamless interaction with the existing MySQL database on other platforms. For those users with MySQL shared setup, MariaDB will still be able to connect to the MySQL server.

As of v19, the MySQL protocol will be dropped completely and replaced by MariaDB


Next step: Setting up MySQL