Earlier today, we ran an article detailing that Oracle released 270 critical security updates for many of its products, including MySQL cluster which we use here to provide high uptime and reliability for SoylentNews. Needless to say, it was time to upgrade both NDB backends, and the four MySQLd frontends. While the upgrade did not go completely smoothly due to the fact that MySQL strict mode got enabled, and broke the site briefly, our total downtime was less than five minutes or so. Right now, we had to do a full flush and purge of all caches, which means the site is running a bit larky until they can repopulate but I'm pleased to announce we're up to date and secure!
ndb_mgm> show Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=2 @redacted (mysql-5.7.17 ndb-7.5.5, Nodegroup: 0) id=3 @redacted (mysql-5.7.17 ndb-7.5.5, Nodegroup: 0, *) [ndb_mgmd(MGM)] 2 node(s) id=101 @redacted (mysql-5.7.17 ndb-7.5.5) id=102 @redacted (mysql-5.7.17 ndb-7.5.5) [mysqld(API)] 4 node(s) id=11 @redacted (mysql-5.7.17 ndb-7.5.5) id=12 @redacted (mysql-5.7.17 ndb-7.5.5) id=13 @redacted (mysql-5.7.17 ndb-7.5.5) id=14 @redacted (mysql-5.7.17 ndb-7.5.5)
If you notice any unusual breakages or slowdowns, please let me know in the comments. Otherwise, keep calm and carry on!
~ NCommander
(Score: 2) by NCommander on Friday January 20 2017, @04:59PM
In terms of posters, a few hundred is probably correct, but we get a lot more of view traffic. I haven't checked the statistics recently, but we get a lot of read traffic to the point the site starts lagging when we have web frontend down. Plus I can't be on the high ground on keeping up on security patches if I'm a hypocrite about it.
Still always moving
(Score: 2) by ikanreed on Friday January 20 2017, @05:10PM
I think you're right, I just wanted a particularly hypocritical post to add my fake sql injection joke to.
(Score: 2) by Webweasel on Friday January 20 2017, @11:38PM
Hey! I like, post every couple of months and shit. sometimes.
I moderate too... when I get time.
STOP JUDGING ME!
Priyom.org Number stations, Russian Military radio. "You are a bad, bad man. Do you have any other virtues?"-Runaway1956