Just a quick reminder: the Hamburg MySQL User Group meets tonight at 7pm at the usual place. See the invitations on Meetup.com or OpenBC/Xing for details - around 25 people have signed up so far, so we should have a great time. Stefan Saasen will give a talk about Ruby on Rails/Active Record. See you there!

Just a quick reminder: the Hamburg MySQL User Group meets tonight at 7pm at the usual place. See the invitations on Meetup.com or OpenBC/Xing for details - around 25 people have signed up so far, so we should have a great time. Stefan Saasen will give a talk about Ruby on Rails/Active Record. See you there!

I blogged about this earlier but the MySQL Conference for 2007 is fast approaching and the call for papers is about to close.  November 7th is the deadline so you've only got two days left to send in those great presentation ideas.  I'm submitting a couple of sessions so hopefully I'll see you there!

C/ODBC v5 comes with some command-line tools such as MYODBCShell. MYODBCShell can be used to interact with the server. It is similar to the mysql command-line tool but it uses ODBC. MYODBCShell is very useful for problem solving ODBC issues (more on this in a later blog) and for simply trying out commands before using them in an ODBC application.

Here are some of the unique features of MYODBCShell;

• is command-line ODBC tool
• can connect via an ODBC DSN
• can connect via a driver connect string
• can invoke catalog calls like SQLTables, SQLColumns, etc
• can be used in batch
• can wrap ResultSet in HTML

You can use MYODBCShell by entering a command-line shell and executing the command MYODBCShell. You may have to change to the directory where MYODBCShell was installed or get it into your PATH. Execute MYODBCShell without arguments to
get information …

Marten Mickos wrote a blog about "hybrid" business models built around open source technology.  He lists a baker's dozen of models where the software is free but there is a revenue source that comes from somewhere else.  For example, there are models like SugarCRM or Zimbra where the base level product is free, but there are additional "enterprise features", or Mozilla where the software is free, but Google and others pay to generate advertising revenue.  A few of the models are slightly tongue-in-cheek.  Still, if you're thinking of getting into open source as a business, you need to be clear how you will make money.  Otherwise, you end up like Borland in model number 11, where the software is free, but you regret it.

Perhaps readers can throw in their own business …

And the link is...
http://www.mysqlconf.com/cs/mysqluc2007/create/e_sess/

I've submitted some papers on scaling and the storage engine
interface for next year's conference. The call for papers ends on the
7th so now is the time to submit all of those crazy schemes, hacks,
and projects you have put together in the last year :)

by Mark Schoonover & Mike Hiraga


Introduction

I had requirements to develop a multi-terabyte disk to disk backup system. I've used the usual backup to tape options, but once my company got past the 1 TB threshold, it was too demanding for tape. Some of the problems going to tape were:

1.Tape Libraries, big and expensive.
2.Backup window too long.
3.Restoration took a very long time.
4.Storage, and inventory of tapes too time consuming.
5.Very difficult for offsite storage with large amounts of data.

Concept & Requirements

I first read of the idea to use rsync as a way to keep directories synchronized in ?Linux Server Hacks? book from O'Reilly. Recipes #38, #41 and #42 provided a good beginning, and reading through this will give you a good idea on the basics. This …

C/ODBC comes with some command-line tools such as MYODBCInstaller.exe. MYODBCInstaller can be used to; register/deregister a driver or create/edit/remove a DSN. In other words - MYODBCInstaller can be used to manage ODBC system information.
Driver

An ODBC driver must be registered before being used. On most platforms this means adding entries into some text (odbcinst.ini) file. In the case of MS Windows it also means adding entries into the registery. A driver is deregistered by simply removing the entries. One complicating factor is that a UsageCount is maintained. The UsageCount is incremented each time a driver is registered and decremented each time the driver is deregistered. The idea is that the driver files should only be removed if the UsageCount becomes 0.

MYODBCInstaller handles adding/removing entries and inc/dec UsageCount but does NOT copy/remove files - that must be done by the caller. For …

Yesterday, I was testing various backup and recovery methods supported by ZRM for MySQL before 1.1.1 release. ZRM for MySQL requires binary logging to be enabled on the MySQL server. I ran out of disk space during testing and removed the binary logs. Accidently, I deleted the last binary log used by MySQL server. MySQL server uses the most recent binary log.

I could not start MySQL server again.

# service mysqld start

061031 17:38:48  mysqld started
061031 17:38:48  InnoDB: Started; log sequence number 14 1645228884
/usr/libexec/mysqld: File '/var/lib/mysql/mysql-bin.000017' not found
(Errcode: 2)
061031 17:38:48 [ERROR] Failed to open log (file …

This is a description of a simple backup strategy for MySQL. At the time of this writing, we were using MySQL version 4.1.21 in a master-slave replication configuration, described in a previous article . The replication setup forms a basis for the backup strategy and makes backup very easy while providing 24/7 planned uptime on the master MySQL server.