1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<TITLE> [Mageia-dev] Replacing mysql with mariadb
</TITLE>
<LINK REL="Index" HREF="index.html" >
<LINK REL="made" HREF="mailto:mageia-dev%40mageia.org?Subject=Re%3A%20%5BMageia-dev%5D%20Replacing%20mysql%20with%20mariadb&In-Reply-To=%3C4ED95E8A.6070309%40zen.co.uk%3E">
<META NAME="robots" CONTENT="index,nofollow">
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<LINK REL="Previous" HREF="010101.html">
<LINK REL="Next" HREF="010135.html">
</HEAD>
<BODY BGCOLOR="#ffffff">
<H1>[Mageia-dev] Replacing mysql with mariadb</H1>
<B>Barry Jackson</B>
<A HREF="mailto:mageia-dev%40mageia.org?Subject=Re%3A%20%5BMageia-dev%5D%20Replacing%20mysql%20with%20mariadb&In-Reply-To=%3C4ED95E8A.6070309%40zen.co.uk%3E"
TITLE="[Mageia-dev] Replacing mysql with mariadb">zen25000 at zen.co.uk
</A><BR>
<I>Sat Dec 3 00:26:02 CET 2011</I>
<P><UL>
<LI>Previous message: <A HREF="010101.html">[Mageia-dev] Replacing mysql with mariadb
</A></li>
<LI>Next message: <A HREF="010135.html">[Mageia-dev] Replacing mysql with mariadb
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#10115">[ date ]</a>
<a href="thread.html#10115">[ thread ]</a>
<a href="subject.html#10115">[ subject ]</a>
<a href="author.html#10115">[ author ]</a>
</LI>
</UL>
<HR>
<!--beginarticle-->
<PRE>On 02/12/11 16:27, Maarten Vanraes wrote:
><i> Op vrijdag 02 december 2011 14:40:40 schreef Barry Jackson:
</I>>><i> On 02/12/11 00:20, Maarten Vanraes wrote:
</I>>>><i> Op vrijdag 02 december 2011 00:13:28 schreef Barry Jackson:
</I>>>>><i> On 01/12/11 22:47, Maarten Vanraes wrote:
</I>>>>>><i> if you have a cauldron, you can enable updates_testing and then:
</I>>>>>><i> * rpm -e --nodeps all the mysql packages you have
</I>>>>>><i> * urpmi all the identical mariadb packages
</I>>>>><i>
</I>>>>><i> OK - I guess the names are similar - not looked yet ;)
</I>>><i>
</I>>><i> I said I would need help :\
</I>><i>
</I>><i> thanks for that!
</I>><i>
</I>><i> i guess i should be clearer, i meant the packages that are built from the
</I>><i> mysql src.rpm
</I>><i>
</I>><i> this is for you:
</I>><i>
</I>>><i> mysql-common-core-5.5.15-2.mga2
</I>>><i> lib64mysqlservices-5.5.15-2.mga2
</I>>><i> lib64mysqld0-5.5.15-2.mga2
</I>>><i> mysql-client-5.5.15-2.mga2
</I>>><i> mysql-core-5.5.15-2.mga2
</I>>><i> mysql-5.5.15-2.mga2
</I>>><i> lib64mysql18-5.5.15-2.mga2
</I>>><i> mysql-common-5.5.15-2.mga2
</I>>><i> lib64mysql-devel-5.5.15-2.mga2
</I>><i>
</I>><i>
</I>>><i> Yet with testing enabled I see :-
</I>>><i> [<A HREF="https://www.mageia.org/mailman/listinfo/mageia-dev">baz at jackodesktop</A> ~]$ urpmq mariadb -a
</I>>><i> mariadb
</I>><i> [...]
</I>><i>
</I>><i> (afaik mariadb is an exact match, so maybe that's why it lists only mariadb)
</I>><i>
</I>><i> [<A HREF="https://www.mageia.org/mailman/listinfo/mageia-dev">root at localhost</A> ~]# urpmq -Y mariadb
</I>><i> lib64mariadb-devel
</I>><i> lib64mariadb-embedded-devel
</I>><i> lib64mariadb-embedded0
</I>><i> lib64mariadb18
</I>><i> lib64mariadbservices
</I>><i> mariadb
</I>><i> mariadb-bench
</I>><i> mariadb-client
</I>><i> mariadb-common
</I>><i> mariadb-common-core
</I>><i> mariadb-core
</I>><i>
</I>><i>
</I>><i> thus, for you:
</I>><i>
</I>><i> mariadb-common-core
</I>><i> lib64mariadbservices
</I>><i> lib64mariadb-embedded0
</I>><i> mariadb-client
</I>><i> mariadb-core
</I>><i> mariadb
</I>><i> lib64mariadb18
</I>><i> mariadb-common
</I>><i> lib64mariadb-devel
</I>><i>
</I>><i> happy testing :-)
</I>><i>
</I>Thanks,
In fact all (except the -devel) were installed by default:-
[<A HREF="https://www.mageia.org/mailman/listinfo/mageia-dev">root at jackodesktop</A> baz]# urpmi mariadb
In order to satisfy the 'libmysqlservices.so()(64bit)' dependency, one
of the following packages is needed:
1- lib64mysqlservices-5.5.15-2.mga2.x86_64: Shared libraries (to install)
2- lib64mariadbservices-5.5.15-0.4.mga2.x86_64: Shared libraries (to
install)
What is your choice? (1-2) 2
To satisfy dependencies, the following packages are going to be installed:
Package Version Release Arch
(medium "Core Updates Testing (distrib5)")
lib64mariadb18 5.5.15 0.4.mga2 x86_64
lib64mariadbservices 5.5.15 0.4.mga2 x86_64
mariadb 5.5.15 0.4.mga2 x86_64
mariadb-client 5.5.15 0.4.mga2 x86_64
mariadb-common 5.5.15 0.4.mga2 x86_64
mariadb-common-core 5.5.15 0.4.mga2 x86_64
mariadb-core 5.5.15 0.4.mga2 x86_64
97MB of additional disk space will be used.
7.3MB of packages will be retrieved.
Proceed with the installation of the 7 packages? (Y/n) y
--------snip----------
OK testing so far with ZoneMinder:-
For those not familiar with ZoneMinder, in brief:-
ZoneMinder is a LAMP Web application for monitoring CCTV cameras,
recording the video streams and serving them to LAN or WAN.
It relies on a deep mysql database to store thousands of images in real
time. It also uses mysql to store the log files and display them in a
web browser in the ZoneMinder console.
I installed mariadb this evening and after working around a minor
mariadb packaging hiccup ;) (which is now apparently fixed in svn) I
re-built ZoneMinder against it.
There were no issues in the re-build and the application seems totally
transparent to the change.
There were no issues with my setup script which starts mysql, checks for
an existing mysql password, offers to optionally create one, checks for
an existing zm database and offers to use it, or replace it. I replaced
it and a new one was created without problem. The script then started
httpd and the ZoneMinder service.
No problems at all.
The only operational checks so far involve the logging database, but
that is working fine. Unfortunately I cannot test under full working
conditions without capture card or network cameras which I don't have
connected to this hardware.
I do have a server running ZoneMinder on mga1 with 8 cameras but until
mga2 is released and settled for a while I won't be updating it.
So in a nutshell as far as I have tested it just works out of the box.
:<i>)
</I>
Barry
</PRE>
<!--endarticle-->
<HR>
<P><UL>
<!--threads-->
<LI>Previous message: <A HREF="010101.html">[Mageia-dev] Replacing mysql with mariadb
</A></li>
<LI>Next message: <A HREF="010135.html">[Mageia-dev] Replacing mysql with mariadb
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#10115">[ date ]</a>
<a href="thread.html#10115">[ thread ]</a>
<a href="subject.html#10115">[ subject ]</a>
<a href="author.html#10115">[ author ]</a>
</LI>
</UL>
<hr>
<a href="https://www.mageia.org/mailman/listinfo/mageia-dev">More information about the Mageia-dev
mailing list</a><br>
</body></html>
|
