There are several ways to take backups (some good, some bad, and some will depend on your situation). Here's the thought process I use for choosing a backup strategy.

1. 
   
2. mysqldump
   If your data set is small (I realize "small" is a relative term.. to qualify it, let's say

• backup everything or just certain databases or tables
  
• backup only the DDL
  
• optimize the dump for a faster restore
  
• make the resultant sql file more compatible with other RDBMSes
  and many more things.
  

However, the most important options are related to the consistency of your backup. My favorite options are:

• --single-transaction : this option gives a consistent backup, if (and only if) the tables are using InnoDB storage engine. If you have any non-read-only MyISAM tables, then don't use this …

Installing Apache2 With PHP5 And MySQL Support On CentOS 5.3 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 5.3 server with PHP5 support (mod_php) and MySQL support.

Tungsten clustering and replication has been accessible as open source for almost a year, but it has taken us an amazingly long time to get our contribution policy set up. The dithering ended promptly after Monty Widenius wrote an excellent blog article on dual-licensed software from his experiences at AskMonty.org and previously at MySQL AB. One of the things I especially like is Monty's emphasis on contributor rights. Contributor rights create the sense of reciprocity that makes open source function effectively as a development model. Tungsten is henceforth adopting the AskMonty.org contribution model.

So, if you want to contribute code to Tungsten (I'll describe shortly why you might …

A new release of the PrimeBase Media Streaming engine is now available for download at
http://www.blobstreaming.org .

The main focus of this release was to provide the features required to make PBMS production ready and with the addition of transaction support and engine level backup I think it is almost there. The engine does not yet provide engine level replication but it will in a future release.

What's new:

• PBMS now provides two methods to backup the BLOB repository which are documented here.
  
• PBMS now supports transactions independently of the storage engine.
• There is now a PHP extension for PBMS. Check it out! …

With a tongue in cheek, humorous tone, we turn the tables upside down on database best practices, illustrating all of the things you shouldn’t do, and what might happen if you ignore those important tasks.

 7 Ways To Crash A Database

I'm pleased to announce the release of Spider storage engine version 0.18.(RC)
http://spiderformysql.com/

The main changes in this version are following.
- Add table parameter "use_pushdown_udf".
- Add server parameter "spider_use_pushdown_udf".
  "use_pushdown_udf" and "spider_use_pushdown_udf" are used for sending UDF string to remote server if engine_condition_pushdown is used.

From this version, you can use '\r' and '\n' like a space between table parameter name and table parameter value.
Thanks to Akihiro for report.

Please see "99_change_logs.txt" in the download documents for checking other changes.

Enjoy!

In my last post I included some sample data which was useful for playing around with queries (once I published it, I realized it made my post look like some form of keyword stuffing, fortunately I don’t use adsense on my site so I hope I’m free of any suspicion :D). That sample data was … Continue reading Generating data with dbmonster →

Related posts:

1. Generating random salts from bash From the ‘just because it can be done’ column, here...
2. Using the ENUM data type to increase performance While going through the DATA TYPES section of the Certification...

We’re proud to announce the first service release of our current GA product MySQL Workbench 5.1. This maintenance release encompasses a number of stability, performance and quality improvements.
We were able to fix 56 bugs – as always, details on latest changes can be found on our Releases Page.

Please head over to our download page and fetch this new update:

http://dev.mysql.com/downloads/workbench/5.1.html

In addition to the improvements on the application, we also updated our packaging procedure to provide a more up to date selection of packages for recent distributions. Along with the Windows and OSX (intel) binaries we now provide binaries for the following Linux distributions:

Ubuntu 8.04  …