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 to terms that everyone *can* agree on. This is the first in a two part series where I discuss various ways to make your database scale. But I talk in terms of faster, stronger, bigger and better because I think we can all agree that’s what we’re really trying to achieve! Database Journal: Faster & Stronger MySQL
Archive for category mysql
With a tongue in cheek, humorous tone, we turn the tables upside down on database best practices, illustrating all of the things you shouldn’t do, and what might happen if you ignore those important tasks.
I recently did a webcast for O’Reilly and Associates on MySQL Clustering Setup and configuration.
DBJ: Five More Dials To Turn
Jul 10
In this month’s article over at Database Journal we discuss more areas to tune your initial MySQL database setup including InnoDB & MyISAM buffers, hit ratios, index usage and full table scans, security, and logs. With this second article in a two part series we complete our coverage of basic tuning of a MySQL database.
DBJ – Ten Dials To Set
Jun 12
This month in Database Journal we start a two part article on tuning the dials of your new MySQL database. After you install and setup your first database, you’ll need to set various parameters in your my.cnf file. These control memory, logfiles, temp table usage, sorting, joins, and a whole lot more. We’ll review some of the more important wants and start you on your way to more nuanced tuning of your MySQL instance.
Read the article: Ten Dials To Set at DatabaseJournal.com
If you haven’t worked with MySQL’s NDB Cluster storage engine yet, now is the time to take a peek. There is a sandbox available from serveral nines, which can be installed fairly quickly. This new article over at DatabaseJournal, MySQL Clustering In A Sandbox will have you up and running in no time.
A new article is up on Database Journal where I discuss some query optimizations that work well with MySQL applications.Five Query Optimizations in MySQL
The MySQL Query Cache is a powerful piece of engineering that users of the popular open source database can take advantage of to speed up throughput of their applications. MySQL’s cache operates a little bit differently from other database engines. It does not just cache query plans, but the query data as well. What this means is that the size and number of queries that your database manages will be variables when tuning the query cache. We discuss all of these items in our new article at DatabaseJournal.
Database Journal – Optimizing the MySQL Query Cache
Our latest article over at Database Journal is hot off the presses. Advanced MySQL Replication – Improving Performance discusses some of the best ways to improve the performance of your MySQL slave setup. If the slave is constantly getting further and further behind the master database, we discuss a number of techniques which may help you bring it under control.
review: MySQL Cookbook
Nov 14
Last year O’Reilly released the 2nd Edition of the MySQL Cookbook by Paul DuBois. You can read my review here.
Whenever a publisher releases a 2nd Edition of a book, you know it was well received the first time around. So that’s a good sign that the material has gotten people buying. I would say in the computer reference and howto market, that’s a very good indication that the material is well written and relevant. I certainly found it to be the case with this title.
If you’re looking for a quick & no nonsense howto book on MySQL development, look no further. The book focuses on Ruby, Perl, PHP, Python and Java as examples. So if you’re doing development, specifically web development, you’ll get a lot out of this title.