Skip to main content

History of MySQL from AB Corp to Cloud Database


MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael "Monty" Widenius. Original development of MySQL by Widenius and Axmark began in 1994. The first version of MySQL appeared on 23 May 1995. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter,and "SQL", the abbreviation for Structured Query Language.


·         23 May 1995 - First internal release
·         Year 1996 - Version 3
o    Simple CRUD operations
o    January 1997 Windows version was released on 8 January 1998 for Windows 95 and NT
o    production release 1998, from www.mysql.com

·         Year 2002 - Version 4
o    MyISAM
o    unions
o    Tracking
o    B-trees
o    subqueries
o    prepared statements

·         Year 2005 - Version 5.0
o    cursors, stored procedures, triggers, views,
o    Federated Storage Engine
o    Event scheduler, partitioning, plugin API, row-based replication, server log tables
o    Oracle acquired Sun Microsystems on 27 January 2010.
o    The default storage engine is InnoDB, which supports transactions and referential integrity constraints.
o    Amazon RDS Cloud was first released on October 2009, supporting MySQL databases.

·         Year 2013 - Version 5.6
o    Query optimizer, higher transactional throughput in InnoDB,
o    improvements to partitioning for querying and managing very large tables, 
o    TIMESTAMP column type that correctly stores milliseconds, improvements to replication, and better performance monitoring by expanding the data available through the PERFORMANCE_SCHEMA
o    The InnoDB storage engine also included support for full-text search and improved group commit performance.

·         Year 2015- Version 5.7
o    MySQL supports a native JSON data type.
o    Tablespace.

·         Year 2018 -MySQL Server 8.0
o    Including NoSQL Document Store
o    Atomic and crash safe DDL sentences.
o    Window Function and CTE.
o    March 2018 Azure MYSQL DB.



Thanks for reading
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

Comments

  1. Hey there would you mind letting me know which hosting company you're using?
    I've loaded your blog in 3 completely different
    web browsers and I must say this blog loads a lot quicker then most.
    Can you recommend a good hosting provider at a honest price?
    Kudos, I appreciate it!

    ReplyDelete
  2. What's up to every one, it's actually a good for me to visit this site,
    it includes priceless Information.

    ReplyDelete
  3. Thank you for the auspicious writeup. It
    in fact was a amusement account it. Look advanced to
    more added agreeable from you! However, how
    could we communicate?

    ReplyDelete
  4. Hi, I think your website might be having browser compatibility issues.
    When I look at your blog site in Ie, it looks fine but when opening in Internet Explorer, it
    has some overlapping. I just wanted to give you a quick heads up!

    Other then that, terrific blog!

    ReplyDelete
  5. This is my first time go to see at here and i am really pleassant to read everthing at alone
    place.

    ReplyDelete
  6. It's a shame you don't have a donate button! I'd without
    a doubt donate to this outstanding blog! I guess for now i'll settle for book-marking and adding your RSS feed to my Google account.
    I look forward to brand new updates and will share this website
    with my Facebook group. Chat soon!

    ReplyDelete
  7. Hello everyone, it's my first pay a quick visit at
    this web page, and post is truly fruitful designed for me,
    keep up posting these articles or reviews.

    ReplyDelete
  8. I'm really loving the theme/design of your weblog. Do you ever run into any web browser compatibility issues?
    A handful of my blog visitors have complained about my blog not operating correctly in Explorer but looks great in Firefox.
    Do you have any ideas to help fix this problem?

    ReplyDelete
  9. Undeniably believe that which you said. Your favorite reason seemed to be on the web the simplest thing to be aware
    of. I say to you, I certainly get irked while people think about
    worries that they just do not know about. You managed to hit the nail upon the top
    as well as defined out the whole thing without having side-effects , people could take a signal.
    Will likely be back to get more. Thanks

    ReplyDelete
  10. My brother suggested I might like this blog.
    He was totally right. This post truly made my day.

    You cann't imagine simply how much time I had spent for this information!
    Thanks!

    ReplyDelete
  11. What a material of un-ambiguity and preserveness of precious experience on the topic of
    unpredicted feelings.

    ReplyDelete
  12. If some one wishes to be updated with hottest technologies therefore he must be pay a quick visit
    this web site and be up to date daily.

    ReplyDelete
  13. Appreciate the recommendation. Will try it out.

    ReplyDelete
  14. This is really interesting, You're a very skilled blogger.
    I've joined your rss feed and look forward to seeking more of your magnificent post.

    Also, I have shared your web site in my social networks!

    ReplyDelete
  15. potencja leki bez recepty

    ReplyDelete
  16. What's up, the whole thing is going sound here
    and ofcourse every one is sharing facts, that's in fact fine, keep up
    writing.

    ReplyDelete
  17. Hi there! Someone in my Facebook group shared this website with us so I came to
    take a look. I'm definitely loving the information. I'm book-marking and will be tweeting this to my followers!
    Outstanding blog and fantastic design and style.

    ReplyDelete
  18. Thank you for the auspicious writeup. It in fact was a amusement account it.
    Look advanced to more added agreeable from you!
    However, how can we communicate?

    ReplyDelete
  19. I every time used to read post in news papers but
    now as I am a user of web therefore from now I am
    using net for content, thanks to web.

    ReplyDelete
  20. Heya! I'm at work surfing around your blog from my new iphone 4!
    Just wanted to say I love reading through your blog and look forward to all your
    posts! Carry on the outstanding work!

    ReplyDelete
  21. Fastidious answers in return of this issue with genuine arguments and explaining all regarding that.

    ReplyDelete
  22. My developer is trying to persuade me to move to .net from PHP.
    I have always disliked the idea because of the expenses.
    But he's tryiong none the less. I've been using
    WordPress on a number of websites for about a year and am anxious
    about switching to another platform. I have heard good things about blogengine.net.
    Is there a way I can import all my wordpress posts into it?

    Any kind of help would be greatly appreciated!

    ReplyDelete
  23. Howdy! I know this is kind of off-topic however I had to ask.
    Does building a well-established blog such as yours take a lot of work?
    I'm brand new to writing a blog but I do write in my journal daily.
    I'd like to start a blog so I will be able to share my own experience and
    views online. Please let me know if you have any kind of suggestions or tips
    for brand new aspiring blog owners. Appreciate it!

    ReplyDelete
  24. Incredible points. Great arguments. Keep up the great effort.

    ReplyDelete
  25. WOW just what I was looking for. Came here by searching for how to get help in windows 10

    ReplyDelete
  26. Attractive element of content. I just stumbled upon your web site and in accession capital
    to say that I get actually enjoyed account your blog posts.

    Any way I'll be subscribing on your augment and even I
    achievement you access persistently rapidly.

    ReplyDelete
  27. This blog was... how do I say it? Relevant!! Finally I have
    found something that helped me. Kudos!

    ReplyDelete
  28. I simply couldn't depart your site prior to suggesting that I really enjoyed the
    usual information an individual provide on your visitors?
    Is going to be again regularly to inspect new posts

    ReplyDelete
  29. I know this web site offers quality dependent content and
    extra information, is there any other site which offers these kinds of stuff
    in quality?

    ReplyDelete
  30. Fantastic items from you, man. I've take note your stuff prior to
    and you're just extremely great. I actually like what you've bought here, really like
    what you are stating and the best way in which you are saying it.
    You make it entertaining and you continue to take care of to keep it smart.
    I can not wait to learn far more from you. That is really a tremendous
    website.

    ReplyDelete
  31. It may incorporate the accompanying sections for client data: name, address, and telephone number. Change Site URL Using MySQL

    ReplyDelete
  32. Great Article Cloud Computing Projects

    Networking Projects

    Final Year Projects for CSE

    JavaScript Training in Chennai

    JavaScript Training in Chennai

    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete

