於 2013年10月22日 02:37, janI 提到: > 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: >>>>> Please tell us when the migration is complete so that we can remove >>>>> the warning. >>>> The service is back. IMO it also quicker. Immediate difference is that >>>> Wiki VM is only consuming 500 MB of RAM now, before it was using 2.8GB. >>> >>> OK, thank you! It seems that in the end interruption of service was >>> minimal. I've removed the note from the home page. Of course, for >>> the next maintenance operations, including the forum, please give us >>> some more time to inform users. >> >> Of course we will, in fact we gave you the best we could today given the >> circumstances we found ourselved in. >> >> The forum move will need to have as many tables as possible converted >> from ISAM to inno. This is critical, as we only run MySQL 5.5 and will >> not be install 5.6 anytime soon, as a result all fields that require >> full text search enabling need to keep that table in ISAM. >> >> JanIV did this already for other DBs and he should be consulted on how >> to do this. It is likely this will be a many hour operation and is a >> pre-requisite. I dont wan't to force a date on the community to have >> this done by, but we need to action this ASAP. To prevent further issues >> to other VMs on the same host as forums. >> >> Can I please ask that if we do not hear any offers of support to help us >> convert these tables by Weds this week that Infra will set a date (with n >> days notice) and do the work ourselves. >> > > 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,
> 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.
And what do you mean by "combining short forum databases into the EN
databases"? So we will only have EN database in the future?
> 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.
> 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.
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.)
>
> 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/
signature.asc
Description: OpenPGP digital signature
