During this week, expect there to be a flood of posts on Planet MySQL. If you’re using an offline RSS reader, you might not even get all the RSS feeds (might I suggest something like Google Reader?). If you want to be informed as and when something hits Planet MySQL (say, on your mobile phone or via IM), there’s a Twitter feed available - Planet MySQL on Twitter!

Also, on the wiki, I’m trying to keep track of all blog posts (notes) from the conference. Please do help, if something slips to the cracks. Its organised by day, and and by talk topic. All slides will obviously make it to the conference page after the conference is over, so there will be further linking a little later…

If you’re hip and have a Facebook account, do become a member of the …

Here is the quick notes from MySQL Cluster by Stewart Smith session that I attended today in the MySQL conference 2008.

• What it is
  • Clustering of in memory databases in a shared-nothing system
  • Designed for HA, 99.9% Uptime (not really) and sub-second failover
  • Supports Hot (online) consistent backup along with compression
  • No locks are used during the backup as NDB uses a global counters
• Think as virtual file system
• Redundancy
  • NoOfReplicas (1,2,3,4), For production use 1 or 2 but don’t use any other as it may have bugs (2 is preferred and well tested mode)
  • 1 means no redundancy (a node fails and cluster fails)
  • 2 means two copies …

I’m at the MySQL Conference and the t-shirts I created for Maatkit have arrived. Come get yours! They are high-quality, attractive shirts you’ll be proud to wear, and they are a nice rich wine-red color.

Harrison Fisk (co-author of MySQL Clustering) got the first one, because he told me that he recommends Maatkit to MySQL Support customers about twice a week. I made sure to save one for Jay Pipes too, because his luggage got lost so he has nothing to wear. Unfortunately, I didn’t make any Maatkit underwear, sorry Jay. Now I know what to do for next year…

…

Today is the opening day of the MySQL User Conference - so I thought I'd describe a recent customer interaction related to the acquisition.

A few weeks ago, I was visiting the Chief Information Officer of a large commercial institution. He had with him the company's Chief Technology Officer, Chief Information Security Officer (known as the "see-so"), and a series of lieutenants from various parts of their (large) development organization.

The Sun team had spent the day reviewing our progress together, and was finishing up with a product roadmap presentation. From what I sensed, it'd been a good day, so when I arrived, it was mostly to say thanks for the business, and ensure everyone had my contact info in the event I could help out going forward.

We had just closed the acquisition of …

I made it to the US safely, even though I almost missed my connecting flight in Heathrow (even my luggage made it, hooray!). I reached the Hotel just in time to directly head off to the traditional pre-conference party at Mårten's house. However, we just stayed there shortly (barely long enough to say hi to everybody) and then headed to the MySQL pre-conference dinner (organized by Arjen). It was nice meeting such a large number of the key MySQL community people in one place! I was especially surprised about the presence of Jonathan Schwartz and Rich Green - this added a nice touch!

Today I am attending Stewart's …

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)