A. Mysql
MySQL is an open source database server used by various well-known mainly for server applications or create WEB. Mysql function as SQL (Structured Query Language) to its own and has been expanded by MySQL is commonly used in conjunction with PHP to create a dynamic application server and powerfull :).
Not the same with projects like Apache, where the software was developed by the general community, and the rights to 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 to all the code almost the source. Both the Swedes and the Finns who founded MySQL AB are: David Axmark, Allan Larsson and Michael "Monty" Widenius.
MySQL is an implementation of the relational database management system (RDBMS) that is distributed for free under the GPL (General Public License). Each user can freely use MySQL, but with restrictions that software should not be used as a commercial derivative products. MySQL is actually a derivative of one of the main concepts in the database that have been there before; SQL (Structured Query Language). SQL is a database operation concept, especially for election or selection and data entry, which allows easy operation of the data done automatically.
The reliability of a database system (DBMS) can be determined from the workings of his optimizer in the process of SQL commands made by the user and the application programs that use it. For database servers, MySQL databases operating support transactional and non-transactional database operations. In the non-transactional mode of operation, MySQL can be said is superior in terms of performance compared to software database servers other competitors. However, in non-transactional mode there is no guarantee the reliability of the data stored, therefore non-transactional mode is only suitable for the type of applications that do not require data reliability applications such as web-based blogging (WordPress), CMS, and the like. For system requirements aimed at businesses 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 on a variety of operating systems such as Windows, Linux, FreeBSD, Mac OS X Server, Solaris, Amiga, and many more.
Open source software. MySQL is distributed as open source software, licensed under the GPL 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 variety of rich data types, such as signed / unsigned integer, float, double, char, text, date, timestamp, and others.
Command and Function. MySQL has a full operators and functions that support the command Select and Where in command (query).
Security. MySQL has several layers of security such as the level subnetmask, host name, and user access permissions to a detailed licensing system and encrypted passwords.
Scalability and Restrictions. MySQL database is capable of handling large scale, with the number of records (records) of more than 50 million and 60 thousand tables and 5 billion rows. Besides the index limits that can fit up to 32 indexes on each table.
Connectivity. MySQL can not connect to the client using TCP / IP, Unix sockets (UNIX), or Named Pipes (NT).
Localization. MySQL can detect the error message on the client by using more than twenty languages. Nonetheless, the Indonesian language has not been included in it.
Interface. MySQL has a user interface (interface) for different applications and programming languages by using the API (Application Programming Interface).
Clients and Tools. MySQL comes with a variety of equipment (tools) that can be used for database administration, and on any equipment that is included instructions online.
The structure of the table. MySQL has a more flexible structure of the table in dealing with ALTER TABLE, other than a kind of database PostgreSQL or Oracle.
0 Komentar untuk "What is MYSQL"