openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From imacat <ima...@mail.imacat.idv.tw>
Subject Re: Service Maintenance for pootle and AOO wiki
Date Tue, 22 Oct 2013 10:47:21 GMT
On 2013/10/22 16:10, imacat said:
> On 2013/10/22 15:42, janI said:
>> On 22 October 2013 03:02, imacat <imacat@mail.imacat.idv.tw> wrote:
>>> On 2013/10/22 02:37, janI said:
>>>> On 21 October 2013 18:39, Tony Stevenson <pctony@apache.org> wrote:
>>>>> Andrea Pescetti wrote on Mon, Oct 21, 2013 at 06:27:50PM +0200:
>>>>>> Tony Stevenson wrote:
>>>>>>> Andrea Pescetti wrote on Mon, Oct 21, 2013 at 04:52:14PM +0200:
>>>> Imacat (admin) has responded to my question if help is wanted, answer was
>>>> that it would be be fine if infra does it (like me) and offered to help.
>>>>
>>>> If we think along these lines, my plan would be the following:
>>>
>>>     You can ignore me if my help is not needed.  But, still,
>>
>> I would never ignore a helping hand, and especially not a qualifed one as
>> yours.
> 
>     Ah...  That is totally unnecessary. ^^;
> 
>>>> 1) Thursday evening (16-22 UTC), I wil combine the single forum databases
>>>> into the EN database. This will mean short breaks on the single forum,
>>>> about 10min each (to copy the tables).
>>>>  If time permits, I will convert the FULLTEXT back to MyIsam.
>>>     That's 0-6 UTC+8 here.  I have works on Friday.  I can stay up to at
>>> most 19 UTC (3 UTC+8), but not after that.
>>
>> ok, lets do this in another way, please select 2 forums (that have the
>> lowest usage) from the db list below:
>>
>> | en                 |
>> | es                 |
>> | fr                 |
>> | hu                 |
>> | it                 |
>> | ja                 |
>> | nl                 |
>> | pl                 |
>> | vi                 |
>> | zh                 |
>> +--------------------+
>>
>> Then I will move tables in these 2 and convert the FULLTEXT tables, as soon
>> as I hear from you, and then you can test. Please give me a UTC time, where
>> you can test (today/tomorrow), then I do the changes just before that time.
> 
>     Ah... it's embarrassing that, I will travel to another city later to
> deliver an OpenOffice macro class for two days, and will return before
> Thursday evening (16-22 UTC). ^^;  That's the earliest time I'm
> available this week.
> 
>     And, currently, VI has the lowest traffic.  But we have to notify
> Phan first.

    But I suppose this is the time "back up" or "cover" is for. :p  You
may ask RGB or Phan for help on this.

>> If it works with these 2 forums, I feel more secure with the rest, and
>> maybe Ricardo can do a check on them since he is in the same TZ.
>>
>>
>>
>>>     And what do you mean by "combining short forum databases into the EN
>>> databases"?  So we will only have EN database in the future?
>>>
>>
>> Yes, and it will problaly be called "forumsaoodb".
>>
>> Remark, this is not a problem because all tables (in use) have the naming
>> standard:
>>      phpbb_<forum>_<table>
>>
>> if you look e.g. in IT, you will see
>> | phpbb_it_sessions_keys        |
>> | phpbb_it_sitelist             |
>> | phpbb_it_smilies              |
>>
>>
>> There are 2 databases I dont understand at the moment:
>>
>> | ps_helper          |
>> | test               |
>>
>> any ideas ?
> 
>     The "ps_helper" database:
> 
> https://www.google.com.tw/#q=ps_helper+mysql
> 
>     The "test" database can be safely ignored.  It's a standard MySQL
> database for testing purpose.  When installing Perl DBD::mysql library,
> we need a database to test if DBD::mysql is working.  There should
> always a database named "test" (although some DB admins prefer to remove
> it), but you do not need to bother with its contents.
> 
>>
>>
>>>
>>>> 2) Friday morning (8-11 UTC) I will convert tables. This happens online,
>>>> and only means slow system while I do it.
>>>
>>>     That is 16-19 UTC+8.  Normally I would be stuck in the traffic going
>>> home at this time on Fridays, but I could stay in the office if necessary.
>>>
>>
>>  see above.
>>
>>
>>>> 3) Friday afternoon (15 UTC, depending on pctony), we can take the forums
>>>> down for approx 2hours to move the databases.
>>>
>>>     That would be perfect for me.
>>>
>> it would for me too, but pctony has to go to hospital with his kid, so we
>> try to see if we can do it thursday (24/10).
>>
>> I would really apriciate your help with the first 2 forums, to make a more
>> thorough test. And then hope that ricardo could do a smoke test on the
>> others.
>>
>> This is of course a service that infra provides so if you want it
>> postponed, we will have to find  a way.
>>
>>
>>>
>>>     And also, please add the date (10/24, 10/25).  It's confusing to
>>> guess if Friday is 10/25 or 11/1.  (And normally I would bet on 11/1 as
>>> 10/25 is very close.)
>>>
>>
>> Sorry about that, good idea.
>>
>> rgds
>> jan I.
>>
>>>
>>>>
>>>> In order to finalize the database changes Thursday and move friday, we
>>> need
>>>> someone with access to all forums to help with the test.
>>>>
>>>> Could this be an acceptable plan ?  The time is needed, but if preferred
>>> I
>>>> can do it friday or saturday evening instead (depending on pctony).
>>>>
>>>> rgds
>>>> jan I.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> This is now impacting other services and needs to be resolved ASAP,
>>> please.
>>>>>
>>>>> FWIW the total downtime was 11 minutes.  Which is pretty fast
>>>>> considering all the changes that had to be incorporated.
>>>>>
>>>>>
>>>>>>
>>>>>> Regards,
>>>>>>   Andrea.
>>>>>
>>>>> --
>>>>> Cheers,
>>>>> Tony
>>>>>
>>>>> ----------------------------------
>>>>> Tony Stevenson
>>>>>
>>>>> tony@pc-tony.com
>>>>> pctony@apache.org
>>>>>
>>>>> http://www.pc-tony.com
>>>>>
>>>>> GPG - 1024D/51047D66
>>>>> ----------------------------------
>>>>>
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
>>>>> For additional commands, e-mail: dev-help@openoffice.apache.org
>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>> Best regards,
>>> imacat ^_*' <imacat@mail.imacat.idv.tw>
>>> PGP Key http://www.imacat.idv.tw/me/pgpkey.asc
>>>
>>> <<Woman's Voice>> News: http://www.wov.idv.tw/
>>> Tavern IMACAT's http://www.imacat.idv.tw/
>>> Woman in FOSS in Taiwan http://wofoss.blogspot.com/
>>> OpenOffice http://www.openoffice.org/
>>> EducOO/OOo4Kids Taiwan http://www.educoo.tw/
>>> Greenfoot Taiwan http://greenfoot.westart.tw/
>>>
>>>
>>
> 
> 


-- 
Best regards,
imacat ^_*' <imacat@mail.imacat.idv.tw>
PGP Key http://www.imacat.idv.tw/me/pgpkey.asc

<<Woman's Voice>> News: http://www.wov.idv.tw/
Tavern IMACAT's http://www.imacat.idv.tw/
Woman in FOSS in Taiwan http://wofoss.blogspot.com/
OpenOffice http://www.openoffice.org/
EducOO/OOo4Kids Taiwan http://www.educoo.tw/
Greenfoot Taiwan http://greenfoot.westart.tw/


Mime
View raw message