MySQL

1 OverviewIn general, there is only one primary node, there are multiple from the node, only read operations are supported from the node, and the master node supports write operations.The realization of read and write separation has two solutions,

1. Open MySQL Access port 3306 Modify the firewall profile Vi/etc/sysconfig/iptables join port configuration Note: The added open 3306-port statement must be before icmp-host-prohibited-A input-m State--state new-m tcp-p TCP--dport 3306-j accept

Often for convenience and intuitive, we will first directly in the database design tables, but then the structure and design of the table will be written in the design document, so that the code can be intuitive query, once the database table is

Print 99 multiplication table: #!/bin/bashfor num in ' seq 9 ' does for NUM1 in ' seq 9 ' do if [$num-ge $num 1]; Then if ((($num * $num 1) >9) then Echo-ne "${num}x${num1}=$ (($num * $num 1) \ t \" Else Ech O-ne "${num}x${num2}=$ (($num * $num 1) \

Linux operations must be the MySQL enterprise face question Daquan recommendation(1) Examination of the basic written order 1. Turn on MySQL service/etc/init.d/mysqld startservice mysqld startsystemctl start mysqld2. Detect if the port is

Working with the MySQL service for AWS and Azure, you need to test the performance of the two cloud services. So start Baidu + Google, find performance testing tools. Finally decided to use Sysbench.Sysbench IntroductionSysbench is an open source

King01 as Master king02 with king03 as King01 slave,king04 as Mha_manager[[email protected] ~]# mkdir. SSH[[Email protected] ~]# CD. SSH[email protected]. ssh]# ssh-keygen-t dsa-p "-F ID_DSA[email protected]. ssh]# Cat id_dsa.pub >> Authorized_keys[[

[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

Recently because the business requirements need to calculate the age according to the date of birth, on-line check a lot of methods, summarized here.On the Internet, many of the calculation methods have referred to the Gregorian calendar,

MySQL adds a time interval for the date: Date_add ()Now ()//now function to get the current timeSelect Date_add (now (), Interval 1 day); -Plus 1 daysSelect Date_add (now (), interval 1 hour); -Plus 1 hoursSelect Date_add (now (), interval 1 minute);

This is my study note for my old boy teacher's MySQL DBA Advanced OPS course, the old boy teacher spoke very well and thanked the old boy teacher very much. Just contact operations have a lot of knowledge, if I publish the article has incorrect

I. Exporting a databaseMy MySQL installation directory is D:\Program files\mysql\mysql Server 5.5\bin\, the export file is expected to be placed in D:\sql\Execute command in MySQL installation directory: Mysqldump-hhostname-uusername-ppassword

LBS Spherical Distance formulaHttp://wiki.myoa.info/zh-blog:20java,mysql-500 meters of nearby locations based on a given latitude and longitude point-rational use of the algorithmRecently do a project: you need to query a site (known to the site

MySQL data types describe numeric types (integer type tinyint,smallint,mediumint,int,bigint; floating point decimal data type float and double, fixed-point decimal type Decimal), Date/Time type (year, Time,date,datetime,timestamp) and String types

Before describing Python's operations in the database, let's briefly introduce the operating language in MySQL:[[Email protected]2018- on- -]# Mysql-u Root-Penter Password:welcome to the MySQL Monitor. Commands End With; or \g.your MySQL

Mysql Innodb Lock Mechanism and mysqlinnodb Lock MechanismLatch and lock Latch can be considered as a lock in an application. It can be called a latch (lightweight lock) because it requires a very short lock time. If the lock lasts for a long time,

Mysql does not enter 0 implementation code on the current day according to the daily statistical report. mysql Statistical Report1. recurrence of the problem: Count the total number of days per day. If there is no data for a few days, the group by

MariaDB multi-instance and MariaDB instance1. Install MariaDB in yum and start yum install MariaDB-serversystemctl start mariadb.service  2. Create a directory by case and set the owner Group Store configuration files and databases by case mkdir -pv

Mysql learning day 3, mysql Day 3 1. add, delete, and modify data in the table (DML)Create table t_user (Id int primary key auto_increment,Name varchar (20) not null,Email varchar (20) unique) Add records to a table (required) Insert into table name

MySQL Checkpoint technology, mysqlcheckpoint   For personal reading notes, see MySQL technology insider Innodb Storage Engine   1. Background generated by checkpointWhen the database adds, deletes, queries, and modifies data, it is completed in the