- I’ve done dutiful DBA work in the past to identify and remove what are commonly called duplicate indexes. That is, those indexes that look like (a) and (a,b). The thought is that a query will utilize an index as easily on (a) as on (a,b), and removing (a) will save storage cost and write performance. I’ve had the experience, though, of removing (a) and seeing performance tank. Why do we sometimes want to keep duplicate indexes?
- New MongoDB University courses! I’ve raved about the MongoDB courseware before. Happy to see some new courses, highly relevant to ops. I’ve signed up for these: M310: MongoDB Security Learn how to use MongoDB’s native and third-party integration security features and resources. This course will provide you with the knowledge to create secured deployments of MongoDB for production-ready environments. M210: MongoDB Performance Learn how to optimize the performance of your MongoDB deployment.
- I was reminded recently of a project I did during a DevDays week at WebAssign in 2014. The engineering department wanted to move a large dataset into MongoDB, and my DevDays experiment was to demonstrate the Tungsten Replicator’s role in translating data from MySQL to MongoDB. It worked handily, but was ultimately not implemented because the development teams got bogged down in the Tungsten replication filters desired for data transformation.
- I often joke that if I was stuck on a desert island, the book I’d want to have along is the MySQL Reference Manual. There’s an endless source of amusement within the 4400+ pages. I recently found myself stuck in the West Virginia mountains with no quick source of internet, and discovered several bits of new trivia. Here’s just one item: Adding the –i-am-a-dummy flag to your mysql client (or within a configuration file, of course) keeps you from making updates or deletes on a whole table without a “where” clause.
Quite excited about this new MySQL ecosystem conference, this one specifically about the primary fork of MySQL, MariaDB. (Or you may think of it as the original MySQL, pre-Oracle fork.) Equally excited it’s on the East Coast.
I had the pleasure of attending a presentation by Yoshinori Matsunobu at the NYC MySQL Meetup, and learning about the MyRocks engine optimized for space and writes.
- What a bright group presenting tonight at the Congressional App Challenge hosted at Centennial Campus by Rep. David Price. I enjoyed serving the community by judging the apps and look forward to seeing what these young people come up with in the years ahead.
- An old Girl Scout favorite, TechnoQuest was held at Meredith College in Raleigh. We joined for the first time this year; the younger one participated in day-long STEM activities – primarily chemistry and physics – while I attended seminars in community-building, nurturing confidence in youth, and leading science explorations.
It’s been a busy month for file vulnerabilities. Thanks to Dawid Golunski at legalhackers.com for giving us all the opportunity to tighten security in our MySQL, MariaDB, and Percona Server instances.