MySQL master-slave replication and read-write separation

1, Deployment reasons reason: Ensure that the data of the master database and the slave database are always, and prevent single point of failure and data lossIn enterprise applications, mature businesses usually have a large amount of dataA single MySQL cannot meet the actual needs in terms of security, high availability and high concurre ...

Posted by bbristow on Thu, 28 Apr 2022 20:50:46 +0300

(the most complete SQL statement, without one!) Explain SQL statement syntax in detail according to classification

catalogue 1, Foundation 1. Description: create database 2. Description: delete database 4. Description: create a new table 5. Create a new table based on the existing table: 6. Description: add a column 7. Description: add primary key: 8. Index creation Description: 9. Description: create view: 10. Several basic sql statements 11. De ...

Posted by fatherlyons on Thu, 28 Apr 2022 09:06:55 +0300

OpenSUSE installation of PostGIS 3 (Postgresql 13)

catalogue1. Get PostGIS software source2. Install PostGIS software3. Configure PostGIS software4. Start the PostGIS service 1. Get PostGIS software source Directly to https://software.opensuse.org/explor Website, select the corresponding distribution, search postgis, and then find the version to be installed in the search results to view releva ...

Posted by tomsasse on Thu, 28 Apr 2022 03:46:16 +0300

ElasticSearch core concepts and basic operations

1, Core concept 1.1 Elasticsearch is document oriented, relational database, and comparison with Elasticsearch Elasticsearch file storage. Elasticsearch is a document oriented database. A piece of data is a document here, and JSON is used as the format of document serialization relational databasedatabasesurfacethat 's okColumnsElasticsearch ...

Posted by Braclayrab on Wed, 27 Apr 2022 16:36:36 +0300

redis6.0.9 build master-slave copy and sentinel mode

1, Master-slave replication and its principle concept Master-Slave replication refers to copying data from one redis server to other redis servers. The former is called master/leader and the latter is called slave/follower; Data replication is unidirectional and can only be from master node to Slave node,. Mater is mainly written and Slave is ...

Posted by carnot on Wed, 27 Apr 2022 09:08:43 +0300

Chapter 124 SQL function SECOND

Chapter 124 SQL function SECOND A time function that returns the number of seconds of a datetime expression. outline {fn SECOND(time-expression)} parameter Time expression - an expression that is a column name, the result of another scalar function, or a string or numeric literal. It must resolve to a TimeStamp string or a $HOROLOG st ...

Posted by markyoung1984 on Wed, 27 Apr 2022 04:40:43 +0300

High availability of database: failover based on master-slave replication

Now let's introduce the construction of high availability architecture of MHA database. First, let's introduce the steps of installing MHA node node on the machine where the three databases are located. First, perl language environment must be installed first. This is the same as normal Java development. JDK must be installed first! So you can ...

Posted by nogeekyet on Tue, 26 Apr 2022 08:36:51 +0300

MySQL index, transaction and storage engine

1, Concept of index ● index is a sorted list in which the index value and the physical address of the row containing the data of this value are stored (similar to the linked list of C language, pointing to the memory address of the data record through a pointer). ● after using the index, you can not scan the whole table to locate the data ...

Posted by Sirus121 on Tue, 26 Apr 2022 02:55:33 +0300

Deploying Mysql 8.0 database in Kubernetes (single node)

System environment: Mysql version: 8.0.19 Kubernetes version: 1.17.4 Operating system version: CentOS 7.8 1, Introduction Mysql is a commonly used relational database. It is often necessary to deploy a set of Mysql for data storage when the project is developed, tested and deployed to the generation environment. Here's how to deploy Mysql ...

Posted by itsjames on Tue, 26 Apr 2022 00:25:10 +0300

mybatis initial simple configuration (XML)

Steps to apply mybatis: Introduction to mybatis Dependent configuration. Operation: 1. Create a new entity class. The attributes in the class correspond to those in the database 2. Create a new dao interface and write the methods you need (for example, return all list sets). 3. Create a new XML file named sqlmapconfig in resource XML (main ...

Posted by horsleyaa on Mon, 25 Apr 2022 22:34:44 +0300