• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

New Interview with Digitalpoint

The Sandman

Well-known member
#1
We just posted our Interview with Shawn Hogan (Digitalpoint) Part 3 - After the Apocalpyse!
So was stay at Taft Correctional Institution better or worse than you imagined? Did the time pass quickly or slowly? How did you spend your days?

It was pretty fun actually. No responsibilities, everyone (inmates and staff) was super nice, bathrooms/showers were super clean/private and nice, food was great, etc.

Honestly, if I just wanted to be lazy and be taken care of, it would be a great place to live for a longer period of time.

The hardest decision you have to make is along the lines of if you want to play softball or bocce ball. Or maybe you want to play pool so you can watch TV at the same time.

I always made carnitas and fresh guacamole for Charger games.:)
@Lisa insisted I ask if you got any tattoos while you were "in the joint"?

Lol... no. And not sure you could find a tattoo parlor there to do it for you anyway.:)
 

digitalpoint

Well-known member
#3
digitalpoint uber alles.

Except he can't keep his site up.

View attachment 104946
EDIT: Up and running again.
You caught it for the split second before automatic failover to a different DB server kicked in. Basically have been wrestling with any ALTER TABLE statement more or less seizing up the SQL node it was performed on. Huge bug in MySQL Cluster 7.4... Finally decided I'm not waiting for them to fix it anymore and going to downgrade back to MySQL Cluster 7.3.

Our end is "self-healing", but yeah... needed to upgrade a couple WordPress blogs to 4.2.1, and the upgrade includes ALTER TABLE, which basically wrecks whatever SQL node it was performed on for a couple minutes due to this bug:

http://bugs.mysql.com/bug.php?id=76488

You know... because 30+ minutes to ALTER a tiny table is super normal. haha wtf... not sure how MySQL Cluster 7.4 made it past testing. Dumbest **** ever.

Code:
mysql> show processlist;
+----------+-------------+---------------------+-----------------+---------+------+-------------------------------------------+-----------------------------------------------------------------------------------------------+
| Id       | User        | Host                | db              | Command | Time | State                                     | Info                                                                                          |
+----------+-------------+---------------------+-----------------+---------+------+-------------------------------------------+-----------------------------------------------------------------------------------------------+
|        1 | system user |                     |                 | Daemon  |    0 | Waiting for event from ndbcluster         | NULL                                                                                          |
| 12406625 | root        | 192.168.10.22:54606 | shawnhogan      | Query   |  925 | Waiting for ndbcluster global schema lock | ALTER TABLE wp_commentmeta CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci        |
| 12406727 | root        | localhost           | NULL            | Query   |    0 | init                                      | show processlist                                                                              |
| 12410584 | root        | 192.168.10.20:51401 | shawnhogan      | Query   |  918 | Waiting for ndbcluster global schema lock | ALTER TABLE wp_term_relationships CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci |
| 12413356 | root        | 192.168.10.23:53916 | digitalpointads | Query   | 1950 | Waiting for ndbcluster global schema lock | ALTER TABLE wp_links CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci              |
| 12414026 | root        | 192.168.10.21:33166 | 13411_111       | Query   | 1951 | rename result table                       | ALTER TABLE wp_comments CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci           |
| 12450784 | root        | 192.168.10.23:41367 | xenforo         | Sleep   |    0 |                                           | NULL                                                                                          |
| 12450785 | root        | 192.168.10.20:36267 | xenforo         | Sleep   |    0 |                                           | NULL                                                                                          |
+----------+-------------+---------------------+-----------------+---------+------+-------------------------------------------+-----------------------------------------------------------------------------------------------+
8 rows in set (0.00 sec)
 

digitalpoint

Well-known member
#4
On a side note, I really, really, really like how you can do major version upgrades (or in this case downgrades) of the database server without users knowing anything is going on (see id=11)... just started restarting the data nodes with the older version that doesn't barf all over ALTER TABLE. :)

Code:
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)]    8 node(s)
id=11    @192.168.10.20  (mysql-5.6.24 ndb-7.3.9, starting, Nodegroup: 0)
id=12    @192.168.10.21  (mysql-5.6.24 ndb-7.4.6, Nodegroup: 1, *)
id=13    @192.168.10.22  (mysql-5.6.24 ndb-7.4.6, Nodegroup: 2)
id=14    @192.168.10.23  (mysql-5.6.24 ndb-7.4.6, Nodegroup: 3)
id=15    @192.168.10.24  (mysql-5.6.24 ndb-7.4.6, Nodegroup: 0)
id=16    @192.168.10.25  (mysql-5.6.24 ndb-7.4.6, Nodegroup: 1)
id=17    @192.168.10.26  (mysql-5.6.24 ndb-7.4.6, Nodegroup: 2)
id=18    @192.168.10.27  (mysql-5.6.24 ndb-7.4.6, Nodegroup: 3)

