Showing posts with label Strategic Directions and Trends. Show all posts
Showing posts with label Strategic Directions and Trends. Show all posts

Monday, February 9, 2009

Recent MySQL Trends

In working with customers every week I am seeing some trends that I would like to share with everyone.
  1. There is a tremendous upswing in Oracle customers looking at MySQL. A year ago about half the customers were evaluating MySQL, now I am seeing about 90% saying they have been mandated to look at using MySQL for future DBA projects.
  2. Must stronger acceptance by the traditional Oracle DBA as to the features and benefits of MySQL.
  3. A large number of customers new to MySQL are not very knowledgeable about the environments surrounding MySQL database servers. Mention words like Memcache, InfoBright, KickFire and most customers are not sure what they are.
  4. Customers are still using a wide variety of tools to monitor and manage MySQL database servers. However, I do see an upswing on customers looking at the MySQL Enterprise Monitor.
  5. Too many customers underestimate the need to get their administration teams trained on performance tuning and advanced database features. MySQL is a database server that needs to be tuned and managed correctly just like any other database server. Too many customers think all they have to do is install it and they are done.
  6. There is a lot of interest in MySQL version 6 with the new optimizations, storage engines and availability features.
  7. Too many customers are not sure on whether to use Ruby, Groovy, Java, .NET, PHP, etc. I am constantly surprised on how customers are still trying to figure out the best tools to use for development for specific projects. Maybe this will never change.
  8. More and more web developers do not understand how to write good database code. This leads to big performance issues down the road when database usage begins to go up.
  9. Web developers are almost never using database vendor specific features. They want databases that are fast, easily deployable and easy to work with.
  10. From my perspective in working with customers, MySQL is growing at the fastest rate I've seen in the last few years. Is their any area of technology that is growing faster than MySQL?

Friday, December 19, 2008

Evolving trends and directions for DBAs and Developers: How do DBAs stay marketable?

I visit a large number of organizations every year to deliver training, short term consulting as well as business and technology seminars in the area of database servers, security, software development and middle-tier technology. So I thought I would share some of the trends I have seen in 2008 that I believe will continue in 2009.

I'm always being asked the following questions; "How do I stay marketable?" or "What trends are occurring in technology that impact DBAs and Developers?". The trends are pretty obvious, the question is what conclusions do we draw from them.

IT Continuing Trends for 2009

Some of the noticeable trends:
  • Common DBA skills (administration, backup/recovery, tuning) are becoming more of a commodity and easier to outsource every day. A recent quote from a high end recruiter "I don't have any use for technical DBAs. Now applications DBAs are worth their weight in gold".
  • Oracle Application DBAs (Financials, ERP, Hyperion, ...) are becoming more valuable and marketable every day. This is the skillset of the future, not the basic technical DBA skills.
  • Middle-tier applications increase in importance and visibility. The key in most organizations is their middle-tier business applications (vendor and custom). An Oracle database license can be a few million dollars. An Oracle or SAP Financials implementation can cost 100 million dollars. I wonder where an organization will place their emphasis?
  • Oracle Fusion Middleware skills (Oracle Application Server, web services, BPEL, SOA, XML, ...) are becoming more valuable than ever. As Oracle Fusion applications roll out in the future, these middle-tier skills will increase in marketability and demand.
  • Middle-tier architecture skills working with application servers, middle-tier caching, web services, J2EE, PHP, Ruby on Rails are increasing in demand.
  • Architectural skills and high availability expertise across all tiers are needed more than ever. If a system is slow, there has to be people that can do problem resolution and performance tuning across all tiers.
  • Cross platform expertise. DBAs that can support Oracle, MySQL and SQL Server environments are more valuable than a technical DBA that can only support one environment.
  • Virtualization will increase significantly. Oracle's VM and Sun's VM (Containers, Zones) will see an increase in database and application servers running production environments using VMs. Sun Containers are a very powerful way of setting up cloning and failover. So VMs not only provide very cost and environmental effective ways of implementing servers but offer significant advantages in administration and high availability. One of the biggest success stories with Sun Containers was an Oracle Hyperion implementation that the consultants told me that can't now imagine implementing this any other way.
  • Open source will continue to see significant growth in the next year. The reduced cost and flexibility of open source solutions will significantly help organizations be cost effective and competitive.
