• Log in or sign up for an account here: https://www.sythe.org/login

xen dev blog

Joined
Apr 21, 2005
Sythe Gold
5,469
Messages
8,075
Clefairy
Supporting Business
Discord Voice
Jigglypuff
Hell yeah boooi
Poképedia
Who did this to my freakin' car!
Dat Boi
Dolan Duck
Dolan Trump
I'm LAAAAAAAME
Live Free or Die
Mew
Mewtwo
Poké Prizebox
Rust Player
Sythe Awards 2016 Winner
Sythe Awards 2017 Winner
Sythe Awards 2019 Winner
Tier 3 Prizebox
Toast Wallet User
Going to miss our target launch date for xen I think. I've been working non stop on it even over Christmas. Matt has been doing a fair bit of work as well.

Database remains the major stumbling block. We use master-slave replication at the moment which has served us quite well. Xenforo doesn't natively support master-slave. There are addons but they are outdated and no longer maintained. Writing our own remains a possibility although master-slave is not a particularly good model to begin with.

I've been working with mysql cluster on the new servers to try provide a theoretically more stable platform that xen will run on, however having spent four straight days working with it now I'm thinking it's too fiddly for us. Essentially it is designed as a distributed memory database which is not appropriate for the size of our database. Even if I commissioned enough ram to hold our current database ( > 20Gb of ram ) it wouldn't allow for strong growth. It does have a disk storage option which I am testing at the moment but from what I've seen so far it is more cancer.

I haven't yet decided what to do. Mysql cluster was my first choice, and we may still go with it if I can figure out how to get disk storage to work cleanly and quickly. Failing that I think I will try mariadb cluster. Failing that we might try some sort of multi-master non-cluster setup.

Long story short: I'm working on it as quickly as I can but it's taking longer than expected. In the meantime I will continue to make critical patches to the existing production system. I am still planning to move us as soon as humanly possible.
 
<3 n4n0
Discord Verified
Two Factor Authentication User
Community Participant
Spam Forum Participant
Sythe's 10th Anniversary
Sythe Awards 2011 Winner
Why is the database such a bottleneck? At work we have a 250GB+ SQLServer database that performs and scales just fine, other than running the dev machine out of disk space. Granted our use case is for a few very heavy users (requests on the order of 10s of MBs each) rather than many smaller requests.
 
Clefairy
Supporting Business
Discord Voice
Jigglypuff
Hell yeah boooi
Poképedia
Who did this to my freakin' car!
Dat Boi
Dolan Duck
Dolan Trump
I'm LAAAAAAAME
Live Free or Die
Mew
Mewtwo
Poké Prizebox
Rust Player
Sythe Awards 2016 Winner
Sythe Awards 2017 Winner
Sythe Awards 2019 Winner
Tier 3 Prizebox
Toast Wallet User
Why is the database such a bottleneck? At work we have a 250GB+ SQLServer database that performs and scales just fine, other than running the dev machine out of disk space. Granted our use case is for a few very heavy users (requests on the order of 10s of MBs each) rather than many smaller requests.

Different applications. We need high performance and redundancy together. It's not sufficient to have one really big server and run a single database instance on it. It would bottleneck no matter how expensive the hardware and doesn't provide a good failover option. Granted you could have two that check eachother but that's still not a great solution.

We need a scaling system made up of lots of reasonably small servers that work together -- shards. A system where we can add more capacity as needed without touching existing production hardware. The second you have to open hardware up you're talking serious major downtime and expense. If you can keep everything redundant with no reliance on any specific machine or piece hardware that's going to be the best overall option for uptime.
 
Member of the Month Winner
Sythe's 10th Anniversary
Wubba Lubba Dub Dub
The Mortyest Morty
Discord Verified
Sythe Awards 2012 Winner
Le Kingdoms Player
Two Factor Authentication User
Spam Forum Participant
I'm LAAAAAAAME
Signature of the Month Winner
when is vb4 coming tho???
 
In Memory of Jon
Gohan has AIDS
Pokémon Trainer
Poképedia
lick lick lick my ballssss
 
Two Factor Authentication User
SytheSteamer
I'm more concerned over security concerns than the new board, though saying that the upgrade with solve those issues, but I do welcome it with open arms, it's been a long time overdue.

Cheers big man.
 
420 yolo swag blaze it fuck the popo legalize it anyone got some chips
Two Factor Authentication User
Christmas 2015
Community Development Team Member
Easter 2016
Halloween 2015
Sythe Awards 2016 Winner
Tier 1 Prizebox
Valentine's Day 2016
Different applications. We need high performance and redundancy together. It's not sufficient to have one really big server and run a single database instance on it. It would bottleneck no matter how expensive the hardware and doesn't provide a good failover option. Granted you could have two that check eachother but that's still not a great solution.

We need a scaling system made up of lots of reasonably small servers that work together -- shards. A system where we can add more capacity as needed without touching existing production hardware. The second you have to open hardware up you're talking serious major downtime and expense. If you can keep everything redundant with no reliance on any specific machine or piece hardware that's going to be the best overall option for uptime.

You think working with OpenStack would benefit you, within your own dedicated environment?
 
Some like it hot
Halloween 2014
<3 n4n0
Not sure if srs or just newfag...
We need a scaling system made up of lots of reasonably small servers that work together -- shards.
I used to have some shards, if u need any just let me know and ill check my rs3 account
 
0af34e6041.jpg


c8355d056c.jpg


660c9f51d4.jpg


d4c7ced4f4.jpg
 
Hope it works out for all of our sakes. Too many shall not pass getting put out there.
 
I'm more concerned over security concerns than the new board, though saying that the upgrade with solve those issues, but I do welcome it with open arms, it's been a long time overdue.

Cheers big man.

5char
 
Sythe Awards 2010 Winner
Sythe Awards 2012 Winner
Christmas 2015
Valentine's Day 2016
Easter 2016
MushyMuncher
Tier 1 Prizebox
don't stress home slice, we'd rather it done properly than rushed
 
Runescape Gamblingrunescape gambling
Back
Top