Programmed downtime on forums

Major announcements from the Apache mailing lists

Programmed downtime on forums

Postby RGB » Tue Oct 22, 2013 10:42 pm

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.
There are two types of people: the ones that believe that there are two types of people and the ones that not.

openSUSE with KDE SC / AOO
User avatar
RGB
Volunteer
 
Posts: 1452
Joined: Mon Oct 08, 2007 1:34 am

Re: Programmed downtime on forums

Postby RGB » Thu Oct 24, 2013 10:51 pm

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!
There are two types of people: the ones that believe that there are two types of people and the ones that not.

openSUSE with KDE SC / AOO
User avatar
RGB
Volunteer
 
Posts: 1452
Joined: Mon Oct 08, 2007 1:34 am

Re: Programmed downtime on forums

Postby acknak » Thu Oct 24, 2013 11:29 pm

The forum does seem snappier--nice job!

Thanks again, Jan & RGB.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22603
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Programmed downtime on forums

Postby floris v » Fri Oct 25, 2013 12:24 am

The Dutch NL forum works fast too, good job!
MS Windows 10 - AOO 4.1.3 - LibreOffice 5.2.3.3
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 3940
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands


Return to Announcements

Who is online

Users browsing this forum: No registered users and 1 guest