Posts by Sheeri Cabral

Source Controlling the Database Schema

The database schema really should be source controlled in the same place as the application code, because otherwise how do you know what changes happened when, and which version of the code goes with which version of the schema. The problem I have is this — being a purist (and by the way, *not* a programmer so there could very well be concepts I’m missing), I really want to source control the DDL/GRANT statements and whatever that are applied to the production database, because that way anyone can see exactly what was run, and I can do a schema backup and compare to the source controlled version.

The Value of Vendor-Neutral Database Certification

A company has come up with a vendor-neutral database certification exam. Some are wondering how much use this will be, as it doesn’t go into vendor-specificities. For me, it will be interesting to see if companies value a vendor-neutral database certification as they would a degree. It seems to cover the same topics, at least from my standpoint.

8 for 2008

Well, Paul Vallee tagged me, and as I haven’t yet passed my probationary period I should probably answer the call…..Eight things about me that aren’t common knowledge:

Web Crawling 1.0

n Stuffing Six Million Pages Down Google’s Throat, Tim O’Reilly brings up a point, and some questions. . . just how poorly the big search engines index small sites with large collections of data . . .But it’s worth thinking about absolute (and temporary) limits to the growth of Web 2.0. What constraints do we take for granted? What constraints are invisible to us? Read more.

OurSQL Podcast Interviewing Brian Aker — Ask Questions

t 2 pm EST (-5 GMT), OurSQL will be interviewing Brian Aker, MySQL’s Director of Architecture, about today’s announcement that Sun Microsystems bought MySQL. If you have a burning question (about the purchase), please comment here. If you’d like to be identified, please leave your name and where you’re from in your comment

OK, Now I Am a Bit Worried

SUN Microsystems just bought MySQL. I don’t know much about SUN internals, but I’m not sure how the company resolves being the primary developer of 2 differing DBMS’s. Since those are the top 2 open source DBMS’s (and there aren’t really any other ones out there, as I don’t count sqlite as a DBMS), there could be a real conflict of interest.

Duplicate binlog-do-db entry — Solution

At the November MySQL User Group, Patrick Galbraith ran into a problem where binlog-do-db was duplicated. It manifests itself like this…Well, it’s a bug. Patrick confirmed that upgrading fixed his bug. Unfortunately, this is an enterprise release. Even more sadly, http://www.dorsalsource.org does not have the source or binaries for the most recent Enterprise version, MySQL 5.0.54.

Handler_read_first MySQL Haiku

With this particular client, I ran a SHOW STATUS, waited 100 seconds, and ran it again. Handler_read_first jumped by about 53. So I wrote down in my notes: first in the index…every other second. Lots of table scans? As soon as I wrote it down I said, “That’s a haiku!” I counted syllables, and it works, but only if you pronounce “Every” with 3 syllables.

Page 23 of 24« First...10...2021222324