Category Archives: MySQL

OSCON 2011 this week

Open Source Convention OSCON 2011

Open Source Convention OSCON 2011

OSCON 2011 starts off this week on Wednesday July 27th with keynotes by Jono Bacon from Ubuntu, Jim Zemlin of the Linux Foundation and Karen Sandler of GNOME Foundation. Through the week, OSCON also brings some excellent topics on open source in mobile, education, cloud as well as open source tools and technologies including PHP, Ruby, Javascript and HTML5.

The conference proceedings are being streamed live.

A couple of talks I would like everyone reading this post to attend include a talk on creative techniques for loading web pages for Wikipedia by Trevor Parscal and Roan Kattouw from my team (Features Engineering at Wikimedia Foundation) as well as a talk on how to raise millions of dollars using open source by Arthur Richards from Wikimedia’s fundraising engineering team. Go Team!

Meet CUBRID: One of Korea’s Top Open Source Projects

A Conversation with Jay Kim and Esen Sagynov of CUBRID.

www.cubrid.org

www.cubrid.org

I participate at the MySQL Conference in Silicon Valley every year and look forward to the diversity of ideas, projects and companies that represent the ever-growing open source database landscape. This year, CUBRID, an open source database project backed by a company from South Korea, caught my eye. What was most impressive to me was the team’s enthusiasm about open source software and its belief that an open source model can work for developing good software and, at the same time, for building a healthy services business in Asia as well as globally.

CUBRID’s team from Korea proudly announced its participation in the global open source ecosystem through the example of its open source relational database project at the conference. I talked with Jay Kim and Esen Sagynov from the CUBRID team about their experience building an open source database in Asia, growing the CUBRID community and increasing its adoption. Here is what they had to say.

1. Tell me about CUBRID?

CUBRID is an open source relational database highly optimized for web applications. In the summer of 2006, NHN, Korea’s top portal and search engine joined the CUBRID project as a major co-developer. After two years of development, in October 2008, CUBRID became an open source project with a GPL v2 or later license. Code development was initially hosted at http://dev.naver.com/projects/cubrid, a CUBRID development project site in Korea. As of October 2009, the project has been now setup at Source Forge.

NHN’s experience in database development and supporting its numerous on-line services provided a great opportunity to develop and scale CUBRID to handle large concurrent requests.The latest version CUBRID 2008 R2.2 was released in May 2010, the next version CUBRID 2008 R3.0 is expected to be released this summer.

2. How has CUBRID used the open source model for development?

CUBRID’s presence in the open source industry has already brought many changes. It is one of the leading open source projects in Korea. With the help of its open source community, CUBRID has been able to deliver 8 releases of CUBRID DBMS at an interval of 1-4 months, twice more frequent than other database providers.

From our experience in Korea, we are trying to develop CUBRID Cluster and CUBRID Manager, a client GUI database administration tool, and spin-off projects with many other developers. All of these projects come to live and continue to be developed because of the open source community. We feel that we create value for both users and developers around CUBRID.

The open source model has helped us not only facilitate development of third-party applications and tools for CUBRID DBMS but also helped generate new ideas and encourage more users.

3. How do you see CUBRID playing in the US market, especially since you have to compete with larger, more entrenched competitors like Oracle and MySQL?

The U.S. has always been the land of opportunity. CUBRID envisions its niche in web applications. Instead of competing with the market leaders, CUBRID is positioned in a slightly different way, being a database highly optimized for web apps, particularly those which drive extremely high traffic with prevailing READ-transactions. It provides enterprise level features for all users under GPL and BSD license.

CUBRID is being used in NHN’s numerous on-line services running on vast amount of servers in several environments, supporting scalability, stability and high performance. This allows CUBRID to support users’ requirements and their bug reports more rapidly. In addition, the average response time at CUBRID Community forum in the fourth quarter 2009 was only 3.6 hours.

We believe, CUBRID can attract users, including enterprises, who really value their own customers and this is the right time for them to get acquainted with CUBRID.

4. Why did you select GPLv2 as CUBRID’s license?

Unlike other databases, CUBRID does not distinguish our license policy between community and enterprise. There is only one version under GNU General Public License version 2.0 or later for the database server engine and under BSD license for the APIs and client tools. This CUBRID Open Source License Policy benefits both companies as well as community users.