The best present you can give yourself for the next year is to learn new skills to increase your marketablity and value to organizations.

Saturday, March 22, 2008

MySQL Growth in the Database Market

MySQL can be used 64,000 different ways with just about any type of database. Despite this flexibility, here is how I see the growth of MySQL in the database market:
  • Web-based applications are an area of strength for MySQL. MySQL will continue to grow and remain popular in this space.
  • Data Warehousing is the big potential growth area for MySQL. In the next few years it will be very interesting to monitor MySQL in the data warehousing market. Fast reads, large horizontal scalability and strong yet relative low-cost solutions make MySQL ideal for data warehousing.
  • OLTP is an area that MySQL works well in for small and medium sized solutions. MySQL version 6 is where MySQL can grow significantly in the OLTP market. The Falcon (OLTP) storage engine, designed for modern large memory and multi CPU systems, increased on-line functionality and improved high availability offers significant potential for MySQL in the area of OLTP applications. MySQL version 6 will make MySQL more popular in the on-line Internet database market. You can also expect Oracle (InnoDB) and other 3rd party companies to also offer new scalable OLTP storage engines in the next few years.
The future looks bright for MySQL. It's interesting to look at the database market. It is Oracle and MySQL that are growing in popularity that can be used in multiple platforms.
  • DB2 is typically an IBM solution.
  • SQL Server is typically a Microsoft or low-cost simple solution.
  • Oracle and MySQL are the two database solutions that are popular with multi-platform solutions. HP-UX, AIX, Solaris, Red Hat, SuSE , Windows, etc. are all strong and popular solutions for both Oracle and MySQL. It is only Oracle and MySQL that continue to remain popular on multiple platforms.
Oracle will continue to dominate the large aircraft carrier database solutions and the business applications market. SAP will continue to try and use DB2 and SQL Server with their business applications and use Oracle only when they have to.

As for the web-based applications, small/medium data warehousing applications and small/medium OLTP environments, MySQL will continue to grow in popularity.

Wednesday, March 5, 2008

MySQL - An IT Tipping Point

A ''tipping point'' is a concept, product or idea that becomes a hot commodity that attracts everyone's attention, interest or inspiration. There are always specific reasons and factors that are not easily identifiable why one product becomes a tipping point and others do not. Products not considered a tipping point usually never become a tipping point and ofter never understand why they didn't. There are tons of examples of this. VHS versus Beta, MP3 players versus iPods, Blue Ray versus HD DVD. The list is endless.

MySQL is "the" hot tipping point product in the IT industry. MySQL is an incredibly popular open source part of the LAMP stack. There are additional open source products like PostgreSQL, MaxDB, Firebird, Ingres, Apache Derby, etc. No database in the industry is creating the buzz, excitement and interest that MySQL does. People can debate the feature/functionality, performance, etc. between the different databases. Make any comparison you want, none of the other databases that are compared to MySQL are going to be the "tipping point" MySQL is.

MySQL is a very unique organization with employees that believe in disrupting the industry with innovativeness and new ways of doing things. MySQL employees have been raised with the concept of open source, sharing and caring about their contributions to open source. I do not believe their are many companies in the world that have the "global team" concept that MySQL does. I interact with MySQL team members in Sweden and Germany as easily as team members in my home city. It is the uniqueness of the MySQL employees that are creating the tipping point.

Web 2.0 environments are increasing exponentially in popularity and MySQL is in the center of the storm of this exciting growth. MySQL has the potential to be the center of innovativeness in Sun the way NeXT was the center of innovation in Apple. Sun has a very powerful engine for future growth in MySQL. There is one thing MySQL has that no other database has. It has the tipping point.


Sunday, March 2, 2008

MySQL Priority Poll

This poll did not get a lot of voters but I thought I would post the results to show you the priority of the individuals that did vote.

