Wikitech-l December 2003

wikitech-l@lists.wikimedia.org

84 participants
155 discussions

Opteronically good!
by Daniel Mayer 02 Dec '03

02 Dec '03

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

3 2

Opteronically good!
by Brion Vibber 02 Dec '03

02 Dec '03

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)

4 6

Section editing weirdness
by Hunter Peress 02 Dec '03

02 Dec '03

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/

2 1

links table
by Evan Prodromou 02 Dec '03

02 Dec '03

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

2 2

AW: [Wikitech-l] Opteronically good!
by Dufrenoy, Alexis 02 Dec '03

02 Dec '03

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

3 2

Section editing weirdness
by Arvind Narayanan 02 Dec '03

02 Dec '03

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

2 1

RE: [Wikitech-l] cur and old
by Poor, Edmund W 02 Dec '03

02 Dec '03

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

1 0

Re: [Wikitech-l] Opteronically good!
by Anthere 02 Dec '03

02 Dec '03

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/

1 0

RE: [Wikitech-l] Opteronically good!
by Constans, Camille (C.C.) 02 Dec '03

02 Dec '03

> >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

3 2

cur and old
by Evan Prodromou 02 Dec '03

02 Dec '03

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

2 1

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

Wikitech-l December 2003