13 replies to this topic

[Dean]

I'm moving mySQL onto it's own server at some point today; so expect a little bit of downtime whilst the transfer takes place.

[Dean]

Done; the next step will to be move the http part of the site into the same datacentre as the mysql server.

Resolved for now

[Ed Headset]

Dean, on Mar 8 2008, 11:13 PM, said:

Done; the next step will to be move the http part of the site into the same datacentre as the mysql server.

Resolved for now

I was surprised to see a IPS error on the forum, now I know why


Good to see things up and running again!

Edited by Ed Headset, 12 March 2008 - 07:13 PM.

[Dean]

Just in case any one was wondering why they got the DB errors earlier, for some reason we got 600 simultaneous connections that caused the mySQL database sessions table to crash, and took down the mySQL server with it. I've repaired the tables an optimized them now...

Keeping an eye on it

[Dean]

We've just received 549 connections.. wow that's a fair bit of traffic

[Dean]

Ok, well I've decided today is going to be the day for the big re-structure.

Luckily, I won't have to worry about double-posts etc if someone does post whilst I do it all (as the mysql is already transferred).

There will be a little downtime though, and I can't estimate how long it'll be (or at what time).

[Dean]

I apologise for the delay, I've been really busy, so not able to transfer the site into the same datacentre as the mysql server (as some are noticing a site lag).. it's on my list of things to do tonight.

[Ed Headset]

Dean, on Mar 13 2008, 02:30 PM, said:

I apologise for the delay, I've been really busy, so not able to transfer the site into the same datacentre as the mysql server (as some are noticing a site lag).. it's on my list of things to do tonight.

Good luck with it, I do hope things are going well

Maybe you are working on it right now, as I experience a drop down in speed, but it still works!

[Dean]

Optimized my.cnf and seems to be much faster

[Ralph]

Dean, on Mar 14 2008, 05:03 AM, said:

Optimized my.cnf and seems to be much faster

I'm seeing a monumental improvement in performance, Dean... Great job...

[Ed Headset]

Dean, on Mar 14 2008, 10:03 AM, said:

Optimized my.cnf and seems to be much faster

Yep, this is much better

[Dean]

I'm going to be taking both mysql and www traffic offline sometime within the next couple of hours to perform a 1st backup onto my machine here.

[Dean]

mySQL Backup has completed ... www up next

Over the next few hours, you may experience some "quirkiness"; I'm going to be performing some maintenance to iron out the bugs since the migration - then perform the backup.

Once it's all complete, I'll post about the changes I've made; and how they benefit the Etomite CMS

[Dean]

I've only got one more issue to iron out, and that's with the bugtracker - somethings gone screwy :/