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