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. Incredible points. Great arguments. Keep up the great effort.

    ReplyDelete
  16. I have been following your post for a long time. I always found it very interesting and valuable. keep posting it is really helpful.
    Cloud Migration services

    Aws Cloud Migration services

    Azure Cloud Migration services

    ReplyDelete

Post a comment

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

Popular posts from this blog

mongoDB error : aborting after fassert() failure

What to do when facing errors on mongoDB “aborting after fassert() failure”

I like errors, in mongoDB this is the first error I faced and luckily many times. This error i faced during restoring name-space on local and restarting db system. I am still searching the exact root cause of this issue but i am able to resolve the current problem through below steps.

Remove all relevant namespace files from data-file route path..Now repair mongo instance using mongod process.mongod --repair ////////// execute command from bin folder path Then start server using mongd process, if started server successfully then ..mongod  ////////// execute command from bin folder path Restore last backups as normal process.Now check database by connecting mongo shell. Thanks for reading, 
Please comment your experience if you faced and also share knowledge if you have better steps to resolve...


https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

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 on local database what…

How to add an article in Transactional Replication

If we have a set-up of Transactional Replication for Data Distribution running and wanting to add new object to replication on other server we can follow below process.
To add an article In Transaction replication with PUSH Subscription