 |
| Mysql Logo |
MySQL is a software SQL database management system (English: database management system) or DBMS is multithreaded, multi-user, with about 6 million installations worldwide. MySQL AB makes MySQL available as free software under the GNU General Public License (GPL), but they also sell under a commercial license for those cases where its use is not compatible with the GPL.
Not the same with projects such as Apache, where the software was developed by the general community, and the copyright for the source code are owned by their respective authors, MySQL is owned and sponsored by a Swedish commercial company MySQL AB, which holds the copyright on all code almost source. The two Swedes and one Finnish man who founded MySQL AB is: David Axmark, Allan Larsson, and Michael "Monty" Widenius.
MySQL is an implementation of relational database management system (RDBMS) that is distributed free under GPL (General Public License). Each user can freely use MySQL, but with the restriction that software should not be used as a commercial derivative product. MySQL is actually a derivative of one of the main concepts in the database who have been there before; SQL (Structured Query Language). SQL is a database operation concept, especially for the election or selection and data entry, which allows the operation feasible data automatically.
Reliability of a database system (DBMS) can be known from the way his work in the optimizer to process SQL commands made by users and application programs that use it. As a database server, MySQL database support the operation of transactional and non-transactional database operation. In non-transactional mode of operation, MySQL can be said to excel in terms of performance than the database server software competitors. However, on non-transactional mode there is no guarantee of reliability of stored data, therefore non-transactional mode is only suitable for the type of applications that do not require reliability data such as web-based blogging application (WordPress), CMS, and the like. For the needs of system intended for business are strongly advised to use transactional database mode, it's just that as a consequence the performance of MySQL in transactional mode is not as fast performance in non-transactional mode.
MySQL Privileges
MySQL has several features, among others:
Portability. MySQL can run stable at a variety of operating systems like Windows, Linux, FreeBSD, Mac Os X Server, Solaris, Amiga, and many more.
Open source software. MySQL is distributed as open source software, under GPL license so it can be used for free.
Multi-user. MySQL can be used by multiple users at the same time without experiencing any problems or conflicts.
'Performance tuning', MySQL has an amazing speed in dealing with simple queries, in other words more SQL can process per unit time.
Variety of data types. MySQL has a range of very rich data types, such as signed / unsigned integer, float, double, char, text, date, timestamp, and others.
Commands and Functions. MySQL has a full service and functionality that support the Select and Where command in a command (query).
Security. MySQL has several layers of security such as the level Subnet, host name, and permit access to users with a detailed licensing system and encrypted passwords.
Scalability and Restrictions. MySQL database capable of handling large scale, with the number of records (records) more than 50 million and 60 thousand and 5 billion row table. In addition, the index limits that can fit up to 32 indexes on each table.
Connectivity. MySQL can connect with clients using TCP / IP, Unix sockets (UNIX), or Named Pipes (NT).
Localisation. MySQL can detect an error message on the client by using more than twenty languages. Notwithstanding that, the Indonesian language has not been included in it.
Interface. MySQL has a user interface (interface) to various applications and programming languages by using the function API (Application Programming Interface).
Client and Tools. MySQL comes with various tools (tool) that can be used for database administration, and on any equipment that is included instructions online.
Table structure. MySQL has a table structure that is more flexible in dealing with ALTER TABLE, compared to other database sort of PostgreSQL or Oracle.
Download:
MySQL 5.1.54