info file

Installing MySQL-5.5.49Getting the installation package: http://mirrors.sohu.com/mysql/# install MySQL requires a dependency package yum install ncurses-devel libaio-devel-y rpm-qa ncurses-devel libaio-devel # Install compile MySQL required software

1. Install MySQL# useradd-s/sbin/nologin-m MySQL# TAR-XVF Mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz-c/usr/local# mv Mysql-5.6.41-linux-glibc2.12-x86_64 MySQL# Chown-r Mysql:mysql/usr/local/mysql2. Configure the multi-instance profile directory#

First, MySQL multi-instance IntroductionOpen several different service ports (3306,33307,3308) on one server, run multiple MySQL service processes, share a set of MySQL installers, multi-instance MySQL is logically independent1, multi-instance

Log-bin binary LogServer-id early version must be added 1-pow (2,32)-1 recommended port number +IP Last 5.6 can be modified dynamicallyServer-uuid (after 5.6) The default exists $datadir/AUTO.CNF can be modified dynamically after 5.6Log-bin-index

MySQL replication is a very important feature of MySQL, which is mainly used for data copy operation between the primary server and the slave server. MySQL replication refers to the process of copying data from one MySQL master server (master) to

MySQL Copy parameters explained1. Parameters on MasterLog-bin #必须Server-id #1-pow (2,32)-1#必须 (Port +ip)Server-uuid #路径为 $datadir/auto.cnfLog-bin-index#必须Binlog-formatBinlog_cache_sizeMax_binlog_sizeSync_binlogExpire_logs_daysLog_bin_trust_function_

MySQL Multi-instanceMkdir/datamkdir/data/3306mkdir/data/3307Mkdir/data/3307/dataMkdir/data/3306/data# VIM/DATA/3306/MY.CNF[Client]Port = 3306Socket =/data/3306/mysql.sock[MySQL][Mysqld]user = MySQLPort = 3306Socket =/data/3306/mysql.sockBasedir

First, MySQL master-slave Replication IntroductionThe master-slave copy of MySQL is not a direct copy of the file on the database disk, but is replicated to the server to be synchronized by the logical Binlog log.The local thread then reads the SQL

Due to background reasons, the master-slave synchronization is to be based on the MySQL 5.1 version, master-slave synchronization is mainly a database read and write access to the original database heat is too large, need to be used from the library

MySQL's master-slave is an asynchronous replication process, which is actually a process of copying data from the master to the slave end. The entire replication process between Master and Slave is performed primarily by three threads, of which two

Binary installation:[[email protected] ~]# mkdir /home/lufeng/tools -p[[email protected]  ~]# cd /home/lufeng/tools   [[email protected] tools]# rz[[email  protected] tools]# tar xf mysql-5.5.49-linux2.6-x86_64.tar.gz[[email protected] 

[Client]Port = 3306 #端口号Socket =/ryzc/mysql/data/mysql.sock #sock文件路径[Mysqld]Port = 3306Socket =/ryzc/mysql/data/mysql.sock # server-side sock file pathPid-file =/ryzc/mysql/data/localhost.pid # PID file storage pathDataDir =/ryzc/mysql/data # data

MySQL Multi-instanceThe simple thing is to open several different service ports (such as 3306,3307, etc.) on a single machine to run multiple MySQL service processes, which provide their own services through different sockets that listen to

I. On-line installationYum List | grep MySQLDisplays the version information for MySQL on the Yum serverInstall with the following command:Yum install-y mysql-server MySQL mysql-develAfter the installation is complete, view the installed version

One, what is MySQL multi-instanceThe simple thing is to open several different service ports on a single machine (for example: 3306, 3307) and run multiple MySQL service processes that provide their own services through different sockets that listen

D.1   Multi-instance structure650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6F/94/wKioL1WiVsPyqtLTAAEhvAoH-C4425.jpg "title=" 2.png " alt= "Wkiol1wivspyqtltaaehvaoh-c4425.jpg"/>D.2   Multi-Instance installationd.2.1Dependency Packages#

MySQL cluster, MySQL master-slave architecture, MySQL load balancerMySQL Master-Slave synchronizationPrinciple:Replication ThreadsMySQL Replication is an asynchronous copy process, copied from one MySQL instace (we call Master) to another MySQL

Simple example:Background code: Public functionlayuiupload () {$upload=New\think\upload ();//instantiating an upload class $imgSize=intval(CP (' imgsize ')); $imgType= CP (' Imgtype '); $imgSize= !Empty($imgSize) ?$imgSize: 3145728; $imgType=

I. Source of the probleminstall MySQL If you can install one manually, but install multiple, manual installation is cumbersome, you need to write a shell program install_mysql.sh to install Two. Procedural notesInstall the MySQL5.1.45 to

Mysql 6.8 Sync startup options Whether it's master or slave, set the Server-id option to make sure they all have their own unique sync IDs. You must select a positive integer between 1 and 2^32-1. For example: server-id=3. For a detailed