CoderInOne

值得一读：

https://www.linode.com/docs/web-servers/nginx/how-to-configure-nginx/

2. nginx配置模板 https://www.nginx.com/resources/wiki/start/

3. Even Miller的模块教程（长期更新） https://www.evanmiller.org/nginx-modules-guide.html

CoderInOne

Syntax	Description	Example
^~	prefix match	location ^~ /1.0/login/
Paragraph	Text	And more

CoderInOne

项目地址 文档

1. 监控配置

CoderInOne

1. 安装

不要轻易听信任何一篇所谓安装教程。方法google mariadb install。 https://mariadb.com/kb/en/library/getting-installing-and-upgrading-mariadb/

2. 创建用户

• 用户管理：select * from mysql.user;注意用户表主键(host, user)，host表示用户的ip所在
• 用户管理条件：glorbal privileges#create user + insert privilege of mysql
• 用户规则: 'username'@'hostname'，见https://dev.mysql.com/doc/refman/5.7/en/account-names.html

CoderInOne

process control

https://stackoverflow.com/questions/44192418/how-to-find-mysql-process-list-and-to-kill-those-processes/44192419

CoderInOne

https://start.spring.io/

CoderInOne

• 下载依赖：mvn dependency:sources
• 解析依赖：mvn dependency:tree

CoderInOne

https://stackoverflow.com/questions/2619598/differences-between-dependencymanagement-and-dependencies-in-maven

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>

        <dependency>

CoderInOne

@Configuration
@EnableTransactionManagement
@Component
public class Committer {
	// define data source
	private final DataSource ds = DataSourceBuilder
			.create()
			.username("root")
			.password("123456")
			.url("jdbc:mysql://localhost:3306/test")

CoderInOne

import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.transaction.TransactionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.transaction.SpringManagedTransactionFactory;
import org.springframework.core.io.Resource;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.core.io.support.ResourcePatternResolver;

import javax.sql.DataSource;