MySQL

1. Create a new SH script (you can first build a txt text and then change to SH file).The code is as follows:#!/bin/bash#set up MySQL backup directoryfolder=/**/**CD$folder Day=`Date+%y%m%d ' RM-rf$daymkdir $dayCD$day#Database ServerIp=ip

MySQL master-slave copy function principle 1, in the business complex system, there is a scenario, there is a SQL statement need to lock the table, resulting in the temporary inability to use the Read service, then it will affect the

Today, colleagues encountered a problem, wrote a paging function, the results found that the data has been duplicated, some data at the same time in the adjacent two pages appear,But the query total data is not paged when there is only one, here is

Tag: Key equals bin name 127.0.0.1 database name Mail primOne, log in to the MySQL database server from the command line1. Log in with MySQL using the default 3306 port/usr/local/mysql/bin/mysql-u root-p2. Manage multiple MySQL on different ports

The first step: Download https://dev.mysql.com/downloads/mysql/on the websiteStep Two: Extract to a folderStep Three: Configure environment variablesTo insert a%mysql_home%\bin into the last face of a path.Fourth step: Run the command line as an

MySQL master-slave copy and read/write separate MySQL read and write separation principle Read-write separation is only written on the primary server and is read only from the server. This is based on the principle that the primary database

MySQL Master-slave replication MySQL master-slave replication is an asynchronous replication process in which the main library sends update events to the library, reads the update records from the library, and executes the update records,

MySQL partitioned partitions are two ways to solve the poor MySQL performance caused by large data volumes.What is MySQL sub-tableFrom a superficial point of view, the MySQL sub-table is to divide a table into multiple tables, and the data and

This example uses a table task with the following structuremysql> desc Task;+-------------+------------+------+-----+-------------------+-------+| Field | Type | Null | Key | Default | Extra |+-------------+------------+------+-----+-----------------

The first step: building a frameworkNew enter this pageNew name, first time can default, then nextStep Three: Select dependenciesFourth step: Create a new project name and store the project path (you can create a new folder to store)Click Finish,

In response to the company's needs, to create a more secure MySQL cluster, to achieve MySQL failover after the switch, the study of a few days finally have the results, share.First, introduce the function of this cluster scheme.1, MySQL server after

1. mysql View userMysql> select User,host,password from Mysql.user;2. mysql Password changemysql> Update mysql.user set Password=password ("Anonymous") where user= "root" and host= " localhost "; (set new password)mysql> flush privileges; (refresh)3.

1. Configure Epel Source Installation Sysbenchyum install -y sysbench2. Initialize datasysbench /usr/share/sysbench/tests/include/oltp_legacy/oltp.lua --mysql-host=192.168.1.226 --mysql-port=3306 --mysql-user=root --mysql-password=MySQL5.7

1) Download the installation package,version 5.7 needs to download a boost C + + 1.59.0, (slow download)#cd/data/soft# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.21.tar.gz# tar-xfzf mysql-5.7.21.tar.gz# wget

Tag: Ike DESC Score--Cannot use CREATE database processingModelCreate Database Sky;Use Sky;CREATE TABLE M1 (ID Int (11),Name Char (20),Age tinyint (10),Sex enum (' Male ', ' female '),Score tinyint (10),Address char (20)) default Charset=utf8;INSERT

MySQL database provides a very useful tool mysqldump to back up the database, the following will use the mysqldump command to back up all the databases and specify the databaseOne, mysqldump backup all database data at

1, VirtualBox to Ubuntu system settings, "Network" select "Bridge network card"2. Install MySQL serversudo su; Apt-get Intall Mysql-server3. Grant permission to remote access:Grant all privileges on * * to ' root ' @ '% ' identified by ' 123456 '

First, the installation package download (canal.deployer-x.x.x.tar.gz official recommended to use the 1.0.22 version)Https://github.com/alibaba/canal/releasesSecond, unzip the fileTAR-ZXVF canal.deployer-1.0.22.tar.gz-c/app/canal/Iii. modification

Method 1:1. Stop the MySQL service# Kill ' Cat/var/run/mysqld/mysqld.pid 'Or# Pkill Mysqld2. Create a text file for a password assignment statement# VI Mysql-initALTER USER ' root ' @ ' localhost ' identified by ' mynewpass!6 ';Resets the password

The implementation principle of database replication replication1. The primary server, where the statement is run, produces a binary log binlog2. Continuously read the binlog of the master server from the server3. Binlog translated from the master