Mybatis custom TypeHandler solves special type conversion problems

We know that the data types in Java and MySQL are different. In addition to the basic data types, there are also objects in Java. Sometimes when using MySQL to store data or read data from MySQL, there are some special requirements, such as: The Integer array is directly stored in MySQL and saved in the form of BLOB. When it is read out, it is ...

Posted on Thu, 14 Nov 2019 04:05:41 -0800 by ShadowX

tornado connecting to database

ORM Object Relational Mapping (ORM, or O/RM, or O/R mapping for short) is a kind of program technology, which is used to realize the conversion of data between different types of systems in object-oriented programming language. In effect, it creates a virtual object database which can be used in programming language. Through OR ...

Posted on Tue, 12 Nov 2019 12:15:59 -0800 by ianr

Technology sharing | MySQL: timestamp time zone conversion leads to high CPU% sys

Author: Gao PengAt the end of the article, there is his book "in-depth understanding of MySQL master-slave principle 32", in-depth understanding of MySQL master-slave, GTID related technical knowledge. This is a learning record. Please understand if there is any mistake. This problem is a friend's @ situation, and this friend has rea ...

Posted on Tue, 12 Nov 2019 02:13:42 -0800 by imnsi

haproxy experiment exercise

Small website structure Note: if you deploy on the cloud, such as Alibaba cloud, you don't need to deploy keepalived yourself. Just buy the slb of Alibaba cloud, and then distribute the traffic to two haproxy machines First, deploy two web servers Compile and install nginx (script is rough) [root@007-web2 ~]# cat nginx.sh  yum install -y vi ...

Posted on Tue, 12 Nov 2019 02:11:28 -0800 by ioop

Technology sharing | MySQL: timestamp time zone conversion leads to high CPU% sy

Author: Gao Peng At the end of the article, there is his book "in-depth understanding of MySQL master-slave principle 32", in-depth understanding of MySQL master-slave, GTID related technical knowledge. This is a learning record. Please understand if there is any mistake. This problem was encountered by a friend @ Fengyun , and thi ...

Posted on Tue, 12 Nov 2019 02:01:45 -0800 by mars16

Using Spring AbstractRoutingDataSource to manage multiple data sources

1. Principle of multi data switching: the core of multi data source dynamic switching is that the bottom layer of spring provides AbstractRoutingDataSource class for data source routing. We mainly inherit this class and implement the methods in it. The main implementation method is: determineCurrentLookupKey(), which only needs to return the ...

Posted on Sun, 10 Nov 2019 09:02:12 -0800 by gauravupadhyaya

Using official template to monitor mysql database on windows on ZABBIX ZABBIX

Starting from zabbix 3.4, zabbix has its own monitoring template for mysql, which is convenient for direct monitoring of mysql database on linux without any configuration. However, m is required for mysql database on windows, which cannot be directly monitored. After continuous inquiry, the monitoring method has been found, refer to https://bl ...

Posted on Sat, 09 Nov 2019 08:20:42 -0800 by babygodzilla

Spring Boot integrating Spring Data JPA introduction 01

Spring Data JPA: Introduction: Spring Data is the framework that spring provides operation database, and Spring Data JPA is just a module based on JPA standard operation database under Spring Data framework. Spring Data JPA: operate on data based on JPA standard. Simplify the code of persistence layer, only need to wri ...

Posted on Fri, 08 Nov 2019 08:39:05 -0800 by theeper

MySQL containerization detailed tutorial

Preface: The previous article introduced the installation of Docker tool and the use of common commands. In this article, we will introduce how to run MySQL instance in Docker. Some small partners may ask: why run MySQL in Docker? Because it is easy to deploy MySQL instance in Docker, it does not need to consider the dependency differences such ...

Posted on Thu, 07 Nov 2019 22:15:09 -0800 by syacoub

Spring Boot 2 Series Tutorial Spring Boot Integrates JdbcTemplate Multiple Data Sources

Multiple data source configuration is also a common development requirement. There are solutions for this in Spring and SpringBoot, but generally, if there is a need for multiple data sources, I would recommend that you prefer the distributed database middleware MyCat to solve the problem. A small partner asked questions on my knowledge planet ...

Posted on Thu, 07 Nov 2019 19:13:55 -0800 by LinuxForce