On 21 October 2013 18:39, Tony Stevenson <pct...@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: > > >>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: 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. 2) Friday morning (8-11 UTC) I will convert tables. This happens online, and only means slow system while I do it. 3) Friday afternoon (15 UTC, depending on pctony), we can take the forums down for approx 2hours to move the databases. 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 > > t...@pc-tony.com > pct...@apache.org > > http://www.pc-tony.com > > GPG - 1024D/51047D66 > ---------------------------------- > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org > For additional commands, e-mail: dev-h...@openoffice.apache.org > >