Poll: What is your highest priority with MySQL?
  • Performance Tuning 20%
  • Backup and Recovery 20%
  • Monitoring and Management 16 %
  • High Availability 16%
  • Scalability 12%
  • Storage 10%
  • BI and Reporting 3%
  • Business Strategy 3%

Saturday, February 16, 2008

Database Market Share


Mark Twain once said, "Figures often beguile me, particularly when I have the arranging of them myself; in which case the remark attributed to Disraeli would often apply with justice and force: "There are three kinds of lies: lies, damned lies and statistics."



Whenever I look at statistics and numbers I not only take them with a grain of salt but I also try to understand how they arrived at the numbers. When you look at the analyst's reports on the top database vendors it is often based on total revenue or licensable revenue. So how does open source numbers come into play. The same industry analyst's that show MySQL as having very small market share based on revenue also state estimates of between 8 - 10 million MySQL instances are currently running. Analysts also estimate MySQL binaries are downloaded 40 - 50 thousand times a day.

MySQL is encountering incredible growth but the growth is often hidden in the way numbers are collected. There is a lot of momentum and energy around open source, it will be interesting to see how the industry analysts use numbers to track this growth.

Friday, January 18, 2008

Database, Application and Middleware Wars

The changing dynamics of the IT industry is going to increase in the next year versus slowing down.
  • Oracle's acquisitions in the last few years in the middleware space has the potential to significantly increase it's power to challenge IBM in the middleware space.
  • Oracle's acquisitions in the application space the last few years allows Oracle to go toe to toe with SAP in the business applications space.
  • Sun's backing and support brings a lot of power to MySQL and the web platform of LAMP.
  • The open source world and Internet are changing how people think daily.
  • The innovativeness of the world wide web is creating new companies at an unbelievable rate. The creativity of this space is going to change the world in ways we can't even imagine.
I almost see this as Oracle having two big aircraft carrier task groups one facing IBM and the other facing SAP. MySQL is like a very fast attack boat that now has a powerful nuclear submarine flying the Sun flag to protect it. Microsoft is another big aircraft carrier task group that everybody is wondering where it is going. The database, application and middleware battles that will occur over the next year is sure to change the face of the IT industry more than we can possibly imagine. This does not even include all the Internet companies like Google, MySpace, YouTube and others that are changing the world everytime we blink. Or maybe more importantly all the new little startups on the Internet that are being born every day.

I look at this like back in the day when DEC was the second largest computer company in the world and everyone was wondering if they could catch IBM. If back then you had said that in the future a PC company is going to purchase DEC, people would have thought you were crazy. I have the great luxury of traveling in the Oracle and open source worlds. In the Oracle world, I see the incredible power Oracle technology brings to large companies that have complex problems to solve. In the open source world my mind is literally boggled every week with all the incredible, incredible creativity and innovativeness that I see in Internet companies. If you look around everyone can see that rate of change in the world is accelerating. The Internet is spawning new change agents in the world at an exponential rate.

Wednesday, January 2, 2008

2007 - MySQL a Year in Review

2007 has been an interesting year with MySQL. MySQL really seems to have broken out this year. Organizations are absolutely choking on their database and software licensing costs. More and more organizations, large and small are now recognizing MySQL databases as a viable solution for database projects.

If MySQL can be a solution for a database project, it can provide a lot of flexibility for organizations. Leading managers are looking at more ways to be competitive in today's global markets. A number of the largest Internet websites are using MySQL to provide extremely fast reliable Internet solutions. These success stories have more IT managers asking what MySQL can do for them. A great success story can be found at:
http://itc.conversationsnetwork.org/shows/detail3299.html

In 2007, more than any year open source solutions have taken an exponential leap in use and acceptance in the market place. In the last year I've gone into some of the largest companies in the U.S. and seen an explosion of MySQL databases. In 2008, I expect to see the growth of open source solutions increase in use and acceptance. My top three reasons I see a significant increase in MySQL databases for 2008:
  1. IT managers beginning to think out of the box and realizing how open source can offer greater flexibility in choosing software solutions.
  2. Industry acceptance of open source solutions in the enterprise.
  3. Popularity of MySQL version 5 features.
