squid forward and reverse proxy and balanced polling

squid forward agent Principle: a machine that can't access the Internet can access the website that can't be accessed through the agent Here I use my real machine as an agent. The virtual machine accesses the website through the agent Operating System: Red Hat Enterprise Linux Server 7.2 (Maipo) squid installation a ...

Posted by katuki on Wed, 15 Apr 2020 16:35:33 +0200

Nginx balanced TCP protocol server case

  After version 1.9, nginx can act as a port forwarding function, that is, to access the specified port of the server, nginx can act as a port forwarding function to direct traffic to another server, and obtain the return data of the target server and return it to the requester. The function of nginx's TCP proxy is different from that ...

Posted by dflow on Wed, 15 Apr 2020 12:04:12 +0200

Getting started with Go Mysql and Redis

Mysql and Redis operations Mysql development Install mysql and create test library Create table mysql> CREATE TABLE `user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT '', `age` int(11) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4; mysql> insert into user (name,age)va ...

Posted by programguru on Sat, 11 Apr 2020 16:17:34 +0200

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