Introduction MySQL has a lot of tools to administer MySQL in command line. Most are provided as part of “MySQL utilities” offered by Oracle. Others are free software developed by
Installation and compilation from source code 3/3Installation and compilation from source code 3/3
SSL Setup The SSL setup is valid since MySQL 5.7.6 : shell> bin/mysql_ssl_rsa_setup –datadir=/var/lib/mysql/ As a reminder, now, the current folder is /usr/local/mysql/ Here is what the command execution must
Installation and compilation from source code 2/3Installation and compilation from source code 2/3
Compilation Once the previous step is done, we can compile : shell> make The operation, which gives the reader the time to take a shower or a bath, or even
Installation and compilation from source code 1/3Installation and compilation from source code 1/3
Some MySQL options must be positioned during the time of compilation of the software. For exemple, the weighting system for full text search in natural langage can be adjusted, but
InstallationInstallation
Installation of MySQL 5.7 by package manager on Debian 8.0 « Jessy » This chapter describes, as an example, the steps needed to install MySQL 5.7 on a Linux server.
Storage engines 2/2Storage engines 2/2
2/2 InnoDB InnoDB is the default engine of MySQL 5.7. It’s a complete transactional engine wich supports since yet the full text search, last argument that pleaded , until recently
Storage engines 1/2Storage engines 1/2
1/2 ARIA 1 .5 version ARIA is a storage engine for MySQL and MariaDB. It supports full text search, OpenGIS datatypes, and generated columns. It sets a recovery mechanism in
ArchitectureArchitecture
The MySQL architecture is as follows. One MySQL particularity is to have pluggable storage engine, each engine having his own features. It allows to choose an engine according to special
MySQL 5.7 installationMySQL 5.7 installation
Introduction On october 26, 2015, MySQL 5.7 is released for the first time in «General Availability» version with revision 5.7.9. The pression of the competition of other opensource database and