Stories
Slash Boxes
Comments

SoylentNews is people

Meta
posted by NCommander on Friday January 20 2017, @04:43PM   Printer-friendly
from the hot-upgrading-database-servers-ftw dept.

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

 
This discussion has been archived. No new comments can be posted.
Display Options Threshold/Breakthrough Mark All as Read Mark All as Unread
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
  • (Score: 2) by shipofgold on Friday January 20 2017, @05:05PM

    by shipofgold (4696) on Friday January 20 2017, @05:05PM (#456603)

    Someone who wants to take over the site and use it for more nefarious reasons?

    Starting Score:    1  point
    Karma-Bonus Modifier   +1  

    Total Score:   2  
  • (Score: 2) by AthanasiusKircher on Friday January 20 2017, @06:42PM

    by AthanasiusKircher (5291) on Friday January 20 2017, @06:42PM (#456639) Journal

    "Nefarious reasons"? What could be more nefarious than making news out of... PEOPLE?

    Puppies, maybe? Yeah -- that's usually worse. Today if they remade Soylent Green and really wanted a shocker, it would turn out that it was made from puppies.

    One of the most insightful scenes in film from the last year or two was in Look Who's Back [wikipedia.org], which involves the mysterious return of Adolf Hitler to modern Berlin. Shockingly, he seems to get away with saying just about anything from his old rhetoric -- ranting about immigrants and the glory of the German race, endorsing "labor camps" for undesirables, etc. It all just seems to make him more popular. But [SPOILER] -- the one thing the public cannot stand from him is violence to a small dog. I won't say more... you just have to see it.

    • (Score: 0) by Anonymous Coward on Saturday January 21 2017, @05:56AM

      by Anonymous Coward on Saturday January 21 2017, @05:56AM (#456869)

      * TVTropes Warning! *

      http://tvtropes.org/pmwiki/pmwiki.php/Main/KickTheDog [tvtropes.org]

      * TVTropes Warning! *

    • (Score: 2) by Phoenix666 on Saturday January 21 2017, @11:58AM

      by Phoenix666 (552) on Saturday January 21 2017, @11:58AM (#456942) Journal

      Most people familiar with the history know this, but it was a good reminder when the guy going nuts trying to stop him confronted him on the roof and Hitler pointed out, "All those people voted for me. They voted for me."

      --
      Washington DC delenda est.