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
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<TITLE> [Mageia-sysadm] [Mageia-webteam] Forum VM needs
</TITLE>
<LINK REL="Index" HREF="index.html" >
<LINK REL="made" HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20%5BMageia-webteam%5D%20%20Forum%20VM%20needs&In-Reply-To=%3C20110115151159.GB23639%40sisay.ephaone.org%3E">
<META NAME="robots" CONTENT="index,nofollow">
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<LINK REL="Previous" HREF="002113.html">
<LINK REL="Next" HREF="002125.html">
</HEAD>
<BODY BGCOLOR="#ffffff">
<H1>[Mageia-sysadm] [Mageia-webteam] Forum VM needs</H1>
<B>Michael scherer</B>
<A HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20%5BMageia-webteam%5D%20%20Forum%20VM%20needs&In-Reply-To=%3C20110115151159.GB23639%40sisay.ephaone.org%3E"
TITLE="[Mageia-sysadm] [Mageia-webteam] Forum VM needs">misc at zarb.org
</A><BR>
<I>Sat Jan 15 16:11:59 CET 2011</I>
<P><UL>
<LI>Previous message: <A HREF="002113.html">[Mageia-sysadm] [Mageia-webteam] Forum VM needs
</A></li>
<LI>Next message: <A HREF="002125.html">[Mageia-sysadm] [Mageia-webteam] Forum VM needs
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#2121">[ date ]</a>
<a href="thread.html#2121">[ thread ]</a>
<a href="subject.html#2121">[ subject ]</a>
<a href="author.html#2121">[ author ]</a>
</LI>
</UL>
<HR>
<!--beginarticle-->
<PRE>On Sat, Jan 15, 2011 at 11:46:38AM +0100, Maât wrote:
><i> Le 13/01/2011 13:29, Michael Scherer a écrit :
</I>><i>
</I>><i> ----8<----
</I>><i> > In any case, postgresql to mysql conversion doesn't look doable.
</I>><i> >
</I>><i> It could be done using things like TOS
</I>
Url ?
><i> > But we are not ready, see my answer about gitorious. So here is a
</I>><i> > proposal in 4 steps :
</I>><i> >
</I>><i> > Now :
</I>><i> > - we do a git checkout every 5 minutes ( just need the url, and
</I>><i> > testing )
</I>><i> Ouch
</I>
Why ouch ?
5 minutes is too often, not often enough ?
( this is configurable, as this is based on cron )
I would prefer a pull based approach rather than push, because
1) this is already written
2) this is more secure
But it may not be good for deployment.
><i> >>> Do you need modifications in phpBB sources ?
</I>><i> >>>
</I>><i> >> yes... some coming from (more or less) official patches (called "mods") some coming from ash
</I>><i> >> and i and perhaps other php devs
</I>><i> > /me close eyes when reading "(more of less) official patches".
</I>><i> >
</I>><i> That's the way phpBB people deals with "mods" : authors (not phpBB Team) publish them on the mods
</I>><i> dedicated forum, and you are free to use (or not) them without warranty at all some are widely
</I>><i> used and well known to be stable...
</I>><i>
</I>><i> That's why integration and testing stages are so important
</I>
Because software distribution is crappy ?
That's indeed a good reason ( now, do not be asthonished if we joke on php... )
><i> >>> If that's only for configuration files, we can host them on puppet svn
</I>><i> >>> and deploy them with puppet.
</I>><i> >>>
</I>><i> >> if you want to play with puppet for production and having us not touching it with our dirty hands (^^) i'm perfectly ok with
</I>><i> >> that... but i neeed a integration and testing forum with cascaded by git cloning
</I>><i> >> (and i need to sync database of test from production to simulate version migration then cancel and replay as much a i need)
</I>><i> > Could we do it with a master/slave replication without much trouble ?
</I>><i> > ( and possibly, one that would automatically recreate the db once it is
</I>><i> > dropped )
</I>><i> >
</I>><i> > Or we can do snapshot using lvm, but I think this can be quite fragile.
</I>><i> >
</I>><i> Nope... master/slave replication will not fit my needs : i need 2 separate bases. The production i won't play
</I>><i> with it.
</I>><i>
</I>><i> For testing : once i updated the code to the new version there can be SQL modifications : new tables, alter tables,
</I>><i> insert or update for rows...
</I>><i>
</I>><i> This will be triggered from admin board of phpBB... with a master/slave this would be forbidden or would brake
</I>><i> replication
</I>
That's the idea, stop the replication for testing purposes. Hence my note about recreating it once we
drop the slave.
We start with a clean db, we replicate.
Once we want to test the upgrade, we stop replication, we test.
We drop the db, we resync if needed
Once we finished the test, we drop the tables, and we restart the synchronisation.
><i> But we could perfectly use the last (nightly ,) production backup to populate the test base when i need to go
</I>><i> back to "clean production state"
</I>
This requires use to do backup, and so have at least a backup process
But we can also do it. I just think that replication would be less heavy
on IO than dump/reload when needed ( and would be easier to automate ).
I wonder if we could distribute sql dump of the forum on mirror ( like we could for bugs ). I see
no obvious use for that at the moment, but liberating data can lead to unexpected usages, and would
be a interesting move ( or a at least, a interesting thought experiment, since there is private messages
involved, so this would requires cleaning )
--
Michael Scherer
</PRE>
<!--endarticle-->
<HR>
<P><UL>
<!--threads-->
<LI>Previous message: <A HREF="002113.html">[Mageia-sysadm] [Mageia-webteam] Forum VM needs
</A></li>
<LI>Next message: <A HREF="002125.html">[Mageia-sysadm] [Mageia-webteam] Forum VM needs
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#2121">[ date ]</a>
<a href="thread.html#2121">[ thread ]</a>
<a href="subject.html#2121">[ subject ]</a>
<a href="author.html#2121">[ 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>
|
