HeidiSQL is a free GUI client for MySQL, favored by many Web developers and database administrators of small to medium-sized businesses to manage persistent storage of data. This article will familiarize you with HeidiSQL’s Query editor by using it to write a query that will join four tables together to perform searches against a help library.
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 [...]