We adopted the BSD license for our APIs because we do not want to impose any limitations for developing and distributing valuable products on the top of CUBRID. However, the core part of CUBRID, i.e. the database server engine itself, adopted the GNU General Public License so that any improved features on the server engine can be shared with many other users. For more information, see CUBRID’s Open Source License Policy.

5. How large is CUBRID’s user community?

We’ve gathered statistics related to CUBRID users since its first launch in October 2008. The number of total downloads has topped over 51,000 and latest statistics indicate a growing number of downloads with 3,200 downloads in May 2010 (per month). Also, the number of CUBRID Open Source community web site visitors increases daily. Last April, over 3,000 unique users visited CUBRID project home page.

Currently, there are over 20 active CUBRID open source contributors in Korea. There are also core developers in Romania and China. We are eager to support all interested developers and users to help grow interest in CUBRID. Considering our assumption that Korean database users account for only 1% of the entire global market, we believe the CUBRID community will grow very rapidly in the near future.

6. Has open source helped you grow CUBRID’s user community and convert them into paying customers?

Definitely, yes. Open source, as a whole, facilitates CUBRID development in a number of ways, including improved user awareness and faster adoption, stronger competitive positioning in the database for web industry, and, most importantly, a large base of users to find and report bugs and recommend improvements to CUBRID.

As open source is one of the today’s hot topics, most users and developers positively respond to the idea of holding Open Source Conferences and CUBRID Events. Therefore, we annually hold a CUBRID Bug Bash event. We bring together our experienced software engineers and CUBRID Community users and developers to search for and fix bugs in CUBRID and make code enhancements. NHN IdoCode (Summer of Code) is a large event to bring together professional software developers and enthusiasts to create new or port existing open source software for CUBRID. Those highly interested in open source development eagerly participate in the event and submit significant contributions to CUBRID Project. For instance, WordPress, phpBB, and MediaWiki have been extended to use CUBRID as the database server by our community contributors.

Ubuntu Users Community Guide is a Linux related event CUBRID also takes part in to facilitate the adoption of and software development for Linux Ubuntu OS. CUBRID also recently became a Linux Foundation Silver Sponsor. Linux’ strengths in the enterprise translate into major advantages for supporting web-based businesses. It’s ability to enable seamless high-volume transactions and high performance server/client infrastructure are among the reasons CUBRID has become an active member of the Linux development community and the Linux Foundation.

Additionally CUBRID supports various conferences like JCO Java Developer Conference, Advanced Computing Conference, attends global and local conferences like the O’Reilly MySQL Conference & Expo and Asia-Pacific Web Technology Conference.

We also organize an annual technical seminars called “CUBRID Inside” for our community developers. We discuss various details and challenges around CUBRID, including its three-tier architecture, CUBRID Quality Assurance process, CUBRID Heartbeat implementation, and so forth. As a result, we’ve experienced growing interest in CUBRID DBMS from developers and enterprise users, especially in the local market (Korea).

Nowadays, CUBRID is being actively used by IT industry leader in Korea – NHN Corporation, which deploys a farm of over 10,000 servers. In addition, large hosting companies Cafe24 and Mireene, software company ESTsoft, and many Korean local colleges manage their data with CUBRID. Two third of all CUBRID references come from the government sector. The Korea National Tax Service, Korea Ministry of Public Administration and Security, Korea Ministry of National Defense, Busan Transportation Corporation, and Korea White House are major customers who deployed CUBRID as their major database management software. Just imagine how much sensitive data they all have, how much security they all require – they all chose CUBRID as their database.

7. How would you attract newcomers to your community? What benefits can they expect and how can they contribute?

We often organize events for our community members to encourage their enthusiasm. We hold online seminars to share our knowledge, or bug bash events and distribute prizes for contributors. By participating in these events, newcomers can gain valuable knowledge in development and can share their knowledge with other.

We have enough interesting and exciting projects within CUBRID to get involved in, such as introducing a number of new query-embedded functions, porting existing open source projects for CUBRID, developing a newer version of CUBRID native libraries, and so forth. Besides major development activities, CUBRID community members are welcome to add to CUBRID’s on-line Universal Knowledge Repository by contributing better documentation, more code examples, easy-to-replicate examples, and comprehensive tutorials. Likewise, reporting bugs and providing feedback are also valuable for the community.

We want the CUBRID community to not be a place just to come and go, but to be a community where users stay and enjoy the rapid development process, something most newcomers are seeking for. To make CUBRID projects more beneficial to all, we always welcome any suggestion in every possible way from YOU!

