MySQL Master-Slave synchronization configuration

1. MySQL master-Slave synchronization configuration 1.1. Basic informationDatabase master server ip:127.0.0.1Database from server ip:192.168.1.311.2. Primary server configuration file My.ini configuration (Master)[Mysqld]#打开日志 (the host needs to

Linux MySQL scheduled backup

The project needs to be backed up regularly, and the following are its own operating notes1. Check disk space  # Df-hfilesystem Size used Avail use% mounted on/dev/vda1 40G 3.6G 34G 10%/tmpfs 16G 0 16G

MySQL Change password

Method 1: Use the Set password commandFirst log in to MySQL.Format:mysql> set password for user name @localhost = password (' new password ');Example:mysql> set password for [email protected] = password (' 123 ');Method 2: Use MysqladminFormat:

mysql--automatically numbering, adding columns, deleting columns, inserting data, deleting data, modifying data

At the time of creationCREATE TABLE si (Id INT auto_increment)Automatic numbering, can not have more than one automatic column (can be automatically coded for you)If you add a column to it in a S11 form (this is not the same as inserting data)ALTER

MySQL master-slave installation précis-writers

Install two database version 5.7.1910.168.21.180 GSM1 Gsm1.localdomain10.168.21.181 gsm2 Gsm2.localdomainInstalling the SoftwareConfigure/ETC/MY.CNFBuild Library mysqld--defaults-file=/etc/my.cnf--initialize--user=mysqlStart

MySQL source package compilation and installation

1. Install dependent packagesYum-y Install Ncurses-devel Libaio-devel2, download CMake package, unzip, compileWget-q https://cmake.org/files/v2.8/cmake-2.8.8.tar.gz TAR-XVF cmake-2.8.8.tar.gzcd cmake-2.8.8./configureCompile error is generally

Windows 2008 installation Apache + MySQL + php

Download preparationphp:http://windows.php.net/downloads/releases/archives/apache:https://www.apachehaus.com/cgi-bin/download.plx#apache24vc09Get readyCreate folder under E-disk webserver for PHP + apache + mysql and www directoriesPut the

MySQL optimization three (two simple and practical optimization methods)

I. Periodic checklists and Analysis tablesThe syntax for the parse table is as follows:ANALYZE [LOCAL | No_write_to_binlog] TABLE tbl_name [, Tbl_name] ...This statement is used to analyze and store the keyword distribution of the table, and the

Solving the problem of "mysql-bin.000001" occupying oversized space

Description: mysql-bin.000001, mysql-bin.000002 files, such as the database operation log, such as update a table, or delete some data, even if the statement does not have matching data, the command will be stored in the log file, also includes the

Implementing MySQL Query db instance with Python

#coding: Utf-8 ' Created on October 25, 2017 @author:li.liu ' import pymysqldb=pymysql.connect (' localhost ', ' root ', ' root ' , ' Test ', charset= ' UTF8 ') m=db.cursor () "Try: #a =raw_input (' Please enter SQL statement ' + ' \ n ') m.execute (

(ii) MySQL intermediate article

1. Views ViewA view is a virtual table whose contents are defined by a query. A filter that defines a view can come from one or more tables or other views of the current or other database.Advantages of the View:① simplifies operations by defining

K8s the first instance to create a MySQL service

k8s

apiVersion:v1kind:ReplicationControllermetadata: name:mysqlspec: 1 selector: app:mysql Template: metadata: Labels: app:mysql Spec: containers: - name:mysql

Use of MySQL indexes

MyD is a file that stores data, and Myi is an index file.The index improves the query speed, reduces the speed of adding and deleting, not the more the better.Type of index:1, key, general index2. Unique key, single indexCREATE TABLE T12 (Name Char (

Installing the MySQL Database

1. Install MySQL Database① download MySQL Packetwget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz② Extracting packages under/USR/LOCAL/SRCTar zxvf mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz③ Rename the unpacked

MySQL 44th article ~ talk about the most basic specifications

A brief introduction: Today we talk about research and development normsTwo specifications1 table1 Choosing the right character set and storage engine recommended InnoDB UTF8MB42 table name do not include MySQL keyword, conform to naming convention3

MySQL Remote login error correction

Telnet to the Linux server above MySQL, there are two minor errors:1:10,060 Error Server firewall on stateSetup-> shut down the firewall (sometimes you may not find the related settings and need to install the relevant management software)2: Host is

MySQL multi-column index classic case

A classic multi-column index case, such as the title: 假设某个表有一个联合索引(c1,c2,c3,c4)一下——只能使用该联合索引的 c1,c2,c3 部分Awhere c1=x and c2=x and c4>x and c3=xB where c1=x and c2=x and c4=x order by c3C where c1=x and c4= x group by c3,c2D where c1=x and c5=x

MySQL Installation Employees DB

The steps are as follows:First, downloadAddress: https://launchpad.net/test-db/employees-db-1/1.0.6Second, decompressionUnzip the downloaded files and store them in any directory, but for convenience, it is recommended to place them in a shorter

MySQL multi-table query instance results and analysis-2017.12.14

Today to help run the data found that SQL execution is very slow, well, according to the previous writing habits, and later with the architect to analyze the discussion, improved, the current record analysis is as followsFirst, the test table, SQL

WIN10 MySQL Detailed installation tutorial

My Computer system is a WIN10 64-bit system.I installed MySQL not less than 5 times, loaded and unloaded, unloaded and loaded, read the old articles and blogs, very grateful to bloggers for their selfless help, the following are the bloggers of the

Total Pages: 3233 1 .... 2192 2193 2194 2195 2196 .... 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.