In my recent SQL work for a large Swiss bank, I have maintained nested database view monsters whose unnested SQL code amounted up to 5k lines of code, joining the same table over and over again in separate subselects combined via UNION operations. This monster performed in way under 50ms, no matter how we queried … Continue reading The Myth About Slow SQL JOIN Operations →

Hey all!

Coming up this Wednesday, August 21st, 2013 at 12:00pm pacific (19:00 GMT) join in to talk about:

• Gerry from Tokutek to talk about B-Tree indexes in InnoDB and fractal indexes TokuDB!
• Schema Versioning
  • How do you manage schema versions in your development pipeline?
  • How are your schema changes deployed? Is it automated?
  • Some automated schema management tools:
    • South — http://south.aeracode.org/ — a DJango (python) friendly migration tool
    • Flyway — http://flywaydb.org/ — A database migration framework for java
    • Liquibase — …

This is MySQL's Bad Idea #573 (after #384, which I've blogged about before) I've just had a terrible experience with a bug report from the jOOQ User Group, related to escaping of backslashes in string literals in MySQL. First, I thought to myself, whatever. SQL doesn't escape backslashes. The only escape character within a string … Continue reading MySQL Bad Idea #573 →

This article is part of a series. You might also like: 10 More Common Mistakes Java Developers Make when Writing SQLYet Another 10 Common Mistakes Java Developers Make When Writing SQL Java developers mix object-oriented thinking with imperative thinking, depending on their levels of: Skill (anyone can code imperatively)Dogma (some use the "Pattern-Pattern", i.e. the … Continue reading 10 Common Mistakes Java Developers Make when Writing SQL →

And all set. Check out the recording:

Hello everybody!

Coming up this Wednesday, July 23rd, 2013 at 12:00pm pacific (19:00 GMT) join in to hear:

• Brandon Johnson from Mozilla talk about an issue he recently worked through with XtraBackup and the process he took to identify and resolve the issues.

And also take part in discussion around:

• How do you apply production schema changes?
  • Do you use pt-online-schema-change?
    • Issues to watch out for
  • Just run the alter!
  • Pull from a pool and apply

Make sure to follow the #DBHangops twitter search, the DBHangops Twitter Feed, or this blog …

So far, I have been blogging about curious RDBMS caveats mostly related to Oracle and MySQL databases. Some examples: You never stop learning about Oracle features NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: MySQL SQL incompatibilities: NOT IN and NULL values MySQL Bad Idea #384 But there are also other databases, … Continue reading 10 Things in SQL Server Which Don’t Work as Expected →

In Part 1 of "SFTP virtual users with ProFTPD and Rails", I introduced ProFTPD's virtual users and presented my annotated proftpd.conf that I used to integrate virtual users with a Rails application. Here in Part 2, I'll show how we generate virtual user credentials, how we display them to the user, as well as our SftpUser ActiveRecord model that does the heavy lifting.

Let's start at the top with the SFTP credentials UI. Our app's main workflow actually has users doing most of their uploads through a sweet Plupload widget. So, by default, the SFTP functionality is hidden behind a simple button sitting to the right of the Plupload widget:

The user can click that button to open the SFTP UI, or the Plupload …

All set, here’s the recording!

Hey there everyone!

Another informative and fun-filled #DBHangOps coming up this Wednesday, July 10th, 2013 at 12:00pm pacific (19:00 GMT). Join the discussion and contribute your experience on the following topics!

• Plugins for MySQL
  • Which do you use?
  • Are there plugins that you want?
• Kernel Parameters in Linux for MySQL, specifically:
  • Linux VM settings
  • Transparent Huge Pages
• InnoDB buffer pool size and settings
  • What works in your environment and why?
• And If there’s time, information about the TokuDB storage engine in …

#DBHangOps for 6/26/13 is all done! Check out the recording below:

Hey everybody!

#DBHangOps is back this week at a slightly earlier time this Wednesday, June 26th, 2013 at 11:00am paciifc (18:00 GMT) . We’ll have special guest Shlomi Noach talking about the open source tools he’s developed to improve a DBA’s day-to-day work.

Be sure to check out the #DBHangops twitter search, the DBHangops Twitter Feed, or this blog post to get a link for the google hangout on Wednesday!

Thanks and see all of you there!

Overview

First off, the important news. Tungsten Replicator 2.1.0 was released today.
You can download it and give it a try right now.

Second, I would say that I am quite surprised at how much we have done in this release. The previous release (2.0.7) was in February, which is just a few months ago, and yet it looks like ages when I see the list of improvements, new features and bug fixes in the Release Notes. I did not realized it until I ran my last batch of checks to test the upgrade from the previous release, which I hadn’t run for quite a long time. It’s …