Programmer Group

MySQL + maintained dual active hot standby highly available operation records Environmental Science: ubuntu18.04.2 mysql5.7.21 1 #1)install keepalived And configure it as a system service. master1 and master2 The following operations are also performed on both machines: 2 apt-get install libssl-dev 3 apt-get install openssl 4 apt-g ...

Because of the work requirements, a large amount of data needs to be inserted into ORACLE data, and then the manual management of transaction opening is selected to insert a large amount of data. However, a pit is encountered here. Before the transaction management of mysql was opened to insert data, copying mysql is a bit impractical. Only 299 ...

BLOB and CLOB are both large field types. BLOB is stored by binary, while CLOB can store text directly. Usually, information such as pictures, files, music and so on are stored in BLOB fields. First, the files are converted to binary and then stored in. Articles or longer text are stored in CLOB. The corresponding types of BLOB and CLOB in ...

mysql5.6 install Here, the pre compiled binary is used for installation and deployment. Compared with the compiled installation, it does not need to be compiled, but can be used after the initialization of my.cnf is modified directly. It is recommended to use this method in the production environment. Download FileDomestic image source downlo ...

Introduction: In this tutorial, you will learn how to use MySQL JSON data types and store JSON documents in databases. Introduction to MySQL JSON data types Starting with version 5.7.8, MySQL supports native JSON data types. The local JSON data type enables you to store JSON documents more efficiently than the JSON text format in previous versi ...

What is heterogeneous data processing? Simply put, in order to satisfy the expansion of our business, data is transformed from a specific format to a new data format. Why does this need arise? In traditional enterprises, data are mainly stored in relational databases, such as MySQL, but in order to meet the expansion of demand, the dimension ...

< font color = Red > No reprinting, no handling </font > Problems encountered: First, the browser can not open blog.jd.com: DNS has been configured, the ultimate reason: this graphical CentOS7 uses dncp to obtain ip, DNS also access the gateway; Solution: Fixed IP, set DNS manually, and confirm / etc/reslov.conf Two, NFS permissi ...

This paper uses Sharding-JDBC to realize read-write separation based on entOS 7 + MySQL 5.7 I. MySQL Installation and Configuration 1.1 installation Execute orders in turn: sudo wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm sudo yum -y install mysql57-community-release-el7-10.noarch.rpm sudo yum ...

How Kubernetes manages storage resources. First we will learn about Volume and how Kubernetes provides storage for containers in clusters through Volume; then we will practice several commonly used Volume types and understand their respective application scenarios; finally, we will discuss how Kubernetes separates cluster administrators from c ...

Preface For the application scenario of "nearby people" in the field of location-based services, many spatial indexes such as PG, MySQL and Mongo DB can be used to implement it. Redis, which combines its ordered queue zset and geohash coding, achieves the function of spatial search and has a very high operational efficiency. This pap ...