Computers are growing so rapidly marked by the many things in this world that are connected to computers. Many new devices have sprung up to support computer performance for the better. There are also so many database management tools today.
Database is a number of data that is processed using special software and packaged neatly on the computer. And one of the tools that can be used to process, store and obtain information on a database is MySQL.
For those of you who are familiar with computers, you must know very well about this tool. But for ordinary people, this tool may be so foreign. For this reason, this time I will discuss the meaning of MySQL, its history and functions plus its advantages and disadvantages.
MySQL is a tool that is used specifically to process SQL (Structured Query Language). SQL is a language used to access relational data rows. The easy way is to access the language in the computer. Because SQL and MySQL are special in nature, only people who are in the IT world are familiar with this language.
If SQL is the language used to access data in the database, then MySQL is a tool or software or tools used to process SQL. SQL is the language, MySQL is the tool. What needs to be understood, MySQl is not the only tool that can process SQL. There are many other tools. Call it Microsoft Access. Both only differ in the way of using and processing the database.
There are several definitions of MySQL that can enrich your knowledge:
- MySQL is classified as open source software with a General Public License (GPL) license. The GPL is a special license for software for GNU purposes. So it is not wrong if MySQL is widely used in this world. In addition, MySQL is also easy to use.
- MySQL is a software with a SQL database management system (DBMS) that has the ability to be multithreaded, and multi-user. Even MySQL is able to manage systems with up to 40 databases, which can contain more than 10,000 tables and 500 of them have 7 million rows.
- Wikipedia defines MySQL as SQL database management system software.
Until now, the owner of the MySQL license is a Swedish commercial company called MySQL Ab. The company was founded by David Axmark, Allan Larsson and Michael “Monty”.
The history of MySQL begins in 1979 when a computer programmer named Michael “Monty” Widenius developed a simple database system which he named UNIREG. At the time this research was conducted Monty was a worker at a company called TcX in Sweden. And it turns out, Monty’s development is getting good results.
In 1994, UNIREG was Used as a Web-Based Application Database
After a long period of development, in 1994 TcX started to develop a web-based application using UNIREG as its database system. Unfortunately, at that time the results were not satisfactory, UNIREG was not suitable to support dynamic databases such as the web.
TcX then tried another alternative by using the mSQL database system (miniSQL). Unfortunately, mSQL doesn’t even support indexing. As a result, mSQL has not very good performance.
Because of these two failures, Monty contacted David Hughes (mSQL programmer) to discuss whether he was interested in developing mSQL in conjunction with UNIREG ISAM to support indexing. Unfortunately, at the time Hughes refused. He wants to develop indexing technology for mSQL version 2.
1995, MySQL Released
From this rejection, TcX, in which there was Monty, developed the concept of a new database system. He developed the UNIREG and mSQL combined database system. So in 1995, a new RDBMS was born which was later named MySQL. Also in 1995, the name TcX no longer existed because it had changed to MySQL AB. AB is the abbreviation for Aktiebolag or the term PT (Limited company) in Sweden.
At the suggestion of David Axmark from Detron HB who is a partner of TcX, he suggested that MySQL be released for free to the public. To support the company’s income, a strategy of selling “support” services is carried out for companies that want to implement MySQL.
For those who are used to using SQL, they know very well what MYSQL functions. In general, MYSQL has functions to create, manage and access databases in a structured and automated manner. MySQL’s most prominent ability lies in its ability to manage string data (text based) which can be accessed privately or publicly on a web.
Certainly, almost all web server providers or hosts provide MySQL facilities for web developers to manage databases on their websites. In the web world, the interface or My SQL interface is called phpMyAdmin. Some examples of the use of MySQL can even be found in E-Commerce, Blogs or CMS.
Capabilities of MySQL
As I said earlier, that MySQL is not the only tool for processing SQL. But MySQL is chosen by many users because it has certain features or capabilities.
One of the most notable is MySQl’s multi-platform, GPL-licensed capabilities. That means MySQL can be used by almost all computer OS. Moreover, MySQL’s performance is also quite high in processing queries.
Some other features in MySQL for example:
- Date and others
What’s more, MySQL also supports the use of fields in the form of indexes and has a fairly good level of security.
MySQL Advantages and Disadvantages
MySQL has several advantages that make it widely used by users. Among them:
- MySQL supports various OS such as Windows, Mac Os X Server, Solaris, Linux, FreeBSD, Amiga, and others.
- Open Source, so MySQL can be used for free.
- MySQL can be used by many users at the same time.
- MySQL has more SQL speed per unit time.
- MySQL has a variety of application interfaces with API (Application Programming Interface) functions.
Even so, that does not mean that MySQL is without flaws. Some of the shortcomings of MySQL, for example: MYSQL does not support programming language connections and the data that can be handled is not so large and does not support the widowing function.