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.
MySQL's unique architecture allows for plugin storage engines. There is the MyISAM storage engine, the ARCHIVE storage engine and the InnoDB storage engine; so it makes sense then that MySQL's clustering solution involves a storage engine as well, namely the NDB (Network DataBase) storage engine.
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]