Programmed downtime on forums

Major announcements from the Apache mailing lists
Post Reply
User avatar
RGB
Posts: 1456
Joined: Mon Oct 08, 2007 1:34 am

Programmed downtime on forums

Post 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.
There are two types of people: those who believe that there are two types of people and those who do not.

openSUSE Leap with KDE Plasma / LibreOffice
User avatar
RGB
Posts: 1456
Joined: Mon Oct 08, 2007 1:34 am

Re: Programmed downtime on forums

Post 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!
There are two types of people: those who believe that there are two types of people and those who do not.

openSUSE Leap with KDE Plasma / LibreOffice
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Programmed downtime on forums

Post by acknak »

The forum does seem snappier--nice job!

Thanks again, Jan & RGB.
AOO4/LO5 • Linux • Fedora 23
User avatar
floris v
Volunteer
Posts: 4422
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Programmed downtime on forums

Post by floris v »

The Dutch NL forum works fast too, good job!
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
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
Post Reply