Unix/linux Environment C Programming Novice Tutorial (in) MySQL 5.7.4 for Red Hat Enterprise 7 (RHEL7) installation

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