diff options
Diffstat (limited to 'zarb-ml/mageia-sysadm/2010-October/000101.html')
| -rw-r--r-- | zarb-ml/mageia-sysadm/2010-October/000101.html | 114 |
1 files changed, 114 insertions, 0 deletions
diff --git a/zarb-ml/mageia-sysadm/2010-October/000101.html b/zarb-ml/mageia-sysadm/2010-October/000101.html new file mode 100644 index 000000000..d189765d8 --- /dev/null +++ b/zarb-ml/mageia-sysadm/2010-October/000101.html @@ -0,0 +1,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> |