MariaDB ColumnStore Adds Simultaneous Analytics, Transactional Processing – The New Stack


InnoDB or the other default MySQL storage engine MyISAM provide reasonable performance on analytical query workloads up to 100,000 rows or tables under a million rows. Performance is harder to tune and maintain beyond that, Thompson wrote in a blog post.
ColumnStore is suitable for reporting or analysis on much larger data sets. Mobile applications of customer Pinger, for example, process millions of text messages and phone calls with ColumnStore, in addition to more than 1.5 billion rows of logs per day.

Source: MariaDB ColumnStore Adds Simultaneous Analytics, Transactional Processing – The New Stack

Looks interesting. We’ve had performance issues with our large db tables for years that we’ve managed to work around, but it’s likely time to take a look at a redesign around a newer technology.

Drupal 8 Development in Docker – Redux – ActiveLAMP

Back in December, Tom Friedhof shared how we set up our Drupal 8 development and build process utilizing Docker. It has been working well in the several months we have used it and worked within its framework. Within the time-span however, we experienced a few issues here and there which led me to come up with an alternative process which keeps the good things we like and getting rid of/resolving the issues we encountered.

Source: Drupal 8 Development in Docker – Redux – ActiveLAMP

Ever wonder how a big site like Stack Overflow handles code deployment?

We’ve talked about Stack Overflow’s architecture and the hardware behind it. The next most requested topic was Deployment. How do we get code a developer (or some random stranger) writes into production? Let’s break it down. Keep in mind that we’re talking about deploying Stack Overflow for the example, but most of our projects follow almost an identical pattern to deploy a website or a service.

Source: Nick Craver – Stack Overflow: How We Do Deployment – 2016 Edition

Fascinating look into how Stack Overflow code gets from a developers workstation to production servers. There are many good ideas about development workflow in here.