You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by janI <ja...@apache.org> on 2013/10/22 16:09:07 UTC
[announcement] Downtime on forum.o.o
Hi.
The database(s) behind forum.o.o need to be changed and moved to a new fast
central sql server.
In order to test the changes without disturbing anyone, I have created a
forum "test" where all needed changes will be done during the coming days.
Thursday 22/10 at 1500 UTC, we will begin moving the each single forum
database into the EN database (with separate tables for each forum), and
convert FULLTEXT tables back to myIsam.
This process means 10-30 minutes downtime for each forum.
At 1800 UTC, we will stop all forums for about 2hours while moving the db
to the central sql. We will try to keep the downtime as small as possible.
It is appreciated, if admins test their forums after 2000 UTC. I will be
available on #asfinfra and on mail, to help with any problems.
Please advice forum users.
Taking the experience from translate.a.o and wiki.o.o a better performance
and higher stability can be expected.
on behalf of infra
jan I.
Re: [announcement] Downtime on forum.o.o
Posted by imacat <im...@mail.imacat.idv.tw>.
On 2013/10/25 05:17, Ricardo Berlasso said:
> 2013/10/24 janI <ja...@apache.org>
>
>> Hi
>>
>> I am pleased to announce that all forum dbs are now moved to the central
>> sql server.
>>
>> The move took about 40 minutes.
>>
>> We hope you will all experience a better performance, however the php2bb
>> could really do with a optimization (especially with sqlconnections).
> Thanks, Jan!
> Everything is working great!
Thank you for the hard work. I returned home a little later.
Although I was on-line and seeing your work, I was actually unpacking
and cleaning from my trip. Sorry I cannot actually help. The websites
work fine now.
Besides, your MySQL clean-up caused some problems on the server dpkg
package system. I fixed them last night. It works fine now.
--
Best regards,
imacat ^_*' <im...@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/
Re: [announcement] Downtime on forum.o.o
Posted by Ricardo Berlasso <rg...@gmail.com>.
2013/10/24 janI <ja...@apache.org>
> Hi
>
> I am pleased to announce that all forum dbs are now moved to the central
> sql server.
>
> The move took about 40 minutes.
>
> We hope you will all experience a better performance, however the php2bb
> could really do with a optimization (especially with sqlconnections).
>
Thanks, Jan!
Everything is working great!
Regards,
Ricardo
>
> on behalf of infra
> jan I.
>
>
>
> On 22 October 2013 20:53, janI <ja...@apache.org> wrote:
>
> > Hi.
> >
> >
> >
> >
> > On 22 October 2013 16:09, janI <ja...@apache.org> wrote:
> >
> >> Hi.
> >>
> >> The database(s) behind forum.o.o need to be changed and moved to a new
> >> fast central sql server.
> >>
> >> In order to test the changes without disturbing anyone, I have created a
> >> forum "test" where all needed changes will be done during the coming
> days.
> >>
> >> Thursday 22/10 at 1500 UTC, we will begin moving the each single forum
> >> database into the EN database (with separate tables for each forum), and
> >> convert FULLTEXT tables back to myIsam.
> >>
> >
> > Typo sorry for the confusion, I mean Thursday 24/10. We do want to give
> > plenty of warning this time :-)
> >
> > thx marcus for catching it.
> >
> > rgds
> > jan I.
> >
> >
> >> This process means 10-30 minutes downtime for each forum.
> >>
> >> At 1800 UTC, we will stop all forums for about 2hours while moving the
> db
> >> to the central sql. We will try to keep the downtime as small as
> possible.
> >>
> >> It is appreciated, if admins test their forums after 2000 UTC. I will be
> >> available on #asfinfra and on mail, to help with any problems.
> >>
> >> Please advice forum users.
> >>
> >> Taking the experience from translate.a.o and wiki.o.o a better
> >> performance and higher stability can be expected.
> >>
> >> on behalf of infra
> >> jan I.
> >>
> >>
> >
>
Re: [announcement] Downtime on forum.o.o
Posted by janI <ja...@apache.org>.
Hi
I am pleased to announce that all forum dbs are now moved to the central
sql server.
The move took about 40 minutes.
We hope you will all experience a better performance, however the php2bb
could really do with a optimization (especially with sqlconnections).
on behalf of infra
jan I.
On 22 October 2013 20:53, janI <ja...@apache.org> wrote:
> Hi.
>
>
>
>
> On 22 October 2013 16:09, janI <ja...@apache.org> wrote:
>
>> Hi.
>>
>> The database(s) behind forum.o.o need to be changed and moved to a new
>> fast central sql server.
>>
>> In order to test the changes without disturbing anyone, I have created a
>> forum "test" where all needed changes will be done during the coming days.
>>
>> Thursday 22/10 at 1500 UTC, we will begin moving the each single forum
>> database into the EN database (with separate tables for each forum), and
>> convert FULLTEXT tables back to myIsam.
>>
>
> Typo sorry for the confusion, I mean Thursday 24/10. We do want to give
> plenty of warning this time :-)
>
> thx marcus for catching it.
>
> rgds
> jan I.
>
>
>> This process means 10-30 minutes downtime for each forum.
>>
>> At 1800 UTC, we will stop all forums for about 2hours while moving the db
>> to the central sql. We will try to keep the downtime as small as possible.
>>
>> It is appreciated, if admins test their forums after 2000 UTC. I will be
>> available on #asfinfra and on mail, to help with any problems.
>>
>> Please advice forum users.
>>
>> Taking the experience from translate.a.o and wiki.o.o a better
>> performance and higher stability can be expected.
>>
>> on behalf of infra
>> jan I.
>>
>>
>
Re: [announcement] Downtime on forum.o.o
Posted by janI <ja...@apache.org>.
Hi.
On 22 October 2013 16:09, janI <ja...@apache.org> wrote:
> Hi.
>
> The database(s) behind forum.o.o need to be changed and moved to a new
> fast central sql server.
>
> In order to test the changes without disturbing anyone, I have created a
> forum "test" where all needed changes will be done during the coming days.
>
> Thursday 22/10 at 1500 UTC, we will begin moving the each single forum
> database into the EN database (with separate tables for each forum), and
> convert FULLTEXT tables back to myIsam.
>
Typo sorry for the confusion, I mean Thursday 24/10. We do want to give
plenty of warning this time :-)
thx marcus for catching it.
rgds
jan I.
> This process means 10-30 minutes downtime for each forum.
>
> At 1800 UTC, we will stop all forums for about 2hours while moving the db
> to the central sql. We will try to keep the downtime as small as possible.
>
> It is appreciated, if admins test their forums after 2000 UTC. I will be
> available on #asfinfra and on mail, to help with any problems.
>
> Please advice forum users.
>
> Taking the experience from translate.a.o and wiki.o.o a better performance
> and higher stability can be expected.
>
> on behalf of infra
> jan I.
>
>