[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

mssql auto partition

Details of mysql automatic partition Why auto partition: because there are more than one million pieces of data in a table, and the query speed is very slow, the auto partition function is added to improve the query ability. First, define the steps of partition: New backup table Delete new table partition Swap partition Del ...

Posted by largo on Fri, 03 Apr 2020 19:06:14 +0200

mysql multiple instance mode (1) --- multiple configuration files

For the convenience of not starting from scratch, experiment directly on the existing database system, omit to install the database software (the method is similar), the following is an example of adding an instance essential information: [root@localhost ~]# cat /etc/issue CentOS release 6.5 (Final) mysql> \s ...

Posted by oughost on Fri, 03 Apr 2020 03:15:02 +0200

MySQL common operations (2) user management, common statements, database backup and recovery

1. mysql user management In daily use, it is necessary to limit the permissions of personnel, so it is necessary to manage users. ##Create users and authorize Specify login IP [root@host ~]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. mysql> grant all on *.* to 'user1'@'127.0.0.1' identified by '123456'; #Create user1 us ...

Posted by pucker22 on Wed, 01 Apr 2020 20:18:42 +0200

vue+node+mySql to separate front and back end

Environment building Install node first: http://nodejs.cn/download/ Download and install it directly! The new version does not need to manually configure the environment. After installation, open cmd and input node-v and npm-v to check whether the installation is successful. The second step is to install vue: T ...

Posted by Concat on Wed, 01 Apr 2020 13:05:01 +0200