MySQL master-Slave library synchronization

#主库修改my. INI[mysqld]Server-Id=2Log-Bin=Mysql-Binbinlog-Do-Db=demo# modifying My.ini from a library[mysqld]Server-Id=3Replicate-Do-Db=Demo--Restart master and slave libraries after configuration is complete#主库为从库添加用户Grant

MySQL Sub-query

The select sentence that appears in other SQL statements. (Nested select in select)#求出学生的平均年龄Select AVG (age) from Stu_details;#查找出大于平均年龄的数据Mysql> SELECT * from Stu_details where >18.25;#将平均数的SQL语句作为子查询放入上一条语句中Mysql> SELECT * from Stu_details where >

mysql-5.7.21 start error, modify database storage directory

mysql-5.7.21 start error, Permanent solutionchmod +x/etc/rc.d/rc.local#往里面写入两条命令, which means to automatically create mysqld and modify owner permissions for bootEhco "Mkdir-p/var/run/mysqldChown-r

MySQL's common storage engine

(1) InnoDB engine, InnoDB engine provides support for database acid transactions. It also provides row-level and foreign-key constraints. Its design goal is to deal with large data capacity of the database system.(2) Myiasm engine (the original

MySQL Create user and authorization

Rights Management:We know that our top authority manager is the root user, and it has the highest permissions. Includes select, Update, delete, update, Grant, and so on. So in general, after the company, the DBA engineer creates a user and password

How does MySQL achieve two-way mutual primary replication?

bidirectional Mutual Master from step:12 machines Add a cluster machine access to the account given replication slave permissionsmysql> grant replication Slave on * * to ' rep ' @ ' 172.16.1.% ' identified by ' 1234566 ';22 Machine parameter

Centos7 Source Installation MySQL

1) Download the required#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.gzversion 5.7 needs to download a boost C + + 1.59.0, (slow download)# wget

Linux installation MySQL Related

The newly installed CentOS 6.9 virtual machineModifying the Yum server sourcecd/etc/yum.repos.d/Rename Repo repo.bak_$ (date +%f) *Ali's Yum Library Https://opsx.alibaba.com/mirror Open Point HelpCurl-o/etc/yum.repos.d/centos-base.repo

Haproxy+mysql implementing proxy MySQL

we typically run into a business scenario like this:b host and C database in the same intranet, a host cannot directly access the C database, we can build the agent on the B host let a access C database, we use Haproxy to do this thingCENTOS7

MySQL Related commands

1. Check if the MySQL server is started-| grep mysqldHow to display the following, proof has been startedlocalhost:~ mhx$ Ps-ef | grep mysqld0 1053 1 0 9:59 am ttys000 0:00.03/bin/sh/usr/local/mysql/bin/mysqld_safe--datadir=/usr/local/mysql/data--pi

04-Initial MySQL statement

This lesson first experiences the basic syntax of MySQL. Action folder (library) increaseCreate Database db1 charset UTF8;Check# View the currently created database Show Create database db1; # View all databases show databases;ChangeALTER DATABASE

Delete duplicate data in MySQL keep only one bar

With SQL statements, delete duplicates only keep oneIn thousands of records, there are some same records, how can you use SQL statements, delete duplicates1, look for redundant records in the table, duplicate records are based on a single field

MySQL Modify table field order

Modify field arrangement position ALTER table name MODIFY field name 1 data type first| After field name 2 Parameter Description First, optional parameters Change Field 1 to the first field in the table. After field name 2 Insert Field 1 to the back

MySQL Multi-table query

Multi-table query, SQL JOINS1. INNER JOIN inside joinsSelect S.name as student_name,t.name as Teacher_name from students as s inner joins teachers as T on S.teacherid=t.tid; /*2 table take intersection, inner connection */2. Cross-ConnectSELECT *

MySQL basic commands

Querying existing databases: show databases;Operations on the database:1. Delete database: Run drop database + name;2. Add Database: Run CREATE DATABASE + name;Operations on a table:First you have to open the database of the table you want to

MySQL database export and import under Linux and daily backup

of the MySQL databaseExport1. Export the database as a SQL fileMysqldump database name-uroot-p > XXX.SQL Export data table structure and dataeg. Mysqldump cloudres-uroot-p > Cloudres.sql2. Export to GZ compressed fileMysqldump Database name-uroot-p |

MySQL Storage engine

MyISAM Storage EngineAdvantages: Supports up to 256TB of storage space Read data faster and consume less resources MyISAM Engine Storage File: TBL_NAME.FRM: Table-style definition Tbl_name. MYD: Data files Tbl_name.

MySQL Query--go to heavy

INSERT into ' material ' (' id ', ' file_url ')SELECT id,ekm. ' File_url 'From ' extmaterial ' as EKMLeft JOIN (SELECT ' file_url ' from ' material ' WHERE ' id ' = ID) as PM on PM. ' File_url ' = EKM. ' File_url 'WHERE EKM. ' ext_id ' = Extid and

MySQL GROUP by group and having filter grouping

1,group by creating a groupIn MySQL group by sentence to note that must after where the order bySelect Order_code, COUNT (*) as product from order group by Order_code;2,having Packet filteringThe WHERE clause can be replaced by the having, the

MySQL installation and initial knowledge of the two Yum

   installation Yum Install Mysql-serverChkconfig-list mysqld to see if the MYSQLD service is booting upchkconfig mysqld on set to bootService mysqld start mysqld ServicesSs-ntl (3306) after automatic completion, the corresponding port automatically

Total Pages: 3233 1 .... 2899 2900 2901 2902 2903 .... 3233 Go to: GO

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.