Post a Comment

Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

Popular posts from this blog

How to encrypt and decrypt Table data in postgres

For encrypting and decrypting , we must use the bytea data type on the column which we implement. Bcoz bytea will use the pgcrypto method by default. However, you will need to create the pgcrypto extension to enable these functions as they are not pre-defined in PostgreSQL/PPAS. Example CREATE EXTENSION pgcrypto; CREATE TABLE userinfo (username varchar(20), password bytea); >>    Inserting the data in an encrypted format INSERT INTO userinfo VALUES(' suman ',encrypt('111222','password','aes')); select * from userinfo ; >>    Retrieving the data as decrypted format SELECT decrypt(password,decode('password','escape'::text),'aes'::text) FROM userinfo; Thanks for reading Plz dont forget to like Facebook Page.. https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

How to recover msdb database from suspect mode

 It was Monday 9 th Jun 47 degr. temperature of Delhi-NCR. Temperature was like boiling me and database. When I reached my office( @ 8.45 am) got an alert from one of Server. “MSDB is in suspected mode” At the same time comes in my mind, this issue will boil me today.. I just tried to cool my self through cold drink then connected server from my local system using windows authentication mode..

SQL71562: external references are not supported when creating a package from this platform

Last week I got this error from one of developer who was trying to deploy his project from Testing server to SQL Azure QA server. He was using “Deploy Database to SQL Azure” option from SSMS Tool-Task option. After connecting to SQL Azure portal when operation started to deployment below errors occurs. Validation of the schema model for data package failed. Error SQL71562: Error validating element xx.xxx.xx:function .dbo.xxx has an unresolved refrence to object xx.dbo.xxxx external refrences are not supported when creating a package from this platform . Reason: The reason of the this error was; some functions of project was dependent on master database and only single database was being deploy to SQL Azure. DACFx must block Export when object definitions (views, procedures, etc.) contain external references, as Azure SQL Database does not allow cross-database external references So, this error was coming. Solution : I suggested him to create those function to locally