In this second part of our piece on scaling, we talk about running more instances of MySQL either on a single server or multiple servers, to get faster overall response for your queries. This will require some work with your application making decisions about where it will find its data or where it should make [...]
In our latest newsletter we discuss what economists are dubbing the “medicine of austerity” aka paying the piper or tightening your belt. And we think that this medicine will surely include open source technologies.
Open Insights 61 – Medicine of Austerity
Accessing metadata can be optimized by using stored routines. Stored routines provide the ability to filter the data in a more useful way. For example, when I'm looking at table data I usually want to look at the index information also. So I use a stored routine called tabinfo that gives me key information I need for tables and indexes.
-- Create the tabinfo stored procedure.
Sometimes terms like scaling are – as the brits like to say – bandied about, without everyone agreeing on what they mean. That’s because scaling is an insiders term, a technical term thought to carry great weight, but nevertheless often misunderstood.So I wanted to write an article about this interesting and important topic, while sticking [...]
Usually an article like this one will start out with the technical word "scaling". Unfortunately, like health care reform, everyone can't always agree on what they mean by it, or even what the goal is. Learn how to make your database faster, stronger, bigger and better in this article that uses words we can all agree on.
Issue 60 marks our newsletter’s five year anniversary. How time flies!
This month we talk about the very prescient topic of the principal agent problem. If you’ve ever been to the mechanic and wondered about what problem your car really has, and whether the mechanic might be inflating the story to his own advantage, then this [...]
Indexes are a feature that you can enable on your MySQL tables to increase performance, but they do have some downsides. Read on as we review some of the best practices for achieving the right balance between query and update speed through column indexing in MySQL.