How to collect MySQL MHA deployment and running status information through Python

1, Background introduction When the number of MySQL database instances of the group reaches 2000 + and the scale of MHA cluster reaches hundreds, the timely and efficient management of MHA is a challenge that DBA s must face. MHA cluster node information and operation status are the basis of management. This section mainly introduces how to col ...

Posted by jmcc on Sun, 03 Oct 2021 02:20:59 +0200

Build Discuz forum based on LAMP Architecture -- Linux, Apache, Mysql, PHP, Discuz

catalogue preface 1, LAMP overview 1. LAMP platform overview 2. Build LAMP platform sequence 3. Advantages of compilation and installation 4. Main functions of each component 2, Compile and install Apache httpd service   1. Close the firewall and transfer the software packages required to install Apache to the / opt directory 2. I ...

Posted by kbc1 on Sat, 02 Oct 2021 20:41:07 +0200

Alibaba cloud Linux server deployment docker project complete tutorial (springboot+mysql)

Install Docker Install Docker Compose (this is required for the operation of a complete project) This document mainly records the process of learning to deploy Docker. The article is followed by the deployment of open source projects based on Docker and Docker Compose. It's never too old to learn, keep an empty cup mentality, learn knowledg ...

Posted by Eskimo on Sat, 02 Oct 2021 03:54:05 +0200

MySQL SQL optimization explain analysis

explain analysis execution plan You can use the EXPLAIN or DESC command to obtain information about how MySQL executes the SELECT statement, including how tables are connected and the order of connection during the execution of the SELECT statement. Execution plan of query SQL statement: explain select * from tb_item where id = 1;   ...

Posted by xtian on Fri, 01 Oct 2021 20:48:40 +0200

MYSQL transactions

mysql transaction In MySQL, transaction is actually the smallest and indivisible unit of work. Transactions can ensure the integrity of a business. Such as bank transfer a-> -100 update user set money = money-100 where name'a'; b-> +100 updata user set money=money +100 where name='b'; In the actual program. If only one ...

Posted by newbiehacker on Sat, 25 Sep 2021 06:25:24 +0200

Menu management list data presentation (PROJECT03_DAY01_01)

3. Menu management list data presentation 3.1 data architecture analysis After loading the menu list page, start the asynchronous loading operation of menu data. This menu list page should present the menu and superior menu information. During data query, the data encapsulation and transmission process is shown in figure-8. Figure-8 Note: Th ...

Posted by cybercog on Fri, 24 Sep 2021 12:50:58 +0200

Use the Canal ClientAdapter to synchronize the DDL and DML of Mysql to PostgreSQL

1. Description The description of each component is shown in the table below: assemblyeditionThe serverInstallation tutorialeffectcanal1.1.5canal1, canal2, canal3canal HA installation + mysql multi node automatic switchingzookeeper3.6.3canal1, canal2, canal3zookeeper fully distributed installationmysql8.0.25canal1, canal2MySQL master mast ...

Posted by jalperin on Fri, 24 Sep 2021 00:36:17 +0200

In September, datawhale teamed up to learn the advanced operation of task05SQL

In September, datawhale teamed up to learn task05 advanced SQL operations 1, Window function 1. Concept, basic usage Window function (OLAP function) Online AnalyticalProcessingReal time analysis and processing of database Window function allows us to selectively summarize, calculate and sort some data Conventional SELECT statemen ...

Posted by KenGR on Thu, 23 Sep 2021 16:51:52 +0200

ShardingSphere actual combat: SpringBoot integrates sharding JDBC to realize sub database and sub table

preface Teach you how to use sharding JDBC to realize the database sub database and sub table. 1, Concept Sub database and sub table Database and table splitting is a reasonable splitting of databases and tables when the amount of data is large to a certain extent. Take MySQL as an example: it is recommended that the maximum amount ...

Posted by sbroad on Thu, 23 Sep 2021 15:15:51 +0200

SpringBoot and data access (JPA and Mybatis)

part 1 ORM framework ORM (Object-Relational Mapping) The emergence of ORM framework is essentially to simplify the coding of database operations in the programming process. Now this ORM framework can be basically divided into two categories. First, the representative of fully automatic ORM framework is -- > hibernate claims that you don't n ...

Posted by BuzzPHP on Tue, 21 Sep 2021 06:38:50 +0200