BusinessWeek's Sarah Lacey has a good article on two significant trends in the industry: On Demand systems and Open Source software.  Whether it's Salesforce.com, RightNow or new stealth mode companies like Dave Duffield's WorkdDay, there's an argument that says that the old model of selling expensive Enterprise software for on-site installation is going the way of the dodo.  Why pay millions and spend two years to implement a complex beast of a system when you can get results in weeks with the On Demand subscription models? 

Having been through several failed on-site CRM implementations over the last ten years before …

I spent Monday writing a document to summarize the current MySQL system architecture and lay out the plan for where we're going with scaling our MySQL architecture at OpenAir. Yesterday I met with the CTO and the Director of Engineering (my manager) to go through the plan, which has evolved considerably since I started working on it. The three of us have been meeting somewhat regularly since I took the helm of all things MySQL.

This is not the document, it is a summary of what's in the document. For our environment there are three major things to think about when it comes to scaling up MySQL; performance, redundancy, and monitoring.

Performance

A key component of scaling MySQL is taking steps to make sure we're getting the most from your existing systems. For us this has primarily been performance tuning to process queries faster. The more we can get out of existing …

MySQL on Mac OS X: An Ideal Development Combination

They got one bit a bit unclear. They say “In fact, the development team at MySQL AB uses the Mac platform for developing the MySQL server software itself.” Which is misleading at best if not downright wrong.

Yes, some people do use MacOS X. But some also use Microsoft Windows, some FreeBSD and a lot use Linux (various flavours - mine’s Ubuntu). The way their sentence reads is that we only use the Mac platform. This, is wrong. They even quote Brian later on as saying that “A significant number of the developers inside MySQl …

It's seems that Mac OS X has become the OS of choice for many people that wanted to get away from Windows or got too frustrated with Linux on the desktop. MySQL has been ported to OS X a long time ago and is even shipped as a component of OS X Server. The Apple Developer Connection now has a nice article about using and developing MySQL on OS X, including many quotes from Brian Aker.

Hmm. Planet MySQL was close to unreadable for me this morning. Also, I had a technical discussion on writing style with a colleague just a few weeks ago, so I might as well take what I explained to him and put it into a form suitable for Planet MySQL. Please note that this is how I see things. This may or may not coincide with Arjen's view or the view of MySQL AB.



If you write blog entries for a blog that is being picked up by a planet, you are writing for a larger audience that for your own blog, and that audience may have other goals and intentions than regular readers of your blog. Here are a few things to keep in mind:

Regular readers of your blog are coming specifically to you because they share a lot of interestes with you regarding the topics you cover. You can go into a lot of depth and you can assume a lot of context.

When your blog is being picked up by a planet, things are …

Views are a great feature which is available as of MySQL 5. A view can be seen as a named and persistently stored SELECT expression. After defining the view it can be referenced just like a table in other queries.

Metadata for MySQL Views can be queried using the TABLES and VIEWS tables from the information_schema. This can be very helpful when maintaining or developing views.

However, this metadata would be even more valueable if it would provide …

I was writing this in an email to a co-worker today, could possibly interest people in the outside world as well. It’s a good idea to look at the source at the same time as reading this :)

In ha_ndbcluster::write_row(byte*),

if (table_share->primary_key != MAX_KEY)
{
/*
* Increase any auto_incremented primary key
*/
if (has_auto_increment)
{
THD *thd= table->in_use;

m_skip_auto_increment= FALSE;
update_auto_increment();
/* Ensure that handler is always called for auto_increment values */
thd->next_insert_id= 0;
m_skip_auto_increment= !auto_increment_column_changed;
}
}

We set next_insert_id to 0 so that in handler::update_auto_increment() we end calling the handler and never doing it just inside the server.

The handler function that we end up in is: …

In sqlcmd, you can connect to a different server by this command:

:connect MyServer

The above command will attempt to use integrated / Windows Active Directory authentication. To use traditional Sql Server authentication, use this instead:

:connect MyServer -U MyLogin

You can do the same kind of thing in Oracle Sql Plus by using this command:

conn[ect] MyLogin@OracleSID

For mysql command line, use this:

connect -h MyServer -u MyLogin -p

That is assuming that you are allowed to login to the MySql server from whereever you are now.

DUBLIN, Ireland -- MySQL AB is seeing increased growth and momentum in EMEA, resulting in further expansion of its European corporate sales office in Dublin, Ireland. This is a result of unprecedented demand for MySQL database software in Europe. Recent major European customer wins for MySQL include Afnor, Alcatel, neckermann.de, Nokia, Pricer, Sagem Monetel, SEAT Pagine Gialle, Shunra, United Nations' FAO, Virgin Mobile, Waitrose, and Ya.com.

InnoDB is a special case among MySQL storage engines because they have clustered indexes, which means surrogate keys have to be treated differently in InnoDB. This article gives a quick overview of clustered indexes, and explains why they make it even more important to do careful analysis before making decisions about surrogate keys on InnoDB tables. Overview of clustered indexes in MySQL A clustered index is just like any other index, except the index holds the data itself, in index order.