Get Your "Virtual DBA Assistant" Today!
22 December 2004 — It often appears that proponents of open source believe that open source does not actually require much in terms of marketing effort or product development. Seen as a form of evangelism, the open source message is regarded to be so compelling that, once delivered, the audience will "see the light" and convert. In this article, Arjen Lentz explores open source in the real world.
21 December 2004 — MySQL 4.0.23, a new version of the popular Open Source/Free Software Database Management System has been released. This is a bug fix release for the previous production version. It is now available in source and binary form for a number of platforms from our download pages and mirror sites.
20 December 2004 — MySQL Connector/MXJ is a JMX MBean for deploying and managing a MySQL database. This makes it easy for Java developers to deploy applications which require a database by reducing installation barriers for their end-users. This is the first generally available (GA) release, and is available for download in source and binary form on the MySQL Connector/MXJ download page.
19 December 2004 — A new version of the MySQL database, version 4.1.8, has been released. This is a bug fix release for the current production series, and it is now available in source and binary form from the MySQL 4.1 download pages.
9 December 2004 — The MySQL database server features a distinctive modular architecture. The core "upper level" features of the server, such as the network layer, SQL parser, and query optimizer, are separated from the underlying data storage by a well-defined interface. Adding a storage engine to MySQL is a fairly straightforward task, and in this article John David Duncan explains how to get started with your own storage engine.
3 December 2004 — A new version of the MySQL database, version 5.0.2, has been released. This is an alpha release for the current MySQL development branch, and it is now available in source and binary form from the MySQL 5.0 Snapshot download page.
1 December 2004 — MySQL Query Browser 1.1.2, the easiest visual tool for creating, executing, and optimizing SQL queries for your MySQL database server, has been released. This is the first generally-available (GA) release, and can be downloaded from the MySQL Query Browser download page. MySQL Administrator 1.0.15, a powerful visual administration console that enables you to easily administer your MySQL environment, has been released. This is a maintenance release from the production branch, and can be downloaded from the MySQL Administrator download page.
24 November 2004 — We've covered the major features in 4.1, now we wrap up our 'New in 4.1' series with an article about all of the little features. But don't let their small size fool you, some of these features may be just what you've been needing from your database server.
24 November 2004 — Guilhem Bichot shows how to use mysqldump and the MySQL binary log to take incremental backups that can be used to recover from various catastrophes that may disrupt your database server.
24 November 2004 — MySQL Connector/J 3.0.16, a new version of the Type-IV all-Java JDBC driver for MySQL has been released. Version 3.0.16 is a bugfix release for the production tree that is suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0. It is now available in source and binary form from the Connector/J download page.
23 November 2004 — MySQL Connector/MXJ is a JMX MBean for deploying and managing a MySQL database. This makes it easy for Java developers to deploy applications which require a database by reducing installation barriers for their end-users. This is the first gamma release, and is available for download in source and binary form on the MySQL Connector/MXJ download page.
18 November 2004 — Subqueries are another way to get data from multiple tables using a single query, and MySQL 4.1 includes support for this standard SQL construct. Trudy Pelzer explains what this allows you to do, along with examples.
16 November 2004 — MySQL Connector/Net is a fully-managed .NET driver for MySQL. This is the first release of the original ByteFX provider code under the new Connector/Net name. With this version, Connector/Net is now suitable for use with all versions of MySQL from 3.23 to 5.0! This is a gamma release from the current development branch, and it is now available in source and binary form from the MySQL Connector/Net download page.
15 November 2004 — MaxDB is ready for the Web! Or should I say ready for beginners? PHP is known as the “basic of the web”. Rasmus Lerdorf, the inventor of the popular web scripting language PHP used the comparison with BASIC to describe some of the strengths of PHP, the ease of use and the ease of learning. On MySQL ComCon Europe in Frankfurt (8-10.11.2004) a native PHP extension for MaxDB was announced that brings the power of MaxDB to all PHP users. So far MaxDB could only be accessed from PHP via ODBC, but now PHP has gained access to the full power of MaxDB through the new MaxDB extension.
4 November 2004 — The new version 7.5.00.19 of MaxDB by MySQL is now available. This is a maintenance release for the current MaxDB production version. For detailed information on what is new, see the release information. The first version of MaxDB Installation Manager for Windows and Linux is also now available, as well as a new MaxDB extension for PHP.
3 November 2004 — A new version of MySQL Administrator, version 1.0.14, has been released. MySQL Administrator is a GUI management console for MySQL, with support for tasks such as managing users, configuring MySQL, performing backups, editing table definitions, etc. This is a maintenance release for the current MySQL Administrator production version, and it is now available in source and binary form from the MySQL Administrator download pages. MySQL Query Browser is a GUI query shell which allows execution of SQL queries from a web-browser-like, easy-to-use interface. This is a gamma release of the development version of MySQL Query Browser, and it is now available in source and binary form from the MySQL Query Browser download pages
29 October 2004 — MySQL Connector/MXJ is a JMX MBean for deploying and managing a MySQL database. This makes it easy for Java developers to deploy applications which require a database by reducing installation barriers for their end-users. This is the first beta release, and is available for download in source and binary form on the MySQL Connector/MXJ download page.
29 October 2004 — MySQL 4.0.22, a new version of the popular Open Source/Free Software Database Management System has been released. This is a bug fix release for the previous production version. It is now available in source and binary form for a number of platforms from our download pages and mirror sites.
26 October 2004 — A new version of the MySQL database, version 4.1.7, has been released. This is the first generally available (GA) release for the current MySQL production branch, and it is now available in source and binary form from the MySQL 4.1 download pages.
15 October 2004 — A new version of the MySQL database, version 4.1.6, has been released. This is a gamma release for the current MySQL development branch, and it is now available in source and binary form from the MySQL 4.1 download pages.
7 October 2004 — We continue our tour of new and improved features in 4.1 with a look at the changes to the temporal (date and time related) functionality, including support for fractional seconds, time zones, and a small army of new functions for slicing and dicing temporal information.
1 October 2004 — In another look at a new 4.1 feature, Harrison Fisk explains the benefits (and trade-offs) of the new server-side prepared statements and the support for it from various programming languages.
24 September 2004 — With the new version 7.5.00.18, MaxDB is shipping with 64-bit support for Linux/AMD platforms.
23 September 2004 — The new version 7.5.00.18 of MaxDB by MySQL is now available. This is a maintenance release for the current MaxDB production version. For detailed information on what is new, see the release information.
22 September 2004 — For successful migration of enterprise databases running on Oracle, SQL Server, Informix and Sybase to MySQL, you have to choose tools that automate the entire migration process and avoid the risks and hidden costs associated with partial conversion. Dmitry Tolpeko of Ispirer Systems Ltd. explains the issues in migrating to MySQL, and takes a look at some tools to help the process.
22 September 2004 — A new feature just introduced with MySQL 4.1.5 is a totally revamped installer for the Microsoft Windows platform. Michael G. Zinner explains the new installer and how you can use it to get MySQL up and running even more quickly on Windows.
21 September 2004 — A new version of the MySQL database, version 4.1.5, has been released. This is a gamma release for the current MySQL development branch, and it is now available in source and binary form from the MySQL 4.1 download pages.
20 September 2004 — MySQL Connector/MXJ is a JMX MBean for deploying and managing a MySQL database. This makes it easy for Java developers to deploy applications which require a database by reducing installation barriers for their end-users. This is an alpha release, and is available for download in source and binary form on the MySQL Connector/MXJ download page.
17 September 2004 — We continue our tour of new features in MySQL 4.1 with a look at the extended character set handling, including support for Unicode. The article by Jim Winstead also includes a technique for handling UTF-8 data in web forms that copes with broken browser implementations.
16 September 2004 — Eventum is a user-friendly and flexible issue tracking system that can be used by a support department to track incoming technical support requests, or by a software development team to quickly organize tasks and bugs. Eventum 1.3.1 includes several minor enhancements and bug fixes. Eventum is available in source from the Eventum download page.
11 September 2004 — Eventum is a user-friendly and flexible issue tracking system that can be used by a support department to track incoming technical support requests, or by a software development team to quickly organize tasks and bugs. Eventum 1.3 includes a new customer integration API, a custom workflow API, and numerous minor enhancements and bug fixes. Eventum is available in source from the Eventum download page.
10 September 2004 — A new version of the MySQL database, version 4.0.21, has been released. This is a maintenance release for the current MySQL production version, and it is now available in source and binary form from the MySQL download pages.
9 September 2004 — In this article, Anders Karlsson takes a look at the new spatial extensions in MySQL 4.1, which allow for easier manipulation and storage of spatial data in geographic information system (GIS) and non-GIS applications.
6 September 2004 — MySQL Connector/J 3.0.15, a new version of the Type-IV all-Java JDBC driver for MySQL has been released. Version 3.0.15 is a bugfix release for the production tree that is suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0. It is now available in source and binary form from the Connector/J download page.
6 September 2004 — MySQL Connector/J 3.1.4, a new version of the Type-IV all-Java JDBC driver for MySQL has been released. Version 3.1.4 is a beta release of the development tree, suitable for use with any MySQL version including MySQL 4.1 or MySQL 5.0 (and is required when using server-side prepared statements on MySQL 4.1.2 or newer). It is now available in source and binary form from the Connector/J download page.
3 September 2004 — MySQL Connector/MXJ is a JMX MBean for deploying and managing a MySQL database. This makes it easy for Java developers to deploy applications which require a database by reducing installation barriers for their end-users. This is the initial alpha release, and is available for download in source and binary form on the MySQL Connector/MXJ download page.
2 September 2004 — MySQL Connector/Net is a fully-managed .NET driver for MySQL. This is the first release of the original ByteFX provider code under the new Connector/Net name. With this version, Connector/Net is now suitable for use with all versions of MySQL from 3.23 to 5.0! This is a beta release from the current development branch, and it is now available in source and binary form from the MySQL Connector/Net download page.
1 September 2004 — A new version of MySQL Administrator, version 1.0.12, has been released. MySQL Administrator is a GUI management console for MySQL, with support for tasks such as managing users, configuring MySQL, performing backups, editing table definitions, etc. This is a maintenance release for the current MySQL Administrator production version, and it is now available in source and binary form from the MySQL Administrator download pages. MySQL Query Browser is a GUI query shell which allows execution of SQL queries from a web-browser-like, easy-to-use interface. This is a beta release of the development version of MySQL Query Browser, and it is now available in source and binary form from the MySQL Query Browser download pages
31 August 2004 — A new version of the MySQL database, version 4.1.4, has been released. This is a gamma release for the current MySQL development branch, and it is now available in source and binary form from the MySQL 4.1 download pages.
26 August 2004 — A new version of MySQL Administrator, version 1.0.11, has been released. MySQL Administrator is a GUI management console for MySQL, with support for tasks such as managing users, configuring MySQL, performing backups, editing table definitions, etc. This is a maintenance release for the current MySQL Administrator production version, and it is now available in source and binary form from the MySQL Administrator download pages.
24 August 2004 — The new version 7.5.00.16 of MaxDB by MySQL is now available. This is a maintenance release for the current MaxDB production version. For detailed information on what is new, see the release information.
19 August 2004 — Michael "Monty" Widenius is the CTO and co-founder of MySQL AB, and the original developer of much of the MySQL code base. Before Monty went into hiding to dive into work on new features for MySQL 5.0 (and spend time with his newborn daughter), we caught up with him on MySQL 4.1 and the state of the company from his point of view.
11 August 2004 — In this sample chapter from MySQL Tutorial, published by MySQL Press, authors Luke Welling and Laura Thomson explain the basics of transactions, and how the InnoDB storage engine can be used to achieve ACID compliance.
6 August 2004 — Peter Gulutzan takes a behind-the-scenes look at the full-text searching features in MySQL 4.1, including features and quirks not (yet) documented in the reference manual, and the complete default stopword list.
3 August 2004 — A new version of the MySQL database, version 5.0.1, has been released. This is an alpha snapshot release for the current MySQL development branch, and it is now available in source and binary form from the MySQL 5.0.1 Snapshot download page.
19 July 2004 — David Simpson describes the procedures involved with migrating a FileMaker 6 database running on Windows to a MySQL database running on any platform. Additional info is included regarding changes to this procedure which are required to convert FileMaker 7 to MySQL.
8 July 2004 — MySQL Connector/J 3.1.3, a new version of the Type-IV all-Java JDBC driver for MySQL has been released. Version 3.1.3 is the first beta release of the development tree, suitable for use with any MySQL version including MySQL 4.1 or MySQL 5.0 (and is required when using server-side prepared statements on MySQL 4.1.2 or newer). It is now available in source and binary form from the Connector/J download page.
7 July 2004 — Developers often ask for tools that can be used to convert an Access database to MySQL (or convert an MSSQL database to MySQL), without realizing that there is more to migrating an application to MySQL than simply converting data. This article covers the basics of migrating an application from an Access or SQL Server database to MySQL. You can also discuss migration issues on the beta MySQL Forums.
2 July 2004 — The new version 7.5.00.15 of MaxDB by MySQL is now available. This is a maintenance release for the current MaxDB production version. For detailed information on what is new, see the release information.
1 July 2004 — A new version of the MySQL database, version 4.1.3, has been released. This is a beta release for the current MySQL development branch, and it is now available in source and binary form from the MySQL 4.1 download pages.
30 June 2004 — Eventum is a user-friendly and flexible issue tracking system that can be used by a support department to track incoming technical support requests, or by a software development team to quickly organize tasks and bugs. Eventum is used by the MySQL AB Technical Support team, and has allowed us to dramatically improve our response times.
18 June 2004 — Alan Walker and Mike Benzinger of Sabre Holdings share a new pre-compiler for writing C/C++ applications with embedded SQL they developed when making MySQL part of their open source strategy for the leading travel reservation system in the world.
8 June 2004 — MySQL Connector/J 3.1.2, a new version of the Type-IV all-Java JDBC driver for MySQL has been released. Version 3.1.2 is a new feature release for the development tree that is suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0 (and is required when using server-side prepared statements on MySQL-4.1.2 or newer). It is now available in source and binary form from the Connector/J download page.
2 June 2004 — Normalizing your data is the most effective way to decrease storage requirements and increase data integrity. In this article, MySQL AB's Mike Hillyer covers the basics of data normalization.
30 May 2004 — A new version of the MySQL database, version 4.1.2, has been released. This is an alpha release for the current MySQL development branch, and it is now available in source and binary form from the MySQL 4.1 download pages.
28 May 2004 — MySQL Connector/J 3.0.14, a new version of the Type-IV all-Java JDBC driver for MySQL has been released. Version 3.0.14 is a bugfix release for the production tree that is suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0. It is now available in source and binary form from the Connector/J download page.
28 May 2004 — The new version 7.5.00.14 of MaxDB by MySQL is now available. This is a maintenance release for the current MaxDB production version. For detailed information on what is new, see the release information.
26 May 2004 — This sample chapter from High Performance MySQL covers Replication.
19 May 2004 — MySQL Connector/J 3.0.12, a new version of the Type-IV all-Java JDBC driver for MySQL has been released. Version 3.0.12 is a bugfix release for the production tree that is suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0. It is now available in source and binary form from the Connector/J download pages.
19 May 2004 — This sample chapter from High Performance MySQL covers server performance tuning.
18 May 2004 — A new version of the MySQL database, version 4.0.20, has been released. This is a maintenance release for the current MySQL production version, and it is now available in source and binary form from the MySQL download pages.
17 May 2004 — The new version 7.5.00.12 of MaxDB by MySQL is now available. This version includes the first stable release of the MaxDB SQL Database Connectivity (SQLDBC). This is a runtime library that enables applications to execute SQL statements in the database, and to access and modify data. For detailed information on what is new, see the release information.
12 May 2004 — In this article, Mike Hillyer explains the SET datatype, one of the less-well-known MySQL datatypes that could help you optimize your applications. The SET datatype is a string type, but is often referred to as a complex type due to the increased complexity involved in implementing them. A SET field can hold any number of strings from a predefined list of strings specified during table creation.
11 May 2004 — Connector/ODBC 3.51.07 is now available for download. This is a maintenance release, and includes binaries for Linux, Microsoft Windows, Sun Solaris, Mac OS X, HP-UX and IBM AIX.
5 May 2004 — In this article at NewsForce, Brian Aker, Director of Architecture for MySQL AB, reveals his strategies for finding developers.
5 May 2004 — In this part of the series, we compare key aspects of the most popular storage engines, and provide you with guidelines and practical examples to help you decide which engine may be best suited for a particular purpose.
4 May 2004 — The new version 7.5.00.11 of MaxDB by MySQL is now available. Besides tgz packages, now RPM packages are provided, too. For detailed information on what is new, see the release information.
28 April 2004 — MySQL Server features a concept called storage engines, or table types. The server and, in fact, the developer, can choose how and where a database table is to be stored. Programmatically this is nothing special; it is normal practice to divide a program into modules and layers. But it is unique for a DBMS (Database Management System) because a developer or, even, a DBA (Database Administrator) is traditionally insulated from the physical storage methods that the database server may employ. How the data is stored really does not concern them, as the server just takes care of everything. That being the case, a developer or DBA could benefit from knowing a bit more about such things as it may help them to optimize applications. This is an angle that may be applied to many aspects of database servers, but in this article we'll focus on the storage engines.
14 April 2004 — MySQL AB, developer of the world's most popular open source database, today launched MySQL Cluster, a new open source database clustering technology for applications requiring continuous availability. MySQL Cluster combines the MySQL® database with a clustering architecture to deliver 99.999 percent availability to mission-critical database applications. It is the first affordable, enterprise-scale database clustering software.
6 April 2004 — MySQL Server features a concept called storage engines, or table types. The server and, in fact, the developer, can choose how and where a database table is to be stored. Programmatically this is nothing special; it is normal practice to divide a program into modules and layers. But it is unique for a DBMS (Database Management System) because a developer or, even, a DBA (Database Administrator) is traditionally insulated from the physical storage methods that the database server may employ. How the data is stored really does not concern them, as the server just takes care of everything. That being the case, a developer or DBA could benefit from knowing a bit more about such things as it may help them to optimize applications. This is an angle that may be applied to many aspects of database servers, but in this article we'll focus on the storage engines.
5 April 2004 — MySQL AB, developer of the world's most popular open source database, today provided a preview of the news announcements and top attractions expected at next week’s MySQL Users Conference & Expo. The annual conference brings together MySQL users, partners and industry leaders for an in-depth look at the technology and business behind the MySQL® database and open source software. This year’s event is April 14-16 at the Peabody Hotel in Orlando, Florida.
1 March 2004 — Learn the fundamentals of databases and become familiar with MySQL. You'll learn the essentials of relational database management, the SQL language, how to peform an installation, use of graphical tools and more. If you are new to databases in general, or just new to MySQL, this course is for you!
17 February 2004 — MySQL AB is always interested in getting feedback from customers and the open source community on the best way to communicate our licensing policy. In order to continue to gather input, we have a short five question survey.
22 January 2004 — One of the most common sources of trouble for the beginning VB / MySQL developer seems to revolve around which cursor location to use. Related to the cursor location problem is the choice of cursor type and lock type. The purpose of this article is to assist the Visual Basic developer in choosing the proper cursor location, cursor type, and lock type to use when programming Visual Basic (or VB) applications that use MySQL as a back-end database through ADO and Connector/ODBC (MyODBC).
22 January 2004 — Visual Basic can be very loose with it's data types. If you want to avoid worrying about which type of data is coming from your database, you can simply not specify a datatype when you declare a variable, which defaults the datatype to variant. The variant should be avoided whenever possible, as it can be very CPU and memory intensive. This article demonstrates the different MySQL and VB6 datatypes and how they correlate.
22 January 2004 — Mike Hillyer explains why he thinks Visual Basic and MySQL are an ideal combination for application development, and the motivation for his continuing series of articles on the subject.
21 January 2004 — MySQL Administrator is a powerful new visual administration console that makes it significantly easier to administer your MySQL servers and gives you better visibility into how your databases are operating. MySQL Administrator integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface. Now you can easily perform all the command line operations visually, including configuring servers, administering users, dynamically monitoring database health, and more.
21 January 2004 — MySQL AB, developer of the world's most popular open source database, today announced MySQL Administrator, a new open source tool with a graphical user interface (GUI) designed to provide easy management and monitoring of MySQL® database servers. MySQL Administrator is the first product in a new family of open source administrative tools by MySQL AB. MySQL AB is demonstrating MySQL Administrator at LinuxWorld Expo in booth # 451, January 21-23, at the Javits Center in New York.
12 January 2004 — MySQL AB, developer of the world's most popular open source database, today announced that a major new version of its database software, version 5.0, is now available. The new release includes the addition of stored procedures as well as other advances designed to enhance the development of large-scale enterprise database applications. The MySQL 5.0 alpha development release is now available for testing and evaluation by the open source community.
6 January 2004 — MySQL AB, developer of the world's most popular open source database, today announced that it has ported the MySQL® database to the HP-UX 11.i v2 operating environment on the Intel® Itanium® 2 processor. MySQL 4.0, the current MySQL production version, now includes support for 64-bit Intel Itanium 2 processor-based systems running in both the HP-UX and Linux environments. MySQL is also showcasing early support for the Windows operating system on the Intel Itanium 2 processor in MySQL 4.1, the current development version of the MySQL database software.