The large vendors can no longer ignore the growing popularity of open source and MySQL. 2007 has seen large vendor companies purchasing open source products. It's funny, I've seen a few blogs predict gloom and doom for MySQL because Oracle purchased InnoDB and IBM purchased SolidDB. I see the exact opposite. The purchases of popular storage engines used by MySQL shows the growing popularity and use of MySQL can not be ignored by large vendor companies. Their purchases bring more light and industry awareness of popular storage engines used by MySQL.

I predict InnoDB and SolidDB storage engines will be used more than ever in MySQL databases. As MySQL 6.0 moves towards GA, you will see the Falcon storage engine increase in interest and popularity with it being the next generation in transactional storage engines for MySQL.

The growth of open source is going to be very interesting to watch in 2008. As Oracle, Microsoft and IBM, BEA, etc. add more and more features to their products and increase their prices, open source products grow in popularity and marketshare at almost the same pace. The growth of MySpace, YouTube, MySQL, etc. is continuing to demonstrate the incredible dynamics of the Internet and how the use of open source is continuing to change our IT industry. I don't work with all open source products but the following are products I work with and see them becoming more popular than ever before. Popular open source solutions that I predict will continue to grow in 2008 include:
  • MySQL
  • Apache
  • Apache Tomcat
  • JBoss
  • Eclipse
  • Spring

Wednesday, October 31, 2007

The Growing Popularity of MySQL: The friendly kid in the playground.

I was sitting at dinner the other night with some MySQL DBAs that have worked with Oracle and SQL Server and we were talking about the differences between the different databases and the different paths to success. These impressions were just points of discussion over dinner.

Oracle - For Oracle we talked about how Oracle grew with an incredible sales team and as Oracle grew, the feature/functionality grew with it. Now it is the aircraft carrier of database servers. If I'm a Fortune 1000 company and I need to run financials, Oracle's Jedi skills are strong in this area. I've worked with Oracle technology for 20 years and I am a fan of Oracle for the right environments where cost is not an issue. If you are in large complex environments, Oracle has strong complex tools for solving complex problems.

SQL Server - Great marketing. Whoever came up with the name of "SQL Server", this name is brilliant, this person should be drinking pina coladas in Aruba. Great point and click database functionality with good price points compared to Oracle and DB2. In a world of point and click people, SQL Server is popular and easy to work with relatively speaking.

MySQL - An incredible wave of customers looking at the great price point of running MySQL servers for projects. The cost savings for projects can be incredible. MySQL is like the friendly kid on the block that has cool toys. MySQL makes sense to be able to run in environments that are also running Oracle, SQL Server and DB2 for a great price point on separate projects. So MySQL plays nice with everyone. It also has great features like replication and clustering. MySQL also has great portability with Linux, Windows, Solaris, HP-UX, AIX, etc. MySQL also has very simple upgrades compared to other database servers. The power and popularity of open source is growing dramatically. The Jedi powers of open source are very strong. As Linux has become incredibly popular as a low cost powerful solution, MySQL has become very popular as well. A lot of companies are realizing on a lot of projects they just need core relational database ACID features and in this environment companies are seeing MySQL as an excellent solution.

DB2 - Someone described DB2 by comparing it to the T-34 Russian tank used in WWII. Not pretty, fancy or a lot of features compared to products like Oracle but it does an excellent job as a powerful database server.

Anyway, just a few shared conversation thoughts on different database servers all tongue in cheek. :)

Tuesday, October 16, 2007

Informal Poll: What are the most important areas for you to learn related to MySQL?

I did a short informal poll to see what are the most important areas for you to learn related to MySQL. These numbers were very consistent with the last class I taught in terms of new students priorities.
17 (68%) Performance Tuning
13 (52%) Management Best Practices
13 (52%) Backup and Recovery
9 (36%) High Availability
5 (20%) PHP
4 (16%) Stored Procedures
4 (16%) Linux
0 (0%) Apache or JBoss