Should Habbox move database backups to Amazon RDS?

Printable View

Show 40 post(s) from this thread on one page

05-06-2014, 10:59 PM
Chippiewill

Should Habbox move database backups to Amazon RDS?

Vote yes.
05-06-2014, 11:02 PM
xxMATTGxx

Even if the majority of the forum vote yes, it's not a decision the community can have a decision in. As at the end of the day it's the owners of Habbox who will have to pay for this. I'm not saying we shouldn't but I wouldn't get your hopes up.
05-06-2014, 11:02 PM
Chippiewill

$2 p/m isn't unreasonable.
05-06-2014, 11:03 PM
xxMATTGxx

Quote:

Originally Posted by Chippiewill

$2 p/m isn't unreasonable.

I never said it wasn't.
05-06-2014, 11:04 PM
lemons

Potato
05-06-2014, 11:13 PM
myles

i votesd yes because it seems sensible
05-06-2014, 11:16 PM
Kyle

can you explain for people that aren't experts like you and I what the benefits would be
05-06-2014, 11:19 PM
Chippiewill

Quote:

Originally Posted by Kyle

can you explain for people that aren't experts like you and I what the benefits would be

We would have a slave database running on Amazon's AWS, it would make a copy of Habbox's mysql server in real-time, on top of that daily backups would be made of the server from the AWS end. The result being that if the database becomes ****** on the Habbox server like it has now just done twice in a month, then there would be a perfect drop-in backup.
05-06-2014, 11:28 PM
FlyingJesus

I voted no because I'm a rebel, also like Matt said these sort of things shouldn't be democratic
05-06-2014, 11:33 PM
Kyle

Quote:

Originally Posted by Chippiewill

We would have a slave database running on Amazon's AWS, it would make a copy of Habbox's mysql server in real-time, on top of that daily backups would be made of the server from the AWS end. The result being that if the database becomes ****** on the Habbox server like it has now just done twice in a month, then there would be a perfect drop-in backup.

ok and what are the possible cons/reasons given for not doing it
05-06-2014, 11:35 PM
Chippiewill

Quote:

Originally Posted by Kyle

ok and what are the possible cons/reasons given for not doing it

Pros:
Foolproof Backups that are actually simpler than the current system

Cons:
Costs $2 per month
05-06-2014, 11:38 PM
Kyle

ok that settles it for me.

voted potato
05-06-2014, 11:48 PM
Storking

potato
05-06-2014, 11:51 PM
sex

potato cause irish
06-06-2014, 02:32 AM
iBlueBox

what type of potato is it before i make a decision?
06-06-2014, 06:57 AM
e5

Quote:

Originally Posted by Kyle

ok and what are the possible cons/reasons given for not doing it

Dunno what I'm voting for but yes
06-06-2014, 07:48 AM
lRhyss

Quote:

Originally Posted by iBlueBox

what type of potato is it before i make a decision?

Estima
06-06-2014, 07:54 AM
xxMATTGxx

I think the potato is the better option here
06-06-2014, 09:10 AM
Kyle

Quote:

Originally Posted by xxMATTGxx

I think the potato is the better option here

good job habbox seems to be hosted on a potato lately then. everybody's happy.
06-06-2014, 02:01 PM
Storking

hope it's a jersey royal
06-06-2014, 04:43 PM
Mr-Trainor

Quote:

Originally Posted by Chippiewill

Pros:
Foolproof Backups that are actually simpler than the current system

Cons:
Costs $2 per month

From how you've described it, it seems like a suitable solution to go for. But what's the actual difference (including cost) between that and what Habbox uses at the moment :P?
06-06-2014, 04:45 PM
Chippiewill

