It seems to me that the more sane approach is to give
all the machines descriptive names, such as
"Dataserver", "webserver1", and "webserver2". As it
is, all past references to the database server were
named "pliny". Now pliny is going to be a webserver -
this is confusing. It would be much less confusing IMO
if we had stated "database server" all along and just
noted upgrades as an aside when they happen. However,
if total logic is ruled out, then please stabilize on
some names and give each of those names specific
tasks. For example the new name Diderot (or whatever
is chosen) will always be the name of the fastest,
most powerful database server (no matter what specific
hardware it has). The name Pliny will always be used
for webserver 1 and the nameLarousse will always be
used for webserver 2 (both irrespective of what
hardware they have). Adding more machines to the mix
will add more names, but those names should be given
as-yet-unfilled tasks such as database server 2, and
webserver 3, 4, 5... So when we buy our next even more
monstrous database server that would become the new
Diderot and the current machine with that name would
be assigned the new task of database server 2 (in
which case a new name would be needed for it).
That way the name "Diderot" would always refer to the
primary database server.
-- mav
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
Jason's got the new machine installed (thanks!). It's at
130.94.122.204, but it needs a name... Among the previous suggestions
to name machines after were:
http://en.wikipedia.org/wiki/Denis_Diderothttp://en.wikipedia.org/wiki/Mortimer_Adler
Any preference for 'diderot' or 'adler' or something else?
I can import the last backup dump and test it tonight; if all seems
well any objection to moving the database over tomorrow night? (Early
morning UTC on December 3 == evening US December 2.) The databases will
need to be frozen/read-only for the duration of copying, and I'm not
sure how long this will take so I don't want to spring it on everyone
unannounced.
-- brion vibber (brion @ pobox.com)
Just reminding that the difflib3.php (i think thats the file) from phpwiki.sf.net (latest version)
does indeed have an implemention of merging.
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
So, design question: in the links table, why is l_from a string rather
than a cur_id? I'm trying to dig it up, but I can't.
Seems kinda losey -- you can't join cur and links on l_from -- say, to
find what articles link to an article with a given ID. You can get all
the l_from's from links, of course, but then you have to do a query to
cur to get any other information.
~ESP
--
Evan Prodromou <evan(a)wikitravel.org>
Wikitravel - http://www.wikitravel.org/
The free, complete, up-to-date and reliable world-wide travel guide
I posted these on the french Bistro :
-Marie de Vichy-Chamrond , marquise du Deffand
-Marie-Thérèse Rodet
-Julie de Lespinasse
-Claudine Alexandrine Guérin de Tencin
:-)
Traroth
-----Ursprüngliche Nachricht-----
Von: Constans, Camille (C.C.) [mailto:cconsta4@ford.com]
Gesendet: Dienstag, 2. Dezember 2003 08:34
An: 'Wikimedia developers'
Betreff: RE: [Wikitech-l] Opteronically good!
>
>Brion Vibber wrote:
>
>> Jason's got the new machine installed (thanks!). It's at
>> 130.94.122.204, but it needs a name... Among the previous
>suggestions
>> to name machines after were:
>>
>> http://en.wikipedia.org/wiki/Denis_Diderot
>> http://en.wikipedia.org/wiki/Mortimer_Adler
>>
>> Any preference for 'diderot' or 'adler' or something else?
>>
>> I can import the last backup dump and test it tonight; if all seems
>> well any objection to moving the database over tomorrow
>night? (Early
>> morning UTC on December 3 == evening US December 2.) The
>databases will
>> need to be frozen/read-only for the duration of copying, and I'm not
>> sure how long this will take so I don't want to spring it on
>everyone
>> unannounced.
>>
>> -- brion vibber (brion @ pobox.com)
Anthere (and me), would like an encyclopedist woman. I think there is some
on french bistro, but i dont remember the names....
--
Shaihulud
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)Wikipedia.org
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
Hi,
Consider this scenario:
* User A starts to edit section 1 of a page.
* User B starts to edit section 2 of the same page
* User A adds a new section and saves.
What was section 2 earlier should now be section 3,
but user B does't know this.
* User B saves the section they were editing. There is
no edit conflict, but it gets saved as section 2, and
user A's work is lost.
Is this possible, or does the software detect it? I got
some strange results when editing 2 sections of a page
at the same time and I'm guessing that this is what
happened.
Arvind
--
Its all GNU to me
Brion,
If there's a way to refactor the database to incorporate a good
suggestion like Evan's, I hope we will do it. Hint: use "wrapper"
methods for calls from the client to the database.
Ed Poor
Andre...
>I would feel for a non-western name, to underline the
>international
>character of Wikipedia. What about Yongle?
>(http://en.wikipedia.org/wiki/Yongle_Encyclopedia)
Anyone knows the name of a non-western female
encyclopedist ?
Ant
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
>
>Brion Vibber wrote:
>
>> Jason's got the new machine installed (thanks!). It's at
>> 130.94.122.204, but it needs a name... Among the previous
>suggestions
>> to name machines after were:
>>
>> http://en.wikipedia.org/wiki/Denis_Diderot
>> http://en.wikipedia.org/wiki/Mortimer_Adler
>>
>> Any preference for 'diderot' or 'adler' or something else?
>>
>> I can import the last backup dump and test it tonight; if all seems
>> well any objection to moving the database over tomorrow
>night? (Early
>> morning UTC on December 3 == evening US December 2.) The
>databases will
>> need to be frozen/read-only for the duration of copying, and I'm not
>> sure how long this will take so I don't want to spring it on
>everyone
>> unannounced.
>>
>> -- brion vibber (brion @ pobox.com)
Anthere (and me), would like an encyclopedist woman. I think there is some on french bistro, but i dont remember the names....
--
Shaihulud
Man, these tables drive me crazy. Is there a good reason I'm missing
that we don't it like this?
+------------------+ +---------------+
| page | | page_version |
+------------------+ +---------------+
| page_id | ----> | version_id |
| current_version | ----/ | page_id |
+------------------+ | timestamp |
| user |
| ... |
| data |
+---------------+
That way, all your page versions are in one place -- a lot easier to
manage than two tables.
Just some woolgathering as I fight my way through some RFEs...
~ESP
--
Evan Prodromou <evan(a)wikitravel.org>
Wikitravel - http://www.wikitravel.org/
The free, complete, up-to-date and reliable world-wide travel guide