MySQL - Revision history

Klojum at 04:51, 23 January 2022

2022-01-23T04:51:48Z

← Older revision		Revision as of 04:51, 23 January 2022
Line 15:		Line 15:

	;{{big\|MySQL Protocol & MariaDB}}		;{{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" />		<section begin="MariaDB" />When setting up shared Library databases either MySQL or MariaDB 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" />

Karellen at 03:58, 19 August 2020

2020-08-19T03:58:05Z

← Older revision		Revision as of 03:58, 19 August 2020
Line 2:		Line 2:
	{{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. }}		{{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]]'''''~~
	{{See also\|Databases}}		{{See also\|Databases}}

Karellen at 10:18, 28 February 2018

2018-02-28T10:18:35Z

← Older revision		Revision as of 10:18, 28 February 2018
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 '''[[~~Database_versions~~\|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]]'''''

Karellen at 10:13, 26 February 2018

2018-02-26T10:13:23Z

← Older revision		Revision as of 10:13, 26 February 2018
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 '''[[~~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 '''[[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]]'''''

Karellen at 00:35, 22 February 2018

2018-02-22T00:35:51Z

← Older revision		Revision as of 00:35, 22 February 2018
Line 16:		Line 16:

	;{{big\|MySQL Protocol & MariaDB}}		;{{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" />		<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" />

Karellen: add back transclusion

2018-02-22T00:35:32Z

add back transclusion

← Older revision		Revision as of 00:35, 22 February 2018
Line 16:		Line 16:

	;{{big\|MySQL Protocol & MariaDB}}		;{{big\|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.		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" />

Karellen: Replacing v18 notes with more appropriate edits from jjd-uk

2018-02-21T21:35:38Z

Replacing v18 notes with more appropriate edits from jjd-uk

← Older revision		Revision as of 21:35, 21 February 2018
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 {{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 '''[[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 '''[[XBMC databases/Version table\|Version table]]''' for more info. }}
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 ~~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.<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 16:		Line 15:
	{{-}}		{{-}}

	;{{big\|~~Note for v18~~}}		;{{big\|MySQL Protocol & MariaDB}}
	~~<section begin="MariaDB" />As of v18, {{kodi}} has moved to supporting '''''[https://mariadb.org/ 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.~~		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.

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

Rechi at 10:47, 21 February 2018

2018-02-21T10:47:33Z

← Older revision		Revision as of 10:47, 21 February 2018
Line 22:		Line 22:

	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.		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<section end="MariaDB" />~~

Karellen: Modified v18 note

2018-02-21T09:22:24Z

Modified v18 note

← Older revision		Revision as of 09:22, 21 February 2018
Line 4:		Line 4:
	{{: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>
Line 14:		Line 16:
	{{-}}		{{-}}

	;Note for v18		;{{big\|Note for v18}}
	{{~~#lst~~:~~Databases\|~~MariaDB}}		<section begin="MariaDB" />As of v18, {{kodi}} has moved to supporting '''''[https://mariadb.org/ 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<section end="MariaDB" />

Karellen at 06:14, 11 February 2018

2018-02-11T06:14:31Z

← Older revision		Revision as of 06:14, 11 February 2018
Line 12:		Line 12:
	* 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
			{{-}}

			;Note for v18
			{{#lst:Databases\|MariaDB}}


	{{next\|[[MySQL/Setting up MySQL\|Setting up MySQL]]}}		{{next\|[[MySQL/Setting up MySQL\|Setting up MySQL]]}}