Currently Habbox performs a database dump every day at 2AM GMT (Or thereabouts) using Xtrabackup, this is then backed up somewhere remotely (Though I'm not actually sure where). Current backup cost is whatever the remote storage costs. Downside being the backup is performed only once a day and more prone to failure / corruption.
06-06-2014, 07:03 PM
Chippiewill

Forum DB just broke.. again
06-06-2014, 07:06 PM
xxMATTGxx

Quote:

Originally Posted by Chippiewill

Forum DB just broke.. again

Yes we know.
06-06-2014, 07:06 PM
Chippiewill

Just making my point patently clear.
06-06-2014, 07:07 PM
xxMATTGxx

Quote:

Originally Posted by Chippiewill

Just making my point patently clear.

Yes but it doesn't help when the server itself also has an issue and reboots either which causes all of these problems in the first place.
06-06-2014, 07:08 PM
Recursion

And moving to RDS will solve none of the current issues at hand.
06-06-2014, 07:08 PM
xxMATTGxx

Quote:

Originally Posted by Recursion

And moving to RDS will solve none of the current issues at hand.

Oh snap.
06-06-2014, 07:12 PM
GoldenMerc

XenForo is the way forward, pay a guy to fix the DB up. Then move acrossssss
06-06-2014, 07:13 PM
xxMATTGxx

Quote:

Originally Posted by GoldenMerc

XenForo is the way forward, pay a guy to fix the DB up. Then move acrossssss

Nothing to do with vBulletin...
06-06-2014, 07:14 PM
Chippiewill

Quote:

Originally Posted by Recursion

And moving to RDS will solve none of the current issues at hand.

RDS would allow us to ignore the current issues at hand.
06-06-2014, 07:17 PM
FlyingJesus

Move to Geocities
06-06-2014, 07:17 PM
GoldenMerc

But why is Habbox's DB so broken? I mean theres boards out there with hundreds of thousands of members. Why is Habbox's so unreliable?
06-06-2014, 07:18 PM
Chippiewill

Quote:

Originally Posted by GoldenMerc

But why is Habbox's DB so broken? I mean theres boards out there with hundreds of thousands of members. Why is Habbox's so unreliable?

Recursion and I both think its a hardware issue that's corrupted the databases.
06-06-2014, 07:28 PM
Recursion

Quote:

Originally Posted by GoldenMerc

But why is Habbox's DB so broken? I mean theres boards out there with hundreds of thousands of members. Why is Habbox's so unreliable?

Because there's a hardware fault SOMEWHERE that means when the server dies it corrupts any current databases transactions. Luckily the forum hasn't been irrecoverably hit yet.

Unfortunately it means whilst some of the tables are broken we can't run our automated backups.
06-06-2014, 07:32 PM
wordofwisdom

go back to amazon i'll even buy the ******* hosting monthly
06-06-2014, 07:34 PM
Recursion

Quote:

Originally Posted by wordofwisdom

go back to amazon i'll even buy the ******* hosting monthly

We've never been on Amazon...
06-06-2014, 07:39 PM
GoldenMerc

Quote:

Originally Posted by Chippiewill

Recursion and I both think its a hardware issue that's corrupted the databases.

Quote:

Originally Posted by Recursion

Because there's a hardware fault SOMEWHERE that means when the server dies it corrupts any current databases transactions. Luckily the forum hasn't been irrecoverably hit yet.

Unfortunately it means whilst some of the tables are broken we can't run our automated backups.

So if its hardware, Why not try run a mirror copy of Habbox on another server, See if it shows the same results?
OR
Has the hardware damaged the database?

Quote:

Originally Posted by wordofwisdom

go back to amazon i'll even buy the ******* hosting monthly

What the hell... Atleast try stay ontopic, Didn't actually know Amazon did web hosting;
http://aws.amazon.com/websites/

Quote:

Originally Posted by Recursion

We've never been on Amazon...
06-06-2014, 07:40 PM
Chippiewill

Quote:

Originally Posted by GoldenMerc

So if its hardware, Why not try run a mirror copy of Habbox on another server, See if it shows the same results?
OR
Has the hardware damaged the database?

......:

Quote:

Recursion and I both think its a hardware issue that's corrupted the databases.
06-06-2014, 07:41 PM
scottish

Why is the server dying in the first place that causes the subsequent corruption..

There's quite a few issues that need to be resolved it seems..

Show 40 post(s) from this thread on one page