no more downtime ?

Duiske

oleras wrote: »

Can the site be made read only while the backup happens ?

Good question. I noticed this was done for a time during the recent upgrade.

regi

regi wrote: »

I didn't set the backup script right. Don't worry, you'll get the usual go-to-bed reminder, but I might tweak the time a bit!

What time do you plan to set it for, the cuckoos have been freaked out over the weekend

http://boards.ie/vbulletin/showthread.php?t=2055036501

seamus

Duiske_Lad wrote: »

Good question. I noticed this was done for a time during the recent upgrade.

I think this is an option which is set in vBulletin - a box which is ticked.

Theoretically as part of the backup job, you could create a script which ticked this box, then kicked off the backup job, then unticked the box.

But if the box got ticked and then something went "weh", boards.ie is left in read-only mod until an admin has a chance to log in.

At least with the backup job, you know boards is still going to work afterwards.

DeVore

"Surely".... the most dangerous word in IT.

DeV.

stevenmu

seamus wrote: »

But if the box got ticked and then something went "weh", boards.ie is left in read-only mod until an admin has a chance to log in.

At least with the backup job, you know boards is still going to work afterwards.

Wouldn't the alternative to this be something going "weh" and the whole site staying down ? Just guessing but I'd have thought that anything which would prevent the script bringing the site out of read-only after a backup, would also prevent it coming back on line if it was down for a the backup.

Shiminay

Lads and ladies, you're forgetting something *very* important...

The admins and some of the other people involved in the "physical" side of boards (i.e. the hardware setup and hosting all that good stuff) are professionals at this very job. Boards is one of many websites maintained by these professionals and if that level of service is good enough for the people who pay their bloody hard earned wages, then it should certainly be good enough for a community who for the most part thrives on the service they've given us.

There are many many technical users of boards who also specialise in these services and it's the kind of thing where everyone has an idea of what might tweak things here or there, but there isn't always an exact science to the technology behind these things (it's not an area I've done any real work in so I wouldn't even have a clue what to suggest).

Rest assured, we're in the best possible hands - I mean who could worry when people like Asok have their finger on the proverbial big red button... :eek:

seamus

stevenmu wrote: »

Wouldn't the alternative to this be something going "weh" and the whole site staying down ? Just guessing but I'd have thought that anything which would prevent the script bringing the site out of read-only after a backup, would also prevent it coming back on line if it was down for a the backup.

I don't know what the script does at the moment
Making boards read-only would involved firing an SQL query at the database server before the backup, and then firing the opposite query at the database afterwards.
I'm assuming that the current script stops the apache service before the backup, and starts it again after.

It might be just me, but I put more faith in the latter command working 99.999% of the time. I would almost expect the former to fail once every ten times.

It probably is just me.

po0k

Kharn wrote: »

Rest assured, we're in the best possible hands - I mean who could worry when people like Asok have their finger on the proverbial big red button... :eek:

The Children

green123

i haven't noticed any downtime for backups recently.
so what's the story now ?
have you finally came around to my way of thinking ?

Kinetic^

All the mods and admin sat around a giant round table just to discuss how we could make your experience on boards a lot more pleasant. It was down to a mod going around to your house and giving you a massage during this time or stopping the downtime. With a result of 794 to 1 (Terry),it was decided that the scheduled downtime each morning would be a thing of the past. Bravo.

Terry

I give good massages. I just wanted to help.

orestes

I haven't slept since the backup went away

Overheal

seamus wrote: »

1. Set up the old server as a mirror. What this does is have the second server watching and copying everything the live server does. A bit like a kid copying his mate's test in school. The great thing about this is that the mirror is always only a few minutes behind the live system. The bad thing about this is that it's not a "backup" solution. It requires regular monitoring and administration to ensure that it's working properly. It's really only for scenarios where you require high-availability and a hot-swappable database server. Anyone using this method on any database, still maintains regular backups apart from the replication cluster.
The other great thing about this is, provided you know the mirror is working, then you can do your dumps from the mirror server, leaving the live server free to go on working.

2. Use differential backups instead of full backups. This kind of scenario usually means that a full backup (all data is backed up) is performed once a week, say on a Sunday. Then every evening after that, only the changed data is backed up. This means that with the exception of the Sunday night backup, each night's backup should be pretty quick. I'm not sure if MySQL provides this though.
The main problem with this is the time it takes to do a restore. If the database dies on Friday afternoon (for example), you need to restore the Sunday night backup, then the monday night one, then the tuesday one, and so on. You'd have to do about seven individual restores to get you back to a working situation. If you do a full backup nightly, then you only need to do two (database & TLog) to get you back to a working state. With admin time at a premium, this would be a pain.

These are only the two most obvious I can see. I'm sure King Dan knows some more funky trickery to perform superfast live backups.

I'm a server noob, relying on google.... but what about using the old server as a redundant failover node?

http://en.wikipedia.org/wiki/Two-node_cluster

cHaTbOx

orestes wrote: »

I haven't slept since the backup went away

I know it has fooked me up somewhat.

Gordon

zombie thread

DeVore

green123 wrote: »

i haven't noticed any downtime for backups recently.
so what's the story now ?
have you finally came around to my way of thinking ?

how many Green123's does it take to change a light bulb?

One. He holds the light bulb up, and the world revolves around him.

Ross brought a second replicated database server online and did majic. One effect is a removal of the 4am offliness. Its been that way for a several weeks.

DeV.