MySQL master-slave replication + proxy: Client Access Proxy Server, read,write request to proxy recognition, thereby reducing the complexity of the client program. "192.168.4.10, 192.168.4.11 as MySQL master, slave server, is the backend of the
MySQL date formatting (format) range of values.
value
meaning
Seconds
%s,%s
Two digits in the form of seconds (00, 01, ..., 59)
Score of
%I,%I
Two digits in the form of points (
my.cnf is a configuration file that is loaded at MySQL startup and is typically placed in the MySQL installation directory and can be loaded by users in other directories.After installing MySQL, there will be multiple MY.CNF files in the system,
Just want to write a delete duplicate statement and keep a data of SQL, online check a part of the information written in very detailed, but still here to write their own understanding, in order to follow the study. As follows:Table fields and
[TOC]1. Install MySQL1.1 in RedHat using Yum mode to remove the system's own MySQL 5.1rpm|grep mysql #查看已经安装的mysqlrpm -e mysql #普通删除模式rpm -e --nodeps mysql #强力删除模式1.2 Uninstall RPM package with Yum to prevent MySQL installation
Partition the table, but still on the same server,Partitioning is divided into multiple locations, divided into multiple tables, is actually a logical table (is a virtual table), is divided into multiple tables, but management can be managed by the
Combined indexReferring to the combined index, we all know the "leftmost prefix" principle. For example, creating an index Idx_name_age (name,age), typically where age=50 or where age>50, is not used to idx_a_b. Is there any special
0, Introduction20180125 days, Busy! The blind man summed up, to satisfy this is a diary of the appearance.1, today is not talking about technology "of course, there is no technology (all very basic)" but the blind few pull.First, about a kind of
I. Overview MySQL provides database replication (replication) functionality from the 3.23.15 release, which enables two database synchronization, master-slave mode, and backup mode. This document mainly describes how to use MySQL's replication in
Reference Address: http://www.jb51.net/article/49346.htmIn a database table, indexing a field can greatly improve query speed. Suppose we create a mytable table:Copy CodeThe code is as follows: CREATE TABLE mytable (ID INT NOT NULL, username VARCHAR
Personal summary of MySQL base statements (including views, functions, clauses, etc.)A lot of beginners may be the same as me when I first touch the SQL statement to practice but always forget the statement format, in order to solve this annoying
First, the number type
Type
Range
Description
Char (N) [binary]
n=1~255 charactersBinary: Distinguish case
Fixed length
Std_name Cahr (+) NOT NULL
VarChar (N) [binary]
n=1~
Install: File---setting--project---project interpreter--Select version, click on the right + sign, search pymysql---InstallSteps:1, connect to MySQL, specify IP port number, account, password, database, equivalent to open the warehouse door2, create
1 how MySQL works1.1 MySQL Architecture:Connection poolSQL interfaceAnalyzerOptimizerQuery cacheStorage EngineFile systemManagement tools1.2 Permanent definition:Modifying a configuration file/etc/my.cnf[MySQL]Variable name = value1.3 Temporary
1 OverviewThere are four ways to optimize a database:Index policy, explain to determine the validity of indexes, removing redundant indexes, preserving valid indexesStand-alone cache, MySQL internal key cacheSide-hanging caches, such as Redis or
In MySQL 5, an error message appears:Field ' id ' doesn ' t has a default valueWww.2cto.comWorkaround One:Open My.ini, findSql-mode= "Strict_trans_tables,no_auto_create_user,no_engine_substitution"Revision changed toSql-mode= "No_auto_create_user,no_
MariaDB binary installation, mariadb binary
Download the binary installation package
wget http://mirrors.neusoft.edu.cn/mariadb//mariadb-10.2.12/bintar-linux-x86_64/mariadb-10.2.12-linux-x86_64.tar.gz
Create a mysql user and group
useradd -r mysql
Mysql user management and permissions, mysql user management Permissions
1. Set the password
Set password for username @ localhost = password ('Password ');
2. Cancel the password
Set password for username @ localhost = password ('');
3. Create
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