Our 64th newsletter issue is just out. In it we discuss different perspectives, and how they shape what we value as important. Understanding how each person, each client, each party at the table sees things, and values things differently is the first step in being able to deliver and speak directly to their needs.
Everyone has experienced the phenomenon of dealing with their savings or checking account banks. When they deposit a check, the bank is quick to credit, while when they write a check, they are slow to debit. This is a phenomenon of accounting, ie take in money as quickly as possible, but dole it out as slowly as possible. At root it is at the heart of cash flow. In this month’s newsletter we discuss some of the challenges inherent in business as belts are tightened and budgets constrict.
In part two of our article on DRBD and High Availability, we take you step-by-step through setting up Sun’s Virtualbox software, creating a couple of VMs, and then installing CentOS on those. These two virtual Linux boxes then serve as two nodes in our DRBD mirrored disk setup which we use as a platform to install MySQL.
DRBD, MySQL and the Virtualbox Setup – Database Journal
Keep on the lookout for our third part in the series next month. In that issue we’ll explain how the Linux Heartbeat project can be used to control the whole setup, and provide automatic failover in the event that one node goes down.
With all the trouble keeping MySQLs built-in replication running, some folks are looking for alternatives. DRBD provides a distributed block level device, which can provide the sort of database mirroring we need, below the filesystem. That makes it transparent to MySQL, but nevertheless a great complimentary solution. In this article we’ll discuss the pros and cons, and then part two will take you step by step through a basic setup.
Read the article on Database Journal – DRBD and MySQL – Excellent Low-cost HA Solution
In our last newsletter of the decade we discuss the importance of context. Whether it is in user interface design such as priorities in the iphone and feature development, or the numbering of apartments in a new building complex, the perspective or context within which designers, architects and engineers see things, is often quite different from the day-t0-day experiences of so-called end-users. Stepping into their shoes, and being able to see things from their perspective, ie your customers perspective, is an ever present challenge in business.
webcast – DRBD and MySQL
Nov 24
I’ve teamed up with O’Reilly once again to do another webcast this coming January. In it, I’ll provide a step-by-step live tutorial of setting up DRBD with MySQL on a couple of virtual servers. After the live demo there will be time for Q&A as well, so hope you all can tune in.
DBJ: More MySQL Scaling
Nov 11
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 changes, but with some work you can drastically improve overall response for your applications.
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.
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
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 issue is for you.
Our newsletter this month hits upon the topic of skills. How often are skills not obvious upon first observation of someone? We illustrate this point first by looking at some martial arts classes and then some resumes!
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.
In our latest newsletter we take a trip to the Brooklyn Flea, and talk with the purveyors not of homemade beer, but homemade beer making equipment. We share some insights at how enthusiasts, technology geeks, open source aficionados and passionate detail oriented folks in many niches share a common trait in common. That of ownership. Owning the details, the skills, and mastery over a topic or area. The proverbial “subject matter expert”.
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.
In this month’s issue we discuss assessing people, and how we determine qualification. In particular we look at skills and compare the to immeasurables like drive, loyalty, and fortitude as factors which are often more difficult to measure, but perhaps more crucial to success.
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
Path Dependence is a technical term which basically means the further along a given path you go, the more pressure there is to “stay the course”. In this months open insights issue, we discuss this phenomenon in consulting, and suggest some ways to help eliminate or reduce that dependence and make you more nimble and flexible in tight budgets, and trying economic times.Open Insights 54 – Avoiding Path Dependence
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 issue of Open Insights #53 for March 2009, we discuss the idea “focus on results on process”. From buying technology hardware, to buying licenses, hiring consultants, to upgrading enterprise software, this simple maxim can provide some new insights into our decision making processes, and hopefully save us time and money in the process.Open Insights 53 – Focus on Results
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.
My O’Reilly webcast is now online at youtube. Comments welcome!
Webcast: MySQL Replication
Jan 18
MySQL Replication is fairly simple to setup for the first time. However over time maintenance can become troublesome. At times errors show up in the error logs, or it can stop running altogether. In fact MySQL Replication can fail in a much more insidious way, that is silently. So what to do?
As it turns out there are specific reasons and causes for MySQL replication to get out of sync. We’ll discuss what is and isn’t compliant in a MySQL Replicated environment, and then most importantly, we’ll discuss a tool that can help you verify your environment, and show you what is or isn’t in sync and why.
I’m presenting this webcast with O’Reilly on Thursday January 22. If you’re interested, click here to register.
Over the holidays I had the chance to catch up on some podcasts I hadn’t listened to. In particular Financial Times has an excellent weekly one called “Digital Business”. In the last one for 2008, Peter Whitehead interviews a few people to get their forcasts for 2009.
Of particular interest to our readers was his mention that Open Source will continue to grow in importance, as budgets get squeezed. Limited budgets mean looking at every dollar, so this month’s Open Insights issue 51, we talk about stretching your database dollar, and where and when open source database technologies may be right for you.
Part II in our series on MySQL picks up where we left off from talking about some of the challenges, and potential issues and problems that come up with MySQL replication after you have it setup and running for some time. DBJ: Fixing MySQL Replication
In this piece we talk about some of the ways to verify your setup, and make sure your slave does not drift out of sync with the master, and to alert you if it does.
Our 50th issue of Open Insights Newsletter is out. We think you’ll enjoy the analogy!!