On 2013/10/22 16:10, imacat said: > On 2013/10/22 15:42, janI said: >> On 22 October 2013 03:02, imacat <ima...@mail.imacat.idv.tw> wrote: >>> On 2013/10/22 02:37, janI said: >>>> 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: >>>> 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 >>>>> >>>>> 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/ >>> >>> >> > > -- 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/
signature.asc
Description: OpenPGP digital signature