On 22 October 2013 03:02, imacat <ima...@mail.imacat.idv.tw> wrote:
> 於 2013年10月22日 02:37, janI 提到:
> > 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:
>
> 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.
>
> > 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.
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 ?
>
> > 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
> >>
> >> 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
> >>
> >>
> >
>
>
> --
> Best regards,
> imacat ^_*' <ima...@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/
>
>
