On 2013/10/22 16:10, imacat said: > On 2013/10/22 15:42, janI said: >> On 22 October 2013 03:02, imacat <[email protected]> wrote: >>> On 2013/10/22 02:37, janI said: >>>> On 21 October 2013 18:39, Tony Stevenson <[email protected]> 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
>>>>>
>>>>> [email protected]
>>>>> [email protected]
>>>>>
>>>>> http://www.pc-tony.com
>>>>>
>>>>> GPG - 1024D/51047D66
>>>>> ----------------------------------
>>>>>
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: [email protected]
>>>>> For additional commands, e-mail: [email protected]
>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>> Best regards,
>>> imacat ^_*' <[email protected]>
>>> 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 ^_*' <[email protected]>
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/
signature.asc
Description: OpenPGP digital signature