Thanks Jay and Esen for taking the time to talk about CUBRID. Good luck!

MySQL Week Kicks Off in Silicon Valley

A Conversation with Colin Charles, Chief Evangelist at Monty Program Ab

O'Reilly MySQL Conference & Expo 2010

A lot has happened in the MySQL world since last year’s conference in Silicon Valley. Oracle’s acquisition of MySQL through its purchase of Sun has led to increased diversity and opportunities for the entire MySQL ecosystem. The conference this week in Santa Clara brings it all together and showcases the latest happenings. I chatted with Colin Charles, program chair for the conference, about his expectations for the event.

What do you hope the MySQL Conference will accomplish this year?

I hope that we’ll see us going beyond MySQL being a company, or a trademark. I believe that if people understand that this is one large ecosystem, where we have some outright forks (like Drizzle), and some branches (like MariaDB, etc.), we’re all helping make the MySQL ecosystem a more vibrant and better one. Like features being funded, etc. It’s completely amazing!

What great new things is MySQL planning for this year?

I can’t quite say this considering I have no idea what Oracle’s plans are. But I can expect things like MySQL 5.5, a lot of talk with the storage engine vendors, new happenings with InnoDB. This year, I expect a lot of things within Oracle to be “settling down”, so to speak.

From a MariaDB perspective, we’re taking in more community patches (an example is virtual columns that have been sitting around on the MySQL patch queue for quite some time – so we’re picking up the slack). We’ll also focus on engines. We want new optimizer features, which we’ve been spending a lot of time on.

Drizzle? I think a release is imminent. There are more and more users in various pockets now as well. And the team is quite distributed, with Rackspace being one of the major hirers of Drizzle hackers.

What is the role of MySQL in relationship to other Oracle products such as Oracle Database 11G and BerkeleyDB.

There is really no relationship. These are all independent products. How will this be sorted in Oracle land when it comes to selling Cluster NDB against Oracle RAC/Times Ten? Or MySQL against Oracle? I think Oracle will allow internal competition. Competing against yourself is a lot better than competing against others.

BDB was a MySQL engine. It now has an SQLite front-end.

How has the MySQL landscape changed with offerings like MariaDB, Drizzle, XtraDB and others?

Drastically. Now people have a choice. Drizzle is a complete fork of the 6.0 tree. MariaDB is based on the current release HEAD of MySQL, which is 5.1. XtraDB is an engine that’s included in MariaDB. In fact, MariaDB includes engines like PBXT, XtraDB, FederatedX (modified Federated engine that MySQL no longer maintains), and will soon include the Spider and Sphinx engines.

What do you think of NoSQL? Is it complementary to MySQL?

NoSQL is for very smart people with very specific uses. I think you’d have to understand how an RDBMS like MySQL works, and figure out that, for your specific use, it doesn’t do the trick. Then you might use one of the new utilities, all lumped as “NoSQL” databases.

It will be a growing player, and we’ve focused on this at the conference this year. Maybe next year, we’ll have a whole track or two, as steam is picking up amongst all these solutions, and a lot of shops run MySQL and some NoSQL solutions at some stage… especially the big shops!

LAMP flickers with MySQL acquisition by Sun

Sun Microsystems announced today that it will buy MySQL for a billion dollars, paying off the MySQL founders and investors.

For only a billion dollars… Now, that’s a steal, don’t you think? If MySQL had gone IPO perhaps they could’ve raised 5 billion dollars or more – I believe they could have because the open source market is only growing stronger. On the same day, Oracle announced its acquisition of BEA for 8.5 billion dollars – just for acquiring market share. So a billion dollars for MySQL seems cheap.

How does this affect Linux? Sun has marketed open source initiatives such as OpenSolaris, Netbeans, GlassFish and OpenOffice. Now MySQL joins that list. MySQL is a key player in the Linux solution set. Linux could benefit if MySQL is provided with more resources to help build more powerful open source solutions. Linux could be hurt if MySQL becomes more encumbered and less free.

2008 promises to be an interesting year for open source. Let’s hope Sun will play to its strengths of great engineering and innovation and support the entire open source community. This means Linux too.

Some interesting comments on this acquisition:
1) Glyn Moody
2) Groklaw
3) Matt Asay
4) Motley Fool