MySQL master-slave replication (operation and maintenance technology exchange group: 926402931, welcome to exchange together.)

Catalog 1. Environmental planning 2. binlog is enabled for all Mysql to ensure that the server IDs of all MySQL are different 3. The master database authorizes the master-slave replication user 4. The main database makes the database data fully available, and then pushes the backup file to the slave database 5. Restore backup files from the d ...

Posted by dwees on Fri, 10 Apr 2020 16:56:28 +0200

Analysis of distributed heartbeat detection module of DBLE

Author: Lu Lu Those who love technology and are willing to share are mainly engaged in the research of database related technology. Source: original contribution *Aikesheng is produced by the open source community. The original content cannot be used without authorization. Please contact the editor for reprint and indicate the source. Summ ...

Posted by SystemOverload on Wed, 08 Apr 2020 11:24:57 +0200

Analysis of the actual operation of the database SQL of Niuke network (1-10)

1. Find all information about the latest employee CREATE TABLE `employees` ( `emp_no` int(11) NOT NULL, `birth_date` date NOT NULL, `first_name` varchar(14) NOT NULL, `last_name` varchar(16) NOT NULL, `gender` char(1) NOT NULL, `hire_date` date NOT NULL, PRIMARY KEY (`emp_no`)); Solution: sort order by... Desc according to the entry time in re ...

Posted by Soumen on Tue, 07 Apr 2020 15:46:24 +0200

sql automatic inspection and analysis tools: soar and soar web installation and use experience

In order to study whether sql automatic inspection and analysis tools are easy to use, I install and use soar and soar web locally. The preliminary experimental results are summarized as follows: 1. The installation is relatively cumbersome, especially the installation of dependency package of soar web, which involves the download and installat ...

Posted by ICEcoffee on Mon, 06 Apr 2020 03:09:13 +0200

[Seata microservice distributed transaction] 1. Seata server environment construction

Seata serve installation package Download the Seata Server package, all I have is version 0.9.0 https://github.com/seata/seata/releases wget https://github.com/seata/seata/releases/download/v0.9.0/seata-server-0.9.0.tar.gz Link: https://pan.baidu.com/s/1jlBwCEYM3hn7zQiSpwRijg password: 56vm After 0.9.0 of the official website, there is no ...

Posted by davespring on Mon, 06 Apr 2020 02:29:27 +0200

Recommend 4 MySQL tuning tools, which are used by Daniel!

Author: Lao Wang Tan operation and maintenancehttps://www.toutiao.com/a6691523026984370699/ What is the performance of mysql running? Is the parameter setting reasonable? Is there any hidden danger in the account setting? As the saying goes, if you want to be good at something, you must first make use of the device. Regular physical examinati ...

Posted by rachel2004 on Sun, 05 Apr 2020 11:34:14 +0200

JDBC basic CRUD and calling stored procedure of [add, delete, modify and query]

Preface CRUD operation on database has a certain history ① JDBC - > ② dbutils - > ③ jdbctemplate - > ④ - > hibernate - > ⑤ mybatis - > ⑥ JPA+SpringData So many dao layers are used to realize their own advantages and disadvantages, and to seek the best dao scheme of the project. But the framework will work, ...

Posted by MBK on Sat, 04 Apr 2020 19:25:28 +0200

MySQL read write separation + sub database and sub table - Mycat

Demand: The user instance SERV is divided into different databases according to the org? ID Agreement: Beijing (ORG UU id = 101), Shanghai (ORG UU id = 102), Shenzhen (ORG UU id = 103), Chongqing (ORG UU id = 104), Sichuan (ORG UU id = 105) Beijing bjdb, Shanghai shdb, Shenzhen szdb and Chongqing cqdb are built on dn10 and dn11 Sichuan scd ...

Posted by DragonHighLord on Sat, 04 Apr 2020 02:55:03 +0200

Zabbix monitoring Server database

Monitoring mysql service on zabbix server 1. Configure mysql In the / etc / zabbix / zabbix ﹣ agent D. D / userparameter ﹣ mysql.conf file, it is specified how zabbix agent obtains various information of MySQL service, and a new ". my.cnf" file is created in the / var/lib/zabbix directory to specify how zabbix age ...

Posted by jesirose on Sat, 04 Apr 2020 02:21:49 +0200

MySQL forget root password solution

Now the mysql database we use is divided into two versions, one is mysql and the other is mariadb. There are some differences between the two versions of the solution, which I will explain below. First step First, we need to turn on my.cnf vim /etc/my.cnf Add skip grant tables under [mysqld], then save and exit ...

Posted by rejoice on Sat, 04 Apr 2020 00:08:14 +0200