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
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<TITLE> [Mageia-sysadm] SQL Server
</TITLE>
<LINK REL="Index" HREF="index.html" >
<LINK REL="made" HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20SQL%20Server&In-Reply-To=%3C1288287005.30067.40.camel%40akroma.ephaone.org%3E">
<META NAME="robots" CONTENT="index,nofollow">
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<LINK REL="Previous" HREF="000099.html">
<LINK REL="Next" HREF="000121.html">
</HEAD>
<BODY BGCOLOR="#ffffff">
<H1>[Mageia-sysadm] SQL Server</H1>
<B>Michael Scherer</B>
<A HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20SQL%20Server&In-Reply-To=%3C1288287005.30067.40.camel%40akroma.ephaone.org%3E"
TITLE="[Mageia-sysadm] SQL Server">misc at zarb.org
</A><BR>
<I>Thu Oct 28 19:30:05 CEST 2010</I>
<P><UL>
<LI>Previous message: <A HREF="000099.html">[Mageia-sysadm] SQL Server
</A></li>
<LI>Next message: <A HREF="000121.html">[Mageia-sysadm] SQL Server
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#101">[ date ]</a>
<a href="thread.html#101">[ thread ]</a>
<a href="subject.html#101">[ subject ]</a>
<a href="author.html#101">[ author ]</a>
</LI>
</UL>
<HR>
<!--beginarticle-->
<PRE>Le jeudi 28 octobre 2010 à 19:02 +0200, nicolas vigier a écrit :
><i> We will need an SQL server for bugzilla, the packages maintainers
</I>><i> database, the wiki, the blogs, the mageia.org website (not now, but
</I>><i> maybe later), sympa mailing lists, transifex, and maybe others tools
</I>><i> later.
</I>><i>
</I>><i> We can use MySQL (or forks), PostreSQL, or both.
</I>
Both.
bugzilla use mysql or postgresql
package db ( if we reuse the one of mandriva ) use mysql
wiki not decided yet
blog use wordpress, so mysql ( postgresql is still experimental )
sympa can use both ( or even anything supported by dbi such as
<A HREF="http://search.cpan.org/~rehsack/DBD-AnyData-0.110/lib/DBD/AnyData.pm">http://search.cpan.org/~rehsack/DBD-AnyData-0.110/lib/DBD/AnyData.pm</A> )
epoll requires postgresql.
our current perl webapp, catdap and mga::mirror requires postgresql.
transifex, being in django support mysql or postgresql
<A HREF="http://docs.djangoproject.com/en/dev/ref/databases/">http://docs.djangoproject.com/en/dev/ref/databases/</A>
( or sqlite or firebird )
so we have a majority of database agnostic tools, except a few one that
requires each their own.
Given the activity around mysql and forks, wouldn't it be safer for us
to use postgresql when possible for the moment ?
( not that I think it will change much, IMHO, even if nanar will say me
that postgresql >> mysql )
><i> One server for everything, or multiple servers.
</I>
I would go for :
one postgresql sql server for bugzilla, sympa, epoll transflex, on
alamut or valstar ( since everything will be in local network )
one mysql db for maintainers and maybe others when they appear.
one separated mysql db for web ( blog ) on the next gandi vm ( so there
is no lag )
--
Michael Scherer
</PRE>
<!--endarticle-->
<HR>
<P><UL>
<!--threads-->
<LI>Previous message: <A HREF="000099.html">[Mageia-sysadm] SQL Server
</A></li>
<LI>Next message: <A HREF="000121.html">[Mageia-sysadm] SQL Server
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#101">[ date ]</a>
<a href="thread.html#101">[ thread ]</a>
<a href="subject.html#101">[ subject ]</a>
<a href="author.html#101">[ author ]</a>
</LI>
</UL>
<hr>
<a href="https://www.mageia.org/mailman/listinfo/mageia-sysadm">More information about the Mageia-sysadm
mailing list</a><br>
</body></html>
|
