MySQL MagazineApril 15, 2008Introducing Kickfire (http://www.paragon-cs.com/mag/issue4.pdf)

eWeek April 15, 2008SQL Chip Gives MySQL Data Warehouse Boost (http://www.eweek.com/c/a/Database/SQL-Chip-Gives-MySQL-Data-Warehouse-Boost/)

I’m attempting to live blog corrections and notes while sitting in the replication tutorial. Lars is covering available options in MySQL replication. I’m going to attempt to cover some recommended best practices and things that are possible to do in MySQL but should be avoided. Please keep in mind that I’m writing this during the presentation. If anything is confusing post a comment and I will clean it up.

When designing a MySQL architecture that are several possible configurations. Two that should be avoided are dual master where you write to both masters. Configuring replication in a dual master dual writer setup means there is no single authority on the data. There is also no need to write to both masters as this doesn’t give you any performance improvement. Each master has to process the same sql statements. One step further is circular replication that wasn’t mentioned in the talk but has been in other publications. When using …

Are you a mySQL DBA that will not take a vacation because your the only person to fix a disaster if one will occur? Do you take a vacation and stay at home with your pager on you? Ask you self when was the last time you went someplace for 9 days without a pager or computer? If work is more important to you then your own personal time, then its time to take a vacation.

I just took a 9 day vacation in Hawaii, 4 days on the Big Island and the rest on Oahu. Man I haven't been this rested in years. I feel like a new man! Prior to my vacation I felt run-down and I was just going through the paces, now I'm rejuvenated-the ocean waves and hot air has given me new ideas on how to design back-end database data layouts, how to scale to new levels at less cost. I feel like I did when I graduated college-ready to take on the world-but better!

Expect many new posts! Because the original Dathan is back better then evar!

…

MySQL MagazineApril 15, 2008Introducing Kickfire (http://www.paragon-cs.com/mag/issue4.pdf)

eWeek April 15, 2008SQL Chip Gives MySQL Data Warehouse Boost (http://www.eweek.com/c/a/Database/SQL-Chip-Gives-MySQL-Data-Warehouse-Boost/)

Yesterday I had a chance to speak to Igor - head of MySQL optimizer team and Timur - both of them expressed concern with TPC-H run results I posted and notes about little gains in MySQL 6.0.

Do not get this post wrong. I'm not saying MySQL 6.0 SubQuery optimizations are non existent or priorities were wrong, what I'm saying is just they do not seems to be apply to most of TPC-H Queries. I personally (before doing what exactly queries are part of TPC-H) was expecting to see gains in TPC-H and I think this is what other users would expect as well because this is well known set of complex queries which use SubQueries.

So what is the reason ? Why TPC-H queries are not targeted ?

The reason is MySQL Optimizer Team did not have the goal of optimizing TPC-H queries or queries from any other benchmarks, rather they look at …

I spent the day Thursday with some of Kickfire’s engineers at their headquarters. In this article, I’d like to go over a little of the system’s architecture and some other details.

Everything in quotation marks in this article is a quote. (I don’t use quotes when I’m glossing over a technical point — at least, not in this article.)

Even though I saw one of Kickfire’s engineers running queries on the system, they didn’t let me actually take the keyboard and type into it myself. So everything I’m writing here is still second-hand knowledge. It’s an unreleased product that’s in very rapid development, so this is understandable.

Kickfire’s TPC-H benchmarks are now published, so you can see the results of what I’ve been seeing them work on. They …

Got sidetracked in a major way the past few weeks, so “of the day” became something of a misnomer. Hoping to get back on track, here’s a rundown of the latest posts.

Since we’ve had this break anyway, I’m also resetting the “week” to start on Mondays.

(See this post for background information on MySQL Function of the Day)

Week Five:

• Monday, April 7th, 2008: DATE_ADD() :: MySQL Function of the Day
• Tuesday, April 8th, 2008: IFNULL :: MySQL Function of the Day

Week Four

• Wednesday, March 26th, 2008: FORMAT()
• Thursday, March 27th, 2008: …

For years I’ve been against blogging about work and what I do. As has been shown in the press time and time again, you can get in some fairly serious trouble about blogging on work issues and subjects. At BioWare which is a typical closed-source company I always felt a certain self-imposed taboo about talking on what I, my team, or BioWare in general was up to.

However, now I work for an open-source company and in some part I am encouraged to blog and to blog about the things we are doing (within reason, I am subject to most company rules and regulations on blogging, but heck, even my CEO, Jonathan Schwartz blogs). If MySQL has a giant blogging culture, then by sheer size and number we pale in comparison to the bloggers at Sun Microsystems.

If you regularly read my irregularly …