You are either not logged in or not registered with our community. Click here to register.
June 19, 2018, 11:40:35 AM

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length

Click here if you are having problems.
Default Wide Screen Beige Lilac Rainbow Black & Blue October Send us your theme!

Wiki Blogs Dicebot

Author Topic: General Warning and Future Notes  (Read 712 times)

0 Members and 1 Guest are viewing this topic.

Offline VekseidTopic starter

General Warning and Future Notes
« on: August 30, 2010, 05:05:50 PM »
I'm going to be putting up a big scary warning on Blue Moon and Elliquiy, pointing to this and its mirror thread.

Basic gist is, although backups are run off of the slave server (twice a day, at 1 AM and 1 PM CST/CDT), database optimization can't be - it needs to be done on the Master, and when it gets done it is going to take its sweet, sweet time as it rebuilds each and every table. On Elliquiy, I was forced to move them from once a day to once a week, and they eventually began taking half an hour on E, so they are now once a month.

This will hit the databases in serial fashion, so it will bring down Blue Moon, then E, etc. Other sites on this server won't even notice as their database gets run over in a few seconds. But Blue Moon might see some timeouts, so don't be too alarmed if it happens, save your posts beforehand. Though after the nightmare that was phpBB on the VPS we had before, this should barely register.

On Elliquiy, this will be rather disruptive, as E members are familiar with. Only now it's once a month instead of eight times a week. Let's here it for slaves! : )

The optimization is being run at 5 AM CST/CDT on the first of each month. This equates to
6 AM Eastern
4 AM Mountain
3 AM Pacific

And around Noon for Europe, depending on your specific timezone. CDT (Daylight time) is UTC-5, CST is UTC-6.

For September, I am going to be finishing up automating various processes on Elliquiy, then touching up on some things for Blue Moon folks and clients. After that, I am going to be focusing most of my attention on The Project, which should lead to much awesomeness for both E and Blue Moon in 2011.

For Blue Moon, if someone knows css fairly well, they can fix a number of issues here themselves and I can focus on more technical things, which would be fairly awesome and much appreciated (by myself and the members here, I'm sure). So if someone is good with style sheets, and is active on Blue Moon and wants to help out, let me know and we'll see what can be worked out : )
« Last Edit: September 02, 2010, 01:43:55 PM by Vekseid »

Offline VekseidTopic starter

Re: General Warning and Future Notes
« Reply #1 on: September 01, 2010, 06:52:53 AM »
Posting should work now?

Offline Malina

Re: General Warning and Future Notes
« Reply #2 on: September 01, 2010, 07:23:47 AM »
Posting should work now?

Let's see - yup, it does, thanks for all the good work and the updates, Veks!  :D

Offline VekseidTopic starter

Re: General Warning and Future Notes
« Reply #3 on: September 01, 2010, 04:36:25 PM »
Nweh. It saved 300 megabytes.

I might have it skip the messages table. hrm.