MARIADB Multi-instance: Environment and ideas:
centos7.4
Yum installation implementation.
One version of MySQL is implemented via multiple ports
Plan ports for 3 instances: 3306/3307/3308.
Separate the respective
Xshell command Daquan: reference: 52037032Find a file Find/-name mysql-5.5.60-linux-glibc2.12-i686.tar.gzEnter a path cd/rootDeploying MySQL on a Linux remote server reprint: https://www.2cto.com/database/201803/727660.html1. Pre-preparation1.1
Linux installation mysql5.5.40First, operating system and software
Operating system and version
Centos 6.4
Dependency Packages
GCC, gcc-c++, CMake, Ncurses-devel
Download catalogue
/opt
One, MySQL installation See if MySQL is installedRpm-qa | grep mysql-server
Yum Install Mysql-server
Modifying a configuration file
Vim/etc/my.cnf
Set up system service startupChkconfig mysqld onView settings StatusChkconfig--
Tag: The null safe parameter applies EFI profile log zlib so5 ways to install MySQL:1, yum/rpm installation (suitable for the requirements are not high, concurrency is not big, the company internal, some application scenarios within the enterprise)2.
In production sometimes encounter a host to run multiple MySQL servers----called multi-instanceThe following shows the installation of multiple instancesFirst of all, we planBinary-based installation1. Create a MySQL
1. InstallationSee if you have installed:Yum List installed mysql*Rpm-qa | grep mysql*To see if there are any installation packages:Yum List mysql*To install the MySQL client:Yum install MySQLTo install the MySQL server side:Yum Install
Realize:Yum installs the appropriate libraries because I have to install nginx,php on this machine, so the following libraries are installed# yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel
First, MySQL IntroductionMySQL is a relational database management system developed by the Swedish MySQL AB company, currently owned by the Oracle company. MySQL's most popular relational database management system, MySQL is one of the best RDBMS
MySQL History1979: TCX Company Monty Widenius,unireg1996: Released Mysql1.0,solaris version, Linux version1999: MySQL AB Company, Sweden2003: MySQL 5.0 version, providing features such as views, stored procedures, etc.2008: Sun Acquisition2009:
> MARIADB InstallationYum Install Mariadb-server> Create related directories, and set permissionsMKDIR/MYSQLDB; Mkdir/mysqldb/{3306,3307,3308}/{etc,socket,pid,log,data}-PVChown-r Mysql:mysql/mysqldb#目录结构如下/mysqldb├──3306│├──data│├──etc│├──log│├──pid│
Multi-instance configuration for MySQL? in a physical machine requires multiple test environments, then you need to build a database of multiple instances, multiple instances of the meaning is to run multiple programs, the instance and the instance
MySQL Common commandsNote: The bold part is the part that the user needs to replace according to their actual situation, the italic part is the optional content, #开头的命令是在终端中执行,> the beginning of the command is executed in MySQL1. Log in to MySQL
How to start fedora 16 yum after mysql is installed, and add to System Service 1 yum install mysql # yum install mysql-server mysql-devel if ERROR 2002 (HY000) is encountered ): can't connect to local MySQL server through socket '/var you Can use
sometimes for server security, to prevent others from prying into the commands we enter, we can clear the history, and more often we choose to force history to not remember the command when entering special commands. Experimental method: Execute the
1. Mysql Installation Method
Mysql is a platform-independent open-source relational database. you can install and deploy the Mysql database in rpm mode, which is also the simplest. However, for the rpm version, the functions of the Mysql database
How to start/stop/restart MySQL
I. Startup Mode
1. Start with service: Service mysqldStart
2. Use the mysqld script to start:/etc/inint. d/mysqld start
3. UseStart safe_mysqld: safe_mysqld &
Ii. Stop
1. Use ServiceStart: Service mysqld stop
2. Use
Install Mysql database on LinuxCheck whether the installation has been installed:
yum list installed mysql* rpm -qa|grep mysql*
Check whether the installation package is available:
yum list mysql*
Install the mysql client:
yum install mysql
How to Start fedora16yum after mysql is installed and add it as the system service Fedora
BitsCN.com
Fedora 16 yum how to start mysql after installation and add it as a system service
1 yum install mysql
# Yum install mysql-server mysql-devel
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.