Select Page

Blog

Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.

Category: MySQL
Browse All Categories

Percona Server Goodies

I’m posting to describe some of the features and improvements that I have been utilizing with the Percona Server with XtraDB MySQL distribution, as well as Percona’s XtraBackup. If you don’t already know, Percona Server XtraDB is a backwards-compatible MySQL distribution with XtraDB, an enhanced version of InnoDB. It runs faster, has better performance and is easier to monitor and tune.

Patrick Galbraith | December 31, 2010

YPDNGG: You Probably Don’t Need Golden Gate

Before launching into this, I must give due deference to Mogens Nørgaard’s landmark article, You Probably Don’t Need RAC (YPDNR), available here, but originally published Q3 2003 in IOUG Select Journal. Mogens showed that you can be a friend of Oracle without always agreeing with everything they do.

Jeremiah Wilton | November 22, 2010

MySQL Editions and Support- what do I get with community?

The new licensing that was announced by Oracle earlier this month caused some FUD in the community that was addressed last week in an updated graphic comparing support and binary options and blog post from Oracle. However, one of our customers sent me this earlier this week.

Sarah Novotny | November 22, 2010

Defining MySQL Backup Strategies

Backups may seem like a complicated subject, but they can be simplified into one multi variable question. What $DATA is so important that you don’t feel you could be missing it for $TTR and you can’t lose more than $RPO of it? I am using the acronyms TTR to represent the time to recovery objective and RPO to represent the recovery point objective.

Sarah Novotny | November 4, 2010

InnoDB tablespace fragmentation (find it and fix it!)

If you frequently delete rows (or update rows with variable-length data types), you can end up with a lot of wasted space in your data file(s), similar to filesystem fragmentation. If you’re not using the innodb_file_per_table option, the only thing you can do about it is export and import the database, a time-and-disk-intensive procedure.

Mike Hamrick | October 22, 2010

Debugging Stored procedures

Over the past several weeks, we’ve been working on debugging a stored procedure bug for a client. Coming from a software development background, I looked at the procedure like any piece of code — how can I debug the program and be able to use some means of knowing the values within the program while it’s running?

Patrick Galbraith | October 15, 2010