Forums | Hello Guest, Login or Register | > > L4Y Files: No longer here! < <
  Levels-4-You : Lounge : L4Y's host... [Forum Rules]  


Back to Forum Thread List

Beatonator    Posted 6th Mar 2012 11:18am
Post 3594 / 3716
... is rubbish!

What happened this morning? Your DB team need to really do some work.
Trying to find old players. Anyone about? Drop me a PM or reply to this thread:
>Link< (or head over to RFrun.net's comment section!)  
 
Garner    Posted 6th Mar 2012 12:02pm
Post 4100 / 4125
Oh of course... we'll get the same failover page that our clients see when the brown stuff hits the whirly thing.

Primary database suffered some sort of hard failure, it just went offline - corrupting data in the process.

We operate a master-slave system, master used for read/writes, slave used for reads only. It was the master that failed however so system could only read data out of the DB. We took the decision to purposely take the webservers out of the loadbalancer and stop users hitting a 'read only' service whilst the master was sorted out.

Currently running on just the master as the slave is catching up still. We've been considering new DB setups for a while - this will probably accelerate decision making!
"Science is this extraordinary transnational, transcultural, trans-everything language which is the only way to discover Truth and its regrettable that billions are still stuck in the Middle Ages believing the crap propagated by Popes and priests..."
- Peter Atkins  
 
Beatonator    Posted 6th Mar 2012 12:32pm
Post 3595 / 3716
Haha.

I guessed there was a major DB issue.

I like the idea of Master/Slave set up. Seems better than ours here.

We have Mirrors. One principal mirrored. I think the principal databases are distributed across the 2 though.

Is it your job to look after them then?
Trying to find old players. Anyone about? Drop me a PM or reply to this thread:
>Link< (or head over to RFrun.net's comment section!)  
 
Garner    Posted 6th Mar 2012 2:20pm
Post 4101 / 4125
Anything written to the master is also done on the slave, it is mirrored. The problem is that because its master-slave and not master-master, you cannot write to the slave - it'll break replication and generally cause really bad things.

My job is to write the code that runs on them and manage those that look after the DB's (and all the servers in general).
"Science is this extraordinary transnational, transcultural, trans-everything language which is the only way to discover Truth and its regrettable that billions are still stuck in the Middle Ages believing the crap propagated by Popes and priests..."
- Peter Atkins  
 
Morgoth   Posted 6th Mar 2012 4:30pm
L4Y Member
Post 371 / 393

Garner

It is possible also to fix the PM notification when people reply to a topic you marked?


Thanks,
Morgoth
Red Faction - Xmod Home Page Mod DB Thanks to visit    



Copyright © 2000-2019 Levels-4-You
Your request was handled in 0.08 seconds.