[ndb_mgmd(MGM)]    2 node(s)
id=1    @192.168.10.20  (mysql-5.6.24 ndb-7.3.9)
id=2    @192.168.10.21  (mysql-5.6.24 ndb-7.3.9)

[mysqld(API)]    33 node(s)
id=21    @192.168.10.20  (mysql-5.6.24 ndb-7.3.9)
id=22    @192.168.10.21  (mysql-5.6.24 ndb-7.3.9)
id=23    @192.168.10.22  (mysql-5.6.24 ndb-7.3.9)
id=24    @192.168.10.23  (mysql-5.6.24 ndb-7.3.9)
id=25    @192.168.10.24  (mysql-5.6.24 ndb-7.3.9)
id=26    @192.168.10.25  (mysql-5.6.24 ndb-7.3.9)
id=27    @192.168.10.26  (mysql-5.6.24 ndb-7.3.9)
id=28    @192.168.10.27  (mysql-5.6.24 ndb-7.3.9)
id=31    @192.168.10.20  (mysql-5.6.24 ndb-7.3.9)
id=32    @192.168.10.21  (mysql-5.6.24 ndb-7.3.9)
id=33    @192.168.10.22  (mysql-5.6.24 ndb-7.3.9)
id=34    @192.168.10.23  (mysql-5.6.24 ndb-7.3.9)
id=35    @192.168.10.24  (mysql-5.6.24 ndb-7.3.9)
id=36    @192.168.10.25  (mysql-5.6.24 ndb-7.3.9)
id=37    @192.168.10.26  (mysql-5.6.24 ndb-7.3.9)
id=38    @192.168.10.27  (mysql-5.6.24 ndb-7.3.9)
id=41    @192.168.10.20  (mysql-5.6.24 ndb-7.3.9)
id=42    @192.168.10.21  (mysql-5.6.24 ndb-7.3.9)
id=43    @192.168.10.22  (mysql-5.6.24 ndb-7.3.9)
id=44    @192.168.10.23  (mysql-5.6.24 ndb-7.3.9)
id=45    @192.168.10.24  (mysql-5.6.24 ndb-7.3.9)
id=46    @192.168.10.25  (mysql-5.6.24 ndb-7.3.9)
id=47    @192.168.10.26  (mysql-5.6.24 ndb-7.3.9)
id=48    @192.168.10.27  (mysql-5.6.24 ndb-7.3.9)
id=51    @192.168.10.20  (mysql-5.6.24 ndb-7.3.9)
id=52    @192.168.10.21  (mysql-5.6.24 ndb-7.3.9)
id=53    @192.168.10.22  (mysql-5.6.24 ndb-7.3.9)
id=54    @192.168.10.23  (mysql-5.6.24 ndb-7.3.9)
id=55    @192.168.10.24  (mysql-5.6.24 ndb-7.3.9)
id=56    @192.168.10.25  (mysql-5.6.24 ndb-7.3.9)
id=57    @192.168.10.26  (mysql-5.6.24 ndb-7.3.9)
id=58    @192.168.10.27  (mysql-5.6.24 ndb-7.3.9)
id=59 (not connected, accepting connect from any host)

ndb_mgm>
 

SneakyDave

Well-known member
#5
I really, really, really like how you can do major version upgrades (or in this case downgrades) of the database server without users knowing anything is going on (see id=11).
You mean with clustering, right? Or do you mean with an individual MySQL instance?

Haven't tried clustering yet. Seems like it'd be a lot of things that can break.

Are you doing a file system backup of your database files, or use logging, or a third party service?
 

digitalpoint

Well-known member
#6
You mean with clustering, right? Or do you mean with an individual MySQL instance?

Haven't tried clustering yet. Seems like it'd be a lot of things that can break.

Are you doing a file system backup of your database files, or use logging, or a third party service?
MySQL Cluster is a completely different beast... it's really not MySQL at all... it's basically designed to scale linearly and have no single point of failure. (last time I benchmarked my cluster, it was able to push through about 35,000,000 queries per second... the bottleneck being the 54Gbit Infiniband networking.

For backups, MySQL Cluster has a system where you can do hot backups (doesn't require any table locking so it doesn't affect users). I do a full backup nightly.

A general overview of MySQL Cluster here: