Page 1 of 1

Programmed downtime on forums

Posted: Tue Oct 22, 2013 10:42 pm
by RGB
Jan sent this message to the mailing list today:
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 24/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: Programmed downtime on forums

Posted: Thu Oct 24, 2013 10:51 pm
by RGB
New message from Jan:
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).
So far, everything seems faster than before. Well done!

Re: Programmed downtime on forums

Posted: Thu Oct 24, 2013 11:29 pm
by acknak
The forum does seem snappier--nice job!

Thanks again, Jan & RGB.

Re: Programmed downtime on forums

Posted: Fri Oct 25, 2013 12:24 am
by floris v
The Dutch NL forum works fast too, good job!