Open Source to the Next Level with Incredible MySQL Database Support

A friend sent me a note telling me about the latest release of MySQL Clustering support that has been benchmarked at over 1 Billion queries per hour or 7.6 million rows retrieved per second!  That is incredible performance.  What is even more amazing is the fact that this is FREE open source software that you can download and install.

To my knowledge this is the first and only high performance relational database management system (RDBMS) available as open source.  This new clustered release outperforms commercial databases costing as much as $20,000 per processor and not beginning to reach this level of performance.

What is significant here is that Oracle actually owns and controls MySQL but releases it through the standard open source GPL license.  They also offer a commercial version of the product with full 24 x 7 support, but if you have access to the technical skills you can use the open source version.

Once again, open source is rivaling and exceeding features and benefits of commercial software.

Check this out at: MySQL Cluster 7.2 Delivers 1 Billion queries per minute 

Cloud and Mobile Devices are the Future

I just read an article that Microsoft's new CEO, Satya Nadella is leading Microsoft aggressively into cloud technology and services refocusing Microsoft away from the PC.

I happen to believe he is on the absolute right track.  At present the vast majority of corporate employees use a laptop or some still use desktop PC's as their workstation of choice.  I think that Mr. Nadella is 100% on the right track.  Many companies are moving all of their Microsoft Office applications to Office 365 and storing all of their Word, Excel, PowerPoint and other documents in the cloud...

Apple is equally competitive with their iCloud offering storing output from their Pages, Keynote, and Numbers products in the cloud.

Most corporate systems utilize a web interface today which is immediately accessible via a mobile devise and true mobile applications are rapidly spreading throughout the corporate world.

The device of the future will be a tablet with a reasonable size screen and the ability to connect to a large monitor or monitors on a desktop but also portable to move to a meeting or travel anywhere with the user of the device.  I think these devices will be equipped with optional keyboards to insure ease of use.   A corporate employee should be able to use their smart phone or even perhaps Google Glasses or Apple watch...  for total portability.

Look at the advantages that cloud based technology along with mobile devices bring to the corporate world:

• No lost data!  No data exists on a local device and all data from reminders to corporate documents, spreadsheets, powerpoint presentations, etc. live on a shared server.  When an employee leaves the company their documents are preserved and can be index and shared to those who need them.  The cloud protects against local disk failures or other local disasters including stolen laptops...  
• Increased security!  Only people authorized to access your data can get to it.  If the device is stolen there is nothing of value on the device to the their other than device itself.  
• Insuring that your employees use current versions of your applications.  You can implement change management like that used by Apple or Google to automatically update the apps stored on the devices when changes are published!  No more worrying about what version a user is using.  

Portability, improved security, elimination of risk and insurance that everyone is on current software are huge benefits to corporations today.  The high speed office networks and wifi connectivity all ready exists in most corporations today to support PC's.  

BTW, did I mention the reduction in human support costs by getting rid of PC's?  What are you waiting for?  Cloud based systems with mobile devices can save you time money and headaches!

Vendor Loyalty?

Do you recall the old saying "No one got fired for recommending IBM"?  More importantly are you old enough to remember when it was a true statement.  Today I wonder how long IBM will be in the computer hardware business...

I grew up with IBM.  I did recommend IBM because back in the day you could trust them to provide solutions (expensive solutions) that met the needs of your business enterprise.  I remember when IBM told us to move to COBOL.  I remember when the told us to use CICS for this new "On-Line" processing...  I joined the throng when in 1997 IBM embraced Java and introduced WebSphere.  I used to laugh that I was one of the first kids on my planet to embrace Java via WebSphere.  I spent over $3000 per developer for IBM's RAD based development toolset.

I adopted other IBM technologies and bought into SOA when it was being promoted as the latest architecture of the future.  Over the years I have been responsible for recommending and encouraging the companies that I have worked for to spend millions on IBM technologies, including IBM hardware which we dependent on for high performance and reliability.  I recalled when everyone laughed at Microsoft based systems and joked about the three fingered salute (Control, Alt, Delete) as the three most used keystrokes...  

Today, the world has changed.  First of all the hardware has matured.  You can buy a $200 no-name clone computer most likely built in China where you can swap out disk drives while the machine is running without it missing a beat.  You can build incredibly powerful and reliable clusters of computers that not only replicate data, but applications throughout a data center and across data centers, often at many locations world wide.

The fantastic thing about today's world is you need only buy the hardware, cabling, networking technology, and facility to put the equipment.

The software is free and open source!  I'm working with a company that is using Redhat Linux, Jboss, along with several other open source technologies to implement robust distributed systems in their own private "cloud" environment.  Note that data is replicated to another site and the system is available 24 x 7 with no outages.

Interestingly enough, IBM is releasing new high performance technology, but losing market share and revenue with a drop of nearly 50% of its server market share between 2013 and 2014 according to Gartner.  That is significant as Gartner most definitely favors IBM in all of its reports, but can no longer cover IBM's decline as a major provider of server technology.

While IBM still sells its WebSphere line of application servers it has dropped to less than 1% marketshare in the Application Server market place.

SOA has been replaced with REST and the world is moving towards cloud based technology.

The world is changing!  Change with it, but so so in a sensible manner.

System Modernization

Where people are today:

Do you use IBM Mainframes, IBM i (OS/400) based systems?  Do you have a large inventory of custom written COBOL or RPG programs? Do you use CICS 3270 or IBM 5250 green screen applications?

Do you have an inventory of old mainframe based 3rd party systems running on your mainframe or IBM i system?

Today, the cost of the hardware alone is a major factor driving many companies to seek alternatives.  The average mainframe runs between $4 and $15 million to purchase.  Add to that monthly software rental for zOS based IBM software often scaling between $30k and $100k per month and you have one huge base cost to justify in hardware and basic system software that does nothing for you other than to provide a base platform where you can install your own home grown systems or those purchased from various 3rd party vendors.

The IBM i environment is a bit less expensive with hardware plus OS base costs ranging between $20k for a small machine that does very little and usually requires many machines to support your company to about $2 Million for a large high end machines.  Again add the cost of 3rd party application software or the cost of maintaining in-house developed systems.

Add to all of this the cost of disaster recovery.  That can vary depending upon what approach you take.  Some companies operate their own backup or redundant data center and use various software products to replicate programs and data to the back up site.  Others use service bureaus with a strategy of loading backup media should a disaster occur.

Look at your people cost!  Even in small mainframe shops you will need several people dedicated to supporting the IBM software that runs the machine.  You need additional operators, capacity planners, performance managers, and other specialists that provide no value other than to keep the machine and its software running.

IBM i is a bit better in that respect as you can get buy with between 2 and 6 specialists for most small shops.  The number grows with the size of your IT organization.

Next, lets look at your existing staff.  If your primary legacy languages are RPG or COBOL, look at the people that support your applications.  Many of these folks are in their sixties and many at or beyond retirement age.  You can lose many of these people each year for the next several years.  Note that you probably have few if any developers under 50 years of age with the skills to support these applications.  This is becoming an increasingly high risk.  Additionally it is becoming exceedingly more difficult to replace these people when they leave.

Are COBOL and RPG applications dead?  Well, the fact is that thousands of companies continue to run millions of COBOL and RPG programs.  These programs were developed over the past 50 years and have been modified countless times over the years.  While many of your mainframe systems were extremely well designed when they were first created, the sheer number of changes by a large number of programmers over the years with varying skills have placed the maintainability of these programs at significant risk.

Modifying one of these programs today can result in production system failures, even with extensive testing prior to deployment.  Often times you make a modification only to find that the modification was required not only to one but many programs and that you missed some of these programs.

Many companies find that they spend well in excess of 80% of their IT budget on maintaining old systems.

The need to move away from old COBOL or RPG based systems as well as expensive proprietary IBM hardware and system software is increasingly clear.  Risks and Costs are increasing, it is becoming difficult to find experienced staff to support your systems and mandatory modifications can cause system failures.

There are cost effective alternatives.

Cloud Computing

The direction that many organizations are taking is to prepare for and move to cloud computing.  While there are variations in the implementation of cloud computing including some people who claim you can build your own cloud (not a good idea), the best definition is the use of computers hosted by a reputable 3rd party company with a strong financial footing that will survive changes in our economy.

This company must have resources spread across multiple locations with the ability to replicate your data and programs across multiple locations eliminating the need for specialized disaster recovery.  The vendor should provide automatic real-time failover meaning that if a location were to be destroyed (earthquake, flood, or other natural disaster) that your systems would continue function at a minimum of one and preferably several alternate locations.

In a cloud environment you pay a monthly fee for computer resources consumed.  You generally pay based on CPU usage, DASD storage usage, and BANDWIDTH (telephone traffic between your users and the computer sites).  Normally these companies calculate and offer you a fixed monthly price that covers up to a maximum CPU, DASD, and Bandwidth utilization.  The contract has provisions on how to charge for usage over the agreed upon maximums and allows you to immediately via vendor provided software to readjust your agreement increasing or decreasing your agreed upon usage in real time.

You then upload software to the cloud and run it using REST based API's.

In my next post we will discuss approaches on modernizing old legacy systems and the risks associated with various approaches.


References:
 IBM cloud efforts intensify as System z, Power hardware revenues tank
Gartner IT Spending Analysis

System Documentation?

I've been speaking to a number of very large IT organizations many which have large IBM mainframes, and a host of other systems dating back to the 1950's.  The common thread is that very few companies have any documentation of systems that have spanned over 50 years of use.

The knowledge of these systems is contained in the heads of developers that are nearing retirement age.  As companies lose key people, they lose tremendous knowledge of existing systems.

In a world where we have tools to automate documentation of systems few companies have invested in these tools.  I am astounded that companies put themselves at risk over a tiny sum of money when compared to the total IT budget.

IBM Watson and Cognitive Computing

Almost everyone knows that IBM put their Watson computer system up against humans to win Jeopardy and made headlines.  What many do not know is that IBM in January created a new business unit at the highest levels of the company headed by a Senior Vice President (Mike Rhodin) with a huge investment dedicated the commercial implementation of Watson and Cognitive Computing.

First let me give you the link to a YouTube video of the announcement.   Let me caution you that this is a 2 hour video so allow yourself plenty of time to watch this.

The whole point of Watson is for you to interact with a computer system, process huge amounts of data, find relevant facts, issues, and opportunities that you could not have found with a mere human brain.

Examples include the medical profession where huge sums of research are analyzed in addition to patient information to come up with suggested courses of treatment along with the probabilities of success.

Retail systems that ask you what you want and find exactly what you need based on your requirements.

Travel systems that customize trips to your needs and desires.

The list goes on.

IBM has dedicated ⅓ of IBM Research to Watson and is currently working to have it learn to hear and understand what it is hearing, to see by interpreting content in still and video images, and much much more.

Click the link and watch the video.  This is an example of a major company like IBM shifting directions.  Please note that Watson is based on IBM super computers, Big Data, and Cloud computing.  IBM has promised a sandbox where everyone can interact and experience Watson.  I'll post more once I try it out.

Big Changes in Computing

I've been following IBM's Q4 results along with its 2013 year end results and statements being made by Virginia Rometty, President and CEO about IBM's future.  It is clear that Cloud and Big Data are IBM's strategic direction.

In Rometty's letter to shareholders she was pretty clear about big changes in IBM's Power Systems division in light of its dismal 2013 performance.  She indicates a clear focus on Linux and participation in Cloud and Big Data.

See: Letter to Shareholders, 2013 Annual Report

It seems that Ms Rometty may have spoken to soon and too harshly in her letter above as a news release came out on Saturday, March 8, 2014 The Street published a letter from Rometty stating "We are not getting out of the hardware business"

We are we? Or are we not Mr Rometty?

This whole debacle is the result of IBM hardware sales being down by over 18% year to year and actually generating a substantial operating loss.  There is followed reports of over a 25% world wide reduction in staff for IBM STG (Systems & Technology Group -- responsible for computer hardware)  in all areas from sales to manufacturing and support.

So what does all this mean?

It means that Cloud computing is where IBM see's the future.  Instead of owning computers as in the past with all the technology challenges, security challenges, and risk, organizations like IBM, Google Amazon, and others will become utilities selling computer resources as a service and providing a vastly superior service than owning your own systems.

Just something to think about.