Re: [announcement] Downtime on forum.o.o

2013-10-25 Thread imacat
On 2013/10/25 05:17, Ricardo Berlasso said:
 2013/10/24 janI j...@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 ^_*' 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


Re: [announcement] Downtime on forum.o.o

2013-10-24 Thread janI
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 j...@apache.org wrote:

 Hi.




 On 22 October 2013 16:09, janI j...@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

2013-10-24 Thread Ricardo Berlasso
2013/10/24 janI j...@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 j...@apache.org wrote:

  Hi.
 
 
 
 
  On 22 October 2013 16:09, janI j...@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.
 
 
 



[announcement] Downtime on forum.o.o

2013-10-22 Thread janI
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.