MySQL »
What's New in the MySQL Enterprise Spring 2010 Release? - Interview with Mark Matthews and Andy BangMon, 17 May 2010 00:59:59 +0000
We talked to Mark Matthews and Andy Bang, two core developers in the MySQL Enterprise Monitor team, to give us some insight into the new features in the latest MySQL Enterprise Release.
Introduction to MySQL 5.5
Tue, 13 Apr 2010 01:00:23 +0000
It's been a busy year for MySQL. Perhaps you've heard. Here are some recent improvements to the speed, scalability, and user-friendliness of the MySQL database and the InnoDB storage engine that we think deserve their own headlines. Now is a great time to beta test the 5.5 release and give feedback to the MySQL engineering team.
Why Should I Check Out a MySQL-Based Column Database ?
Fri, 12 Feb 2010 01:00:23 +0000
Some technologies come on the information technology landscape and stay, providing long-lasting benefits, whereas others are more of a short term fad and ultimately end up disappearing because the value they supplied was too niche oriented and/or they were quickly supplanted by another technology that is better. Recently, articles, blogs, analyst reports, and other media outlets have been noting the rise and usage of column-oriented databases in the areas of data warehousing, analytics, and other business intelligence/read-intensive situations. And on the MySQL front, there are a couple of column DB’s that are now available for you to use. Are column-oriented databases a technology that is destined to stay and provide long-term benefits or will it be relegated to the forgotten pile of other software that came on the scene quickly and then disappeared?
A deep look at MySQL 5.5 partitioning enhancements
Thu, 24 Dec 2009 01:00:23 +0000
The release of MySQL 5.5 has brought several enhancements. While most of the coverage went, understandably, to the semi-synchronous replication, the enhancements of partitioning were neglected, and sometimes there was some degree of misunderstanding on their true meaning. With this article, we want to explain these cool enhancements, especially the parts that were not fully understood.
Tino Rachui: Using MySQL Cluster in Sun's Virtual Desktop Infrastructure
Tue, 10 Nov 2009 01:00:23 +0000
Sun Virtual Desktop Infrastructure (VDI3) is a desktop virtualization technology that provides virtual desktop access, brokering, and hosting, enabling Windows, OpenSolaris, or Linux virtual desktops. These desktops can be accessed by using existing PCs, Macs or thin clients such as Sun Ray.
MySQL Database Analytics with InfiniDB from Calpont – Part 2
Wed, 28 Oct 2009 00:59:59 +0000
In Part 1 of this article, I took you through some of the reasons why a column-oriented database based on MySQL can be compelling. We also examined the architecture of InfiniDB, which is an open source analytic, reporting, and read-intensive database, and how its modular design helps you scale both up and out. Now let’s kick the tires of the database so you can see these things in action.
MySQL Database Analytics with InfiniDB from Calpont – Part 1
Tue, 27 Oct 2009 00:59:59 +0000
Let’s be honest: working with big databases is a lot of fun. There’s something cool about dealing with tables that have hundreds of millions or billions of rows in them, loading huge amounts of data, building star and snowflake schemas for data warehouses/marts, optimizing query performance, and all that jazz. Yes, working with big databases is a lot of fun. On the other hand, let’s be honest: working with big databases is not a lot of fun. There’s a lot of pain in dealing with tables that have hundreds of millions or billions of rows in them, waiting for huge amounts of data to be loaded only to have the load job toss its cookies and fail when it’s 99% done, building special schemas that you wonder whether make any difference at all, and trying to figure out why just a simple two-way join query has been hanging for over an hour. Yes, working with big databases is not a lot of fun.
New Version of MySQL Enterprise Allows DBAs to Graphically Drill-Down into Database Bottlenecks to Improve Application Performance
Wed, 09 Sep 2009 00:59:59 +0000
Sun Microsystems, Inc. today announced an update to its MySQL Enterprise™ subscription, designed to assist corporate users improve the speed and uptime of their MySQL™ database applications. Thirty-day trial subscriptions of the new MySQL Enterprise Fall 2009 Release are now available free-of-charge from http://www.mysql.com/trials.
What's New in the MySQL Enterprise Fall 2009 Release? - Interview with Mark Matthews and Andy Bang
Tue, 08 Sep 2009 00:59:59 +0000
We talked to Mark Matthews and Andy Bang, two core developers in the MySQL Enterprise Monitor team, to give us some insight into the new features in the latest MySQL Enterprise Release. You can find more about the MySQL Query Analyzer in our previous interview with Mark Matthews.
Introducing the MySQL Librarian
Tue, 14 Jul 2009 00:59:59 +0000
The MySQL Librarian is a collection of community-generated and cross referenced content related to MySQL. It's a place where the community, collaboratively, builds and maintains MySQL content.
The New MySQL Server Release Model
Fri, 26 Jun 2009 00:59:59 +0000
When I joined MySQL back in June of 2005, one of the first “MySQL Truths” I learned and repeated often when discussing MySQL with others was “release early, release often.” If you’ve been using MySQL for any length of time, you know what that statement means – it meant that MySQL was: (1) dedicated to getting new features and enhancements into the hands of its community so the software’s quality could be validated; (2) eager to take early feedback on those features so the input could rapidly be incorporated back into the product allowing everyone to benefit; (3) committed to very frequent releases of the software so helpful new features and/or external contributions that were ready for action could quickly be put into play and not sit idle on the shelf. And if you’ve been around Open Source for a while now, you know this is the spirit in which most providers of Open Source software operate.
Why Move to MySQL from Microsoft SQL Server?
Mon, 04 May 2009 00:59:59 +0000
Before we get started, let me say that I always liked being a SQL Server DBA. My database experience started with DB2, then Teradata, followed by Oracle, and then SQL Server (and then a little bit of Sybase after that, followed by MySQL). Coming from the other databases, I found SQL Server the easiest and quickest to learn at the time, but of course, a lot of that had to do with the fact that Microsoft was really the only database vendor around then (I started with version 4.2 of SQL Server) that shipped any decent GUI management tools with their server. Take the tools away, and you basically had Sybase on Windows with the ISQL command line tool, which was not pretty by any means.
A Quick Look at MySQL 5.4
Tue, 21 Apr 2009 00:59:59 +0000
Although MySQL 5.1 was released in December of 2008, Sun Microsystems isn't wasting any time moving forward with a number of new and exciting enhancements for its next release, MySQL 5.4. The first item of note is that the MySQL Server will be returning to a release early/often paradigm. So, instead of waiting on a full set of previously agreed upon features to be ready, the goal will now be to adhere to time-controlled releases that include all features that are ready by an agreed-upon beta date, with any features not fully 'baked' simply rolling to the next release. This being the case, MySQL 5.4 won't include some large new features like the Falcon transactional storage engine and the new backup utility, but it will include a number of very desirable enhancements that help your database-driven systems scale better and run faster in many cases. Let's take a look at what's included...
Sun Announces MySQL 5.4: Up To 90% Faster Response Times, and Scalability Up to 16-way x86 Servers and 64-way CMT Servers
Tue, 21 Apr 2009 00:59:59 +0000
Sun Microsystems, Inc. today announced MySQL™ 5.4, a new version of the world's most popular open source database, designed to deliver significant performance and scalability improvements to MySQL applications. A preview version of MySQL 5.4 is available now for download at http://www.mysql.com/5.4. Today's announcement was made at the seventh annual MySQL Conference & Expo being held this week at the Santa Clara Convention Center. With more than 2,000 attendees, it is the world's largest event for open source database developers, DBAs, vendors and corporate IT managers.
Developing Database Applications Using MySQL Connector/C++
Wed, 15 Apr 2009 00:59:59 +0000
The MySQL Connector/C++ provides an object-oriented application programming interface (API) and a database driver for connecting C++ applications to the MySQL Server. Connector/C++ implemented a significant percentage of the industry standard JDBC 4.0 specification in C++ world. This technical article shows the essential steps to build and install MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database. Application developers who are new to MySQL Connector/C++ but not to C++ programming and MySQL database, are the target audience.
Getting started with DTracing MySQL
Thu, 05 Mar 2009 00:59:59 +0000
DTrace is a dynamic tracing facility built into the Solaris and Open Solaris operating systems and can be used by system administrators and developers alike to observe the runtime behavior of user level programs and of the operating system itself. On one hand, DTrace can be used to identify potential bottlenecks in the running processes on a production system and on the other DTrace can help you understand the runtime behavior of an external program such as MySQL better.
Exception Error Handling Implementation in MySQL/VB.NET Windows Database Applications
Tue, 10 Feb 2009 00:59:59 +0000
Error handling implementation in Windows database applications is a must for any Application Developer today. The main idea of error handling is to avoid application crashes by finding out the occurred errors and fixing them. Different programming languages have different ways of implementing error handling. Microsoft Visual Basic .NET (VB.NET) is the most common programming language for developing windows database applications today. VB.NET codes are provided in many websites, books and materials without error handling implementation. In this article I would like to introduce you to the basics of error handling implementation in MySQL/VB.NET windows database applications. I’ll be covering structured exception error handling, which was introduced for the first time in VB.NET 2002. I will also go over the latest technologies of disposing unmanaged recourses in .NET Framework with the Using statement. To write exception errors to a log text file, a generic procedure will be developed while MySQL data is loading, inserting, updating and deleting.
Another Look at MySQL 5.1’s SQL Diagnostic Tools
2009-01-26 02:59:59
Prior to MySQL 5.1, it wasn’t all that easy to find the worst running SQL on a MySQL instance. And truth be told, MySQL still has a ways to go before it’s an effortless process. But, the good news is there are some new aids in MySQL 5.1 and MySQL Enterprise that do make it more efficient to find and troubleshoot bad SQL code that’s hiding inside a MySQL instance. Let’s take a quick tour through these new features and see what help they provide.
Sun Releases MySQL 5.1 -- Boosts Performance & Simplifies Management of Large-Scale Database Applications
2008-12-08 02:59:59
Sun Microsystems, Inc. today announced the general availability of MySQL™ 5.1, a major new release of the world's most popular open source database. Designed to improve performance and simplify management of large-scale database applications, the production-ready MySQL 5.1 software is available for download now at dev.mysql.com/downloads.
Interview with Masood Mortazavi, MySQL Engineering Manager at Sun
2008-12-17 02:59:59
Masood Mortazavi is an Engineering Manager at the Sun Database Group. After the acquisition of MySQL, and along with the rest of Sun's original database technology group, he joined the MySQL organization to form the larger Sun Database Group. In this interview, Masood talks with Lenz about the flexibility and diversity of Sun as a workplace, his life prior to joining Sun and his current assignment to improve the MySQL code contribution process.