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
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.
Posted by SystemOverload on Wed, 08 Apr 2020 11:24:57 +0200
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
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 serve installation package
Download the Seata Server package, all I have is version 0.9.0
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
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
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
The user instance SERV is divided into different databases according to the org? ID
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
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
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, we need to turn on my.cnf
Add skip grant tables under [mysqld], then save and exit
Posted by rejoice on Sat, 04 Apr 2020 00:08:14 +0200