xen dev blog

[Sythe]

bad news: cluster with maxscale got butt raped under stress test conditions over night.

looking into it today

 

[Sythe]

pretty fed up with this database fuckery at this juncture

seriously considering returning to traditional master slave configuration

 

[Sythe]

going to reconfigure the way maxscale is used

I'll put a maxscale instance on each of the two load balancer nodes and make all the connections persistent. Part of the problem is the vast amount of physical memory a single mysql connection uses in percona (even when using conservatively configured buffers). If every node has a maxscale instance which connects to every other node then we use a lot more connections than necessary.

Originally I wanted it so that each maxscale instance makes a simple decision to route the request to localhost if it is a read, or to the variably elected master node if it is a write. However this configuration is not possible, and the aforesaid n-to-n configuration is not desirable. So we will try this third configuration now.

 

[Sythe]

I'm adding a haproxy instance to each cluster node so each php instance can connect randomly and reliably to a maxscale instance on the load balancers

everything is really annoyingly complicated when you can't really modify the application you are trying to run (xenforo) for fear of future update-incompaitibility

 

[Jack]

Here's a better quality pepe without the random drop shadow that no other mini-rank has which makes it look like an eye sore

 

[Giddy]

He's a whitehat

You obviously know how to run this site better than anyone else, so please don't take this the wrong way. He could be a white hat hacker but in my experience very few things are absolute. All though whitehat hackers are known to get rewarded from time to time, I believe they help because they want to use their ability for good. For example, hattez truly cares about the security of this site so he was willing to expose the exploit with or without a reward. Moes however, was quiet until a reward was offered. Hattez knows less but he came forward first because I believe him to be more ethical. In my opinion Moes will take the option which gives him the most personal gain. The only reason why I bring this up is because I also care about this site and I hope to see it continue for many more years.

tl;dr - please keep on eye on him.

why arent you banned for posting porns?

Lol wat?

 

[Sythe]

Here's a better quality pepe without the random drop shadow that no other mini-rank has which makes it look like an eye sore

thanks fam updated and gave you one too for cleaning it up

 

[Sythe]

new setup seems to be working but only another stress test will tell

 

[Sythe]

polishing this setup with some automation

 

[SuF]

You obviously know how to run this site better than anyone else, so please don't take this the wrong way. He could be a white hat hacker but in my experience very few things are absolute. All though whitehat hackers are known to get rewarded from time to time, I believe they help because they want to use their ability for good. For example, hattez truly cares about the security of this site so he was willing to expose the exploit with or without a reward. Moes however, was quiet until a reward was offered. Hattez knows less but he came forward first because I believe him to be more ethical. In my opinion Moes will take the option which gives him the most personal gain. The only reason why I bring this up is because I also care about this site and I hope to see it continue for many more years.

tl;dr - please keep on eye on him.



Lol wat?

you did that once didnt you

 

[Syed]

you did that once didnt you

ya he did but this isnt the same giddy, this guy bought the account

original giddy posted cp in the spam forum and got permed

 

[Sythe]

looking into posticons and breadcrumbs

 

[Giddy]

ya he did but this isnt the same giddy, this guy bought the account

original giddy posted cp in the spam forum and got permed

Check your facts bro: http://www.sythe.org/archives/919488-list-awarded-pardons.html

I've verified my id with nano already but I'll do it for anyone else.

 

[SuF]

ya he did but this isnt the same giddy, this guy bought the account

original giddy posted cp in the spam forum and got permed

oh thanks. i miss old giddy

 

[Sythe]

ye maxscale is fucked & I hate it

not sure what to try next. don't want to ditch cluster if I can avoid it.

thinking

 

[Sythe]

trying a master slave addon on top of the cluster as a way of filtering writes to a single node

 

[Sythe]

this solution looks like it might actually work

 

[Syed]

oh thanks. i miss old giddy

ya new giddy is pretty annoying, dunno why staff doesnt do anything about it tbh

 

[Sythe]

so to clarify I've removed maxscale and the haproxy load balancers for the sql nodes (not for the http load balancing though)

we're back to an almost pure cluster, but xen has been patched to redirect its writes to a single 'write-only' node. (Essentially a master.) However the cluster nodes are still all technically writable nodes it's just we're only writing to one in order to avoid deadlocks.

If this doesn't work I'll just remove the cluster altogether and go back to a traditional master slave setup I think.

 

[Jack]

thanks fam updated and gave you one too for cleaning it up

Holdin it down fam