A recent photo from Highload.ru

I said in my last post, that we're interested in speaking at MySQL meetups, and I'm happy to say that the Los Angeles MySQL Meetup has taken us up on the offer.

On November 18th, I'll be giving an introductory talk on InnoDB/XtraDB Performance Optimization.  I will be the second speaker, with Carl Gelbart first speaking on Infobright.

What brings me to LA?  On the same day (18th Nov) I'll be teaching a one day class on Performance Optimization for MySQL with InnoDB and XtraDB.  If you haven't signed up yet - spaces are still available.

Entry posted by Morgan Tocker | …

Most common database used with Rails is mySQL but if you ever need to use SQL Server, here is a quick how to.

I am using  Windows Vista, SQL Server 2008, Rails 2.2.

1)  Install  activerecord-sqlserver-adapter gem

 > gem install activerecord-sqlserver-adapter

2) Create a new Login for this new database (say testuser) using SQL Server Management Studio

3) Create a new database in SQL Server 2008 for your project (say testproject) and choose testuser as Owner

4) Create a …

So you have an old Quasar Microwave from the 80’s or 90’s and it’s time to set back/forward the clocks.

I find myself checking online for instructions every six months and finally tinkering to get the clock changed, so for the records this is how you change the clock on a Quasar Microwave.

To set the time on a Quasar Microwave.

1. Press Hold/Clear.
2. Press the Clock button twice.
3. Press the10 Min and 1 Min buttons until the proper hour is displayed (press 10 min once for 10-12, then 1 min once for 11, twice for 12, etc).
4. Press the 10 Sec and 1 Sec buttons until the proper minute is displayed (i.e. press 10 Sec four times and 1 Sec six times for 46).
5. Press Clock to finish setting the time.

Now to either replace this ancient microwave or contact my local representative to have daylight savings time repealed.

MariaDB 5.1 beta is almost out, so it’s time to cover some of its features. The biggest optimizer feature is MWL#17 Table Elimination.

The basic idea behind table elimination is that sometimes it is possible to resolve the query without even accessing some of the tables that the query refers to. One can invent many kinds of such cases, but in Table Elimination we targeted only a certain class of SQL constructs that one ends up writing when they are querying highly-normalized data.

The sample queries were drawn from “Anchor Modeling”, a database modeling technique which takes normalization to the extreme. The slides at anchor modeling website have an in-depth …

MySQL Proxy is a really neat tool. I remember a few years back when I first saw Jan talking about it. Back in those days it was significantly different than it is now, but the concept remains the same: direct your database traffic through a man-in-the-middle. Chris Calender’s post on capturing erroneous queries with MySQL Proxy shows one use for Proxy. But wait. MySQL Proxy is just inspecting the MySQL protocol.

Ohloh is a fun site. It automatically collects statistics and show some useful analytics about your subversion projects. They picked up Kontrollbase when they ran an automated scan against the Google Code website and I saw it using Google Alerts with the ‘kontrollbase’ keyword alert. Check out the page they have for Kontrollbase and give [...]

Dave Stokes posted earlier that the official list of MySQL Certified will be going away. There has been a MySQL Certified Professionals LinkedIn group for almost 2 years now. It's community managed by myself and Dave, and is open to all MySQL Certified DBAs & Developers, as well as recruiters & hiring managers.

-- Mark
mark@thetajoin.com
http://www.thetajoin.com - The Drupal Hosting & Performance CompanyMySQL DBA & Programming Blog by Mark Schoonover

Dave Stokes posted earlier that the official list of MySQL Certified will be going away. There has been a MySQL Certified Professionals LinkedIn group for almost 2 years now. It's community managed by myself and Dave, and is open to all MySQL Certified DBAs & Developers, as well as recruiters & hiring managers.

-- Mark
mark@thetajoin.com
http://www.thetajoin.com - The Drupal Hosting & Performance CompanyMySQL DBA & Programming Blog by Mark Schoonover

Drizzle is one of the really great pieces of technology to emerge from the MySQL diaspora--a lightweight, scalable, and pluggable database for web applications. I am therefore delighted that Marcus Erikkson has published a patch to Tungsten that allows replication from MySQL to Drizzle. He's also working on implementing Drizzle-to-Drizzle support, which will be very exciting.

Marcus has submitted the patch to us and I have reviewed the code. It's quite supportable, so I plan to integrate it as soon as we are done with our next Tungsten release, which will post around 5 November. You will be able to build and run it using our new …

It's been almost two months since I have posted anything on the Scale-Out Blog, as our entire team has been heads-down working on Tungsten. We now have a number of accomplishments that are worth writing articles about. Item one on that list is community builds for Tungsten clusters.

Tungsten community builds offer a bone-simple process to check out and build Tungsten clustering software. The result is a fully integrated package that includes replication, management, monitoring, and SQL routing. The community builds work for MySQL 5.0 and 5.1 and also allow you to set up basic replication from MySQL to Oracle.

Community builds do not include much logic for autonomic management, including automated failover and sophisticated rules that keep databases up and running rain or shine. Those and other features like floating IP address support are part of the …