ALL POSTS

Why is Database Security So Hard?

I was recently asked a question by someone who had attended my Shmoocon talk entitled “Why are Databases So Hard to Secure?”. (PDF slides are available). I was going to put this into a more formal structure, but the conversational nature works really well. I would love to see comments reflecting others’ thoughts.

The Sun Comes to Boston, Join the Live Videocast!

On Monday, March 10th, Sun makes a stop in Boston on its world tour of “Mashup Meetups”. If you can’t make it in person, join us on the live ustream videocast. We will have Sun and MySQL employees present, and there will be a short (30 min max) presentation on “What is Cluster Good For?”. We will try to broadcast live on ustream.tv if possible.

Good Database Design is Mightier than Hardware

Have you ever heard the one about throwing hardware at a software problem? I have this nifty RAC system that supports some very public and very mission-critical apps, and one day (it was Sunday night) it starts choking. We’re getting enqueues. Slowly they start climbing. Ten nodes came to a crashing halt. I have now seen a ten-node RAC cluster come to crashing halt and completely lock up. Why, you ask? A simple SQL statement: DELETE FROM a WHERE b=c AND d=e;.

Working at Pythian: 3 Months In

I have been a MySQL DBA at The Pythian Group for three months (and 2 days) now. At most companies that is the probationary period, and I am still here, so that is a good sign….. So, after three months, how do I like it? Glad you asked!

Hotsos Symposium 2008 — Still On

The symposia is still ongoing and my head is slowly filling up — relieved from my presentation, finally, I’m able to focus on others’ sessions. I attended Wolfgang Breitling’s presentation on “Active Statistics”. He provided a lot of insights into statistics gathering options and emphasized lots of new features in 11g. Have a look at my post to read about some of the other great presentations I attended.

Oak Table Network

I’m a member of the Oak Table Network now! I’m so delighted and proud to be the part of that group and also very grateful for the invitation to join those bright people.

MySQL Partitioning

I’ve been setting up partitioning for various customers lately. The goals primarily have been easy purging of large growth tables and keeping indexes small enough to stay in memory and manageable. These have all been range partitions on dates, which is a rather common requirement. As you’ve probably noticed in previous posts, I absolutely hate…

Page 222 of 279« First...102030...220221222223224...230240250...Last »