MySQL (relational database management system)

MySQL is a relational database management system developed by the Swedish MySQL AB company and is currently part of Oracle's product portfolio. MySQL is one of the most popular relational database management systems, and MySQL is the best RDBMS (relational database Management system) application software for WEB applications.

MySQL is a relational database management system, where relational databases store data in different tables rather than putting all of the data in a large warehouse, which increases speed and increases flexibility.

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software has adopted a dual licensing policy, divided into community and commercial version, due to its small size, fast, low total cost of ownership, especially the open source, the development of the general small and medium-sized web site to choose MySQL as the site database.

Thanks to the performance of its community edition, PHP and Apache make a good development environment.

Application environment
Compared to other large databases, such as Oracle, DB2, and SQL Server,mysql have its shortcomings, but this does not diminish its popularity at all. MySQL provides more than enough functionality for general personal users and small and midsize businesses, and because MySQL is open source software, it can significantly reduce total cost of ownership.
Linux as the operating system, Apache or Nginx as a Web server, MySQL as a database, Php/perl/python as a server-side scripting interpreter. Since these four software are free or open source software (FLOSS), it is possible to use this method without spending a penny (excluding labor costs) to establish a stable, free website system, known as the "LAMP" or "LNMP" combination in the industry.

System Features

1. It is written in C and C + + and tested with a variety of compilers to ensure the portability of the source code.

2. Supports various operating systems such as AIX, FreeBSD, HP-UX, Linux, Mac OS, Novellnetware, OpenBSD, Os/2 Wrap, Solaris, Windows, and more.

3. Provides APIs for a variety of programming languages. These programming languages include C, C + +, Python, Java, Perl, PHP, Eiffel, and Ruby. NET, Tcl and so on.

4. Support multi-threading and make full use of CPU resources.

5. Optimized SQL query algorithm to improve query speed effectively.

6. Can be used as a separate application in the Client server network environment, but also as a library and embedded in other software.

7. Multi-language support, common encoding such as Chinese GB 2312, BIG5, Japanese shift_jis, etc. can be used as data table name and data column name.

8. Provides a variety of database connectivity pathways such as TCP/IP, ODBC, and JDBC.

9. Provides management tools for managing, inspecting, and optimizing database operations.

10. Support for large databases. You can handle large databases that have thousands records.

11. Supports multiple storage engines.

12.MySQL is open source, so you don't have to pay an extra fee.

13.MySQL uses the standard SQL data language form.

14.MySQL has a good support for PHP, and PHP is the most popular WEB development language today.

15.MySQL can be customized, using the GPL protocol, you can modify the source code to develop their own MySQL system.

16. Online ddl/change function, data architecture supports dynamic application and developer flexibility (5.6 new)

17. Replicate the global transaction identity, which supports self-healing clusters (5.6 new)

18. Replication no crash slave for increased availability (5.6 new)

19. Copy multi-threaded slave to improve performance (5.6 new)

20.3 Times times faster performance (5.7 new)

21. New Optimizer (5.7 new)

22. Native JSON support (5.7 new)

23. Multi-source replication (5.7 new)

24.GIS Space Expansion (5.7 new)

be willing to learn more about: mingli.com

Friends need to add ball: 2042849237
Have detailed knowledge sharing about more MySQL. Thank you!

This article is from the "Xiao Little Fish" blog, please make sure to keep this source http://12865007.blog.51cto.com/12855007/1927563

MySQL (relational database management system)