MySQL

lepus3.8-Day Rabbit MySQL Database monitoring System build original ixhao2016-08-24 02:36:23 Comments (11) 3183 people read lepus3.8-MySQL database monitoring system build Lepus is an open-source database monitoring software, Detailed monitoring of

I. MySQL database introduction 1, Database basic knowledge MySQL is an open-source relational database management system (RDBMS) that uses the most common database management language – Structured Query Language (SQL) for database

MySQL master-slave replication architecture and implementation Miscellaneous 1, set slave node as read-only modeMariaDB [(None)]> SHOW GLOBAL VARIABLES like ' read_only '; +---------------+-------+| variable_name | Value |+---------------+-------+|

This method is available for unknown database password or initial login:If you change the password, you should stop the MySQL service first.Systemctl Stop Mysqld1 Modify the configuration file, skip the password to enter the

keepalived + haproxy + MySQL build high availability1, the high availability of keepalived is the main preparation, there is a standby2, keepalived + haproxy built high-availability is can be scheduled for two high-availabilityTopology

Preliminary incremental recovery of MySQL data A. Configuring the MY.CNF configuration fileRename the Log-bin parameter in the MY.CNF configuration file to MYSQLBIN_ZBF first, so that updating a thing in the MySQL database will be updated in this

Recently, due to the need for work, we began to focus on the relative optimization of select query statements for MySQL databases.Because of the actual project involved, it is found that when the data volume of MySQL table reaches millions, the

Day05I. Data backup and recovery-incremental and incremental recoveryA.binlog Log description (binary file): one of the types of log files used by the MySQL database service. Logs a SQL command other than a query. Not enabled by defaultQueries for

1. Download the installation packagehttp://Find the following downloadMYSQL-5.7.21-1-MACOS10.13-X86_64.DMG isHTTPS://cdn.mysql.com//DOWNLOADS/MYSQL-5.7/MYSQL-5.7.21-1-MACOS10.13-X86_64.DMG 2. After downloading, follow the prompts to installFollow

What is a tableA table is a structured file that can be used to store data of a particular type. A record in the table has a corresponding caption, which is called a table field.　　Two Create a table 12345 CREATE TABLE 表名(字段名1类型[(

Objective:when we do When testing an API test,Web Service, or other system module, you may need to obtain and record data from the database. The purpose of these tests is to examine the data specified in the database, or to add the specified data to

I. Overview　　Databases (database, abbreviated DB)Database technology is a very important technology in the field of computer application, it is produced in the the late 1960s, it is the newest technology of data management and also an important

The contents of this section passI. Introduction of the database 1. What is a database?A database is a warehouse that organizes, stores, and manages data according to its structure, and each database has one or more different APIs (application

One: Download navicat for MySQLGo to Navicat for MySQL download, select the downloaded version as needed, I choose Windows 64bit, choose one of the image address download.　　　　　　Two: Install Navicat for MySQLRun → next → Click "I agree" → Select the

Vertical Sub-table technologyVertical segmentation refers to: The table is not a lot of records, but the field is very long, the table occupies a large amount of space, when retrieving the table need to execute a large number of IO, severely reduce

MySQL Performance tuningImprove the performance and impact speed of your MySQL system-Replacement hardware (cpu/disk/memory, etc.)-Operating parameter adjustment of the service program-Optimization of SQL queriesConcurrency and connection

In CentOS 7, MariaDB source code package is compiled and installed, and centosmariadb Download the installation package Download the MariaDB 10.2 stable version source code package from the official website. Select source code package After you

Common commands for mysql to authorize, start, and start servicesOne or four startup methods: 1. mysqld Start the mysql server :. /mysqld -- defaults-file =/etc/my. cnf -- user = root client connection: mysql -- defaults-file =/etc/my. cnf or

MySQL cannot start or restart because the Linux host name and mysql host name have been changed. MySQL cannot be restarted, shut down, started, or used. If you modify the host name, you can disable all mysql processes and start some mysql processes!

Windows 10 mysql 5.7.21 winx64 installation and configuration methods graphic tutorial, 5.7.21winx64 Mysql 5.7.21 winx64 installation and configuration method: Download Community version mysql (register an oracle account before downloading)