MySQL

1. Synchronizing a small number of librariesBinlog-do-db=db_pxREPLICATE-DO-DB=DB_PX---If you need to update across databases and you do not want to replicate these and new, you should use this optionREPLICATE-DO-TABLE=DB_PX----Allow cross-database

1, install the Yum source, has downloaded the installation package------------------------------------------------RPM-IVH epel-release-latest-7.noarch.rpm------------------------------------------------2. Install VimYum-y Install Vim-----------------

Ideas:The two machines are mainly from each other.Machine 1:192.168.1.160Machine 2:192.168.1.164Modify the My.cnf file for both machines, server-id,log-bin,auto-increment-increment,auto-increment-offset The following two parameters are set to

Ready to deploy the project on Linux, using the MySQL database, so want to download the installation version for Linux, in the MySQL official website to find a half-day, finally found how to download, here to write, after everyone to find the time

System: CentOS 6.5Software: mysql-5.6.36.tar.gz,libunwind-1.2.tar.gz,google-perftools-1.9.tar.gz,cmake-3.4.1.tar.gz,epel-release-6-8.noarch.rpm[Email protected] ~]# echo "192.168.40.35 king01" >>/etc/hosts[Email protected] ~]# RPM-IVH epel-release-6-

#!/bin/bashMyuser=rootmypass=123456Socket=/data/3306/mysql.sockmycmd= "Mysql-u$myuser-p$mypass-s $SOCKET"Bakpath= "/backup/$ (date +%f)"[!-D $BAKPATH] && mkdir-p $BAKPATHFor dbname in ' $MYCMD-e ' show databases; ' | Sed ' 1d ' |grep-v "_schema" 'Do$

Use of 1.insert_select: Copy data from one table to anotherINSERT into students (name,sex,likebooksnum,likesportnum,average)SELECTName,sex,likebooksnum,likesportnum,averageFrom Students_copy;2.regexp: Use of regular expressions, BINARY is a

MysqlMySQL is a relational database management system, is an open source software. With PHP and Apache can be better performance, but also can work on many platforms . Orcale is a database that creates multiple users, and MySQL is a user who creates

Li Wu:Heng Learn to think together, honouring teachers save Thanksgiving. Leaf See root three return to one, rivers the same oneness.Meekness Conscience Lord, willing to do without regrets to the most bitter. Reading exercises to keep the body and

Master-Slave synchronization, the essence is the use of database logs, the main library data copy to the library, in essence, the use of data replication technology.This article outlines Basic configuration of the main library Basic

MySQL log is divided into error log, binary log, slow query log, query log 1. The error log can be used to view the file of the error log through the following command: Show variables like ' Log_error '; the above command can be used to locate the

Installation Environment Preparation:System version:[Email protected] ~]# cat/etc/redhat-releaseCentOS Linux release 7.4.1708 (Core)SELinux off:[Email protected] ~]# GetenforceDisabledFirewall shutdown:[Email protected] ~]# systemctl status

1. database table name naming specification The use of 26 letters (case-sensitive) and 0-9 of the natural number (often do not need) with an underscore ' _ ' composition; The name is concise and clear, and multiple words are separated

1. Stop the MySQL service, CMD to open the Dos form. Input net stop MySQL2, in the cmd command line form, go to the MySQL installation folder for example E:\Program files\mysql\mysql Server 5.0\binDemonstration command:Enter e: Carriage return,Enter

1.mysql Multi-Instance LoginMysql-uroot-p ' 123456 '-s/data/3306/mysql.sock2. View version and login userSelect version ();Select User ();3. Create the GBK character Set database Rich2Create DATABASE rich2 CHARACTER SET = GBK COLLATE =

Recently in the completion of the MySQL project integration, need to increase the functionality of the batch update, according to the online data collated a bit, very useful, have been tested, can be used directly.MySQL batch update has the

MARIADB is installed by default in CentOS, this is the branch of MySQL, but in order to need, it is necessary to install MySQL in the system, and after the installation is complete, you can overwrite the mariadb directly.1 Download and install the

MySQL replication advantages and principles Replication transfers the DDL and DML operations of the primary database to the slave database through binary logs, and rewrites the data from the slave database to ensure data synchronization between the

Mysql 5.7.21 installation and configuration method graphic tutorial (window), mysql5.7.21 Install mysql5.7.21 in the window environment. The specific content is as follows: 1. Download the free installation package mysql-5.7.21-winx64.zip from

MySQL common functions Aggregate functions Count () queries the number of rows of a fieldMax () queries the maximum value of a fieldMin () queries the minimum value of a fieldSum () queries the sum of a fieldAvg () queries the average value of a