Far from history, MySQL's main purpose is to be able to execute on a single processor core business Server. Now a change in MySQL users may not notice that Oracle has started to structure the MySQL code again, making it a lot of modularity. such as software parsers, optimizations and replication functions are rewritten in a modular format.
The version number of the query performance significantly improved, 1 time times higher than the MySQL 5.6, the new version of MySQL on the test platform can be up to 512000 per second to read the QPS, and MySQL 5.6 up to only 250000 QPS. This performance improvement is achieved through its Memcached plug-in. At the same time, the version number has been improved in other aspects of the database, such as reducing the time it takes to establish a database connection, thanks to Facebook's contribution.
1. First we understand the features of MySQL
Features of MySQL
- Use C and C + + written, and use a variety of compilers to test, to ensure the portability of the source code.
- Supports various operating systems such as AIX, BSDi, FreeBSD, HP-UX, Linux, Mac OS, Novell Netware, NetBSD, OpenBSD, Os/2 Wrap, Solaris, SunOS, Windows, and more.
- Provides APIs for a variety of programming languages. These programming languages include C, C + +, C #, Delphi, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl.
- Support multi-threading, make full use of CPU resources, support multi-user.
- Optimized SQL query algorithm to improve query speed effectively.
- It can be applied either as a standalone application in a client server network environment or as a library and embedded in other software.
- 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.
- Provides a variety of database connectivity pathways such as TCP/IP, ODBC, and JDBC.
- Provides management tools for managing, inspecting, and optimizing database operations.
- You can handle large databases that have thousands records.
English MySQL document:Http://tool.oschina.net/apidocs/apidoc?api=mysql-5.1-zh
English MySQL document:http://tool.oschina.net/apidocs/apidoc?api=mysql-5.5-en
2. Below we start downloading MySQL
Open http://dev.mysql.com/downloads/mysql/Select Developer Version number
Select the version number of Rhel
Download the 32 or 64-bit MySQL version number you need for the corresponding x86 architecture click to download
Select Download Now or download tool to open
Http://cdn.mysql.com/Downloads/MySQL-5.7/MySQL-5.7.4-m14-0.2.m14.el7.x86_64.rpm-bundle.tar
3. Transfer MySQL into the virtual machine
Start RHEL7 We need to install the root user in order to be more direct we log in directly with root
4. Release the installation package: TAR-XVF Mysql-5.7.4-m14-0.2.m14.el7.x86_64.rpm-bundle.tar
5. Start the installation
Show conflict I should uninstall the original software mariadb-devel and MARIADB
RPM-E--nodeps mariadb-libs-5.5.33a-3.el7.x86_64
RPM-IVH mysql-community-common-5.7.4-0.2.m14.el7.x86_64.rpm
RPM-IVH mysql-community-libs-5.7.4-0.2.m14.el7.x86_64.rpm
RPM-IVH mysql-community-embedded-5.7.4-0.2.m14.el7.x86_64.rpm
Rpm-e Mariadb-devel–nodeps
Rpm-e Mariadb–nodeps
RPM-IVH mysql-community-devel-5.7.4-0.2.m14.el7.x86_64.rpm
RPM-IVH mysql-community-embedded-devel-5.7.4-0.2.m14.el7.x86_64.rpm
RPM-IVH mysql-community-client-5.7.4-0.2.m14.el7.x86_64.rpm
Mount your image on the CD drive of the virtual machine
Install several dependent packages into the ISO file
RPM-IVH perl-net-daemon-0.48-4.el7.noarch.rpm
RPM-IVH perl-plrpc-0.2020-12.el7.noarch.rpm
RPM-IVH perl-dbi-1.627-1.el7.x86_64.rpm
Work path back to the desktop and then continue to install our server
RPM-IVH mysql-community-server-5.7.4-0.2.m14.el7.x86_64.rpm
6. Change user Password
When the server is installed, we'll find the key file.
Find/-name. Mysql_secret
Login to MySQL with the root user was denied access, so we switch users
Login again
Replace password into a simple demo example of 123456
Well, the installation of MySQL for RHEL 7 ends. CentOS 7 was also released a few days ago, and this installation package is also for installation on CentOS7, after all, these two OS are binary compatible.
Unix/linux Environment C Programming Novice Tutorial (in) MySQL 5.7.4 for Red Hat Enterprise 7 (RHEL7) installation