• submit to reddit
Rob J Hyndman07/22/14
0 replies

I am not an econometrician

Econo­met­rics is often “the­ory dri­ven” while sta­tis­tics tends to be “data dri­ven”. I dis­cov­ered this in the inter­view for my cur­rent job when some­one crit­i­cized my research for being “data dri­ven” and asked me to respond.

Peter Zaitsev07/22/14
0 replies

TokuDB Tips: MySQL Backups

In my recent post, “TokuDB gotchas: slow INFORMATION_SCHEMA TABLES,” I saw a couple questions and tweets asking if we use TokuDB in production. Yes, we are using Percona Server + TokuDB, along with LVM Backups. But there are some gotchas to be aware of.

Mike Cottmeyer07/22/14
0 replies

What is the ROI of Your Event?

So, where did our new event fall on a scale compared to the others? Did I feel like attendees received value and did I feel like we got a good return on our investment? Let me give a little comparison.

Dharshan Rangegowda07/21/14
0 replies

The three A's of MongoDB security - Authentication, Authorization & Auditing

MongoDB, Inc has made impressive strides over the past 18 months. One of the areas of the product that has seen the most significant improvement has been the area of Security. Security is of paramout importance for a production database. Existing relational databases provides a number of knobs and controls to help the DB administrator manage the security of his database and MongoDB is getting to a similar place as well. In this post we will delve deeper into the security features in the areas of Authentication, Authorization & Auditing.

Markus Winand07/21/14
0 replies

Finding All the Red M&Ms: A Story of Indexes and Full‑Table Scans

A common question that comes up when people start tuning queries is “why doesn’t this query use the index I expect?" There are a few myths surrounding when database optimizers will use an index. The basic decision on whether or not to use an index, though, comes down to its cost.

David Winterbottom07/21/14
0 replies

Linking to Github

It's dangerous to link to lines or blocks of code on Github without explicitly specifying the commit hash in the URL. This emits the Github URL to the HEAD commit on the current branch, specifying the commit hash in the URL

John Piekos07/21/14
0 replies

The Rise of NoSQL is An Opportunity for New RDBMS Solutions

It should come as no surprise that NoSQL has become popular over the past few years. This popularity has been driven in large part by the app revolution. Many new apps are hitting millions of users in less than a week, some in a day. This presents a scaling problem for app developers who seek a large audience.

Ayende Rahien07/21/14
0 replies

Introducing inefficiencies into RavenDB, on purpose

The administrators on the server noted the high I/O and that a single thread was constantly busy and decided that this is likely a hung thread. The long term fix was to actually make sure that we abort the operation after a while, report to the remote server that we scanned up to a point, and had nothing to show for it, and go back to the replication loop.

Mark Needham07/21/14
0 replies

R: ggplot: Problem automatically picking scale for difftime object

I thought it’d be interesting to create some visualisations around the times that people RSVP ‘yes’ to the various Neo4j events that we run in London. I tried to use ggplot to create a bar chart of the data. Unfortunately that resulted in this error:

Johanna Rothman07/21/14
0 replies

What is Your Minimum Agile Reading List?

I have created a Minimum Reading List for an Agile Transition. Note the emphasis on minimum. I could have added many more books to this list. But the problem I see is that people don’t read anything. They think they do agile if they say they do agile.

Alec Noller07/20/14
0 replies

The Best of the Week (July 11): SQL Zone

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone. This week's best include a look at Realm, a memory-efficient mobile database, a renewed focus on Java and SQL, the similarities between databases and humvees, and more.

Jim Bird07/18/14
0 replies

Trust instead of Threats

According to Dr. Gary McGraw’s ground breaking work on software security, up to half of security mistakes are made in design rather than in coding. For the last 10 years we’ve been told that we are supposed to do this through threat modeling. What else can we do to include security in application design?

Alexey Kutuzov07/18/14
0 replies

Docker using private registry

There is an easy way to define Docker container using Dockerfile. The other way to do it is private Docker registry. I will install now MongoDB in a Docker container w/o Dockerfile

Mike Bushong07/18/14
0 replies

Open Compute, Open Switch API and Open Network Install Environment

Much has been published about the Open Compute Project. Initiated by Facebook, it has become an industry effort focused on standardization of many parts and components in the datacenter. It’s not a huge innovative leap, but it’s a significant convenience.

Peter Zaitsev07/18/14
0 replies

Managing Shards of MySQL Databases with MySQL Fabric

This is the fourth post in our MySQL Fabric series. In case you’re joining us now, we started with an introductory post, and then discussed High Availability (HA) using MySQL Fabric. Today we will talk about how MySQL Fabric can help you scale out MySQL databases with sharding.