Programmer Group

  The function of master-slave replication: Data distribution Load Balancing (Read) Backup High Availability and Fault Switching MySQL Upgrade Test The way of master-slave replication: Master-slave duplication Mutual dominance and subordinate replication Semi-synchronous replication   P ...

Author: Gao Peng At the end of the article is his book "Deep Understanding of MySQL Master-slave Principle 32 Lecture". Deep and thorough understanding of MySQL Master-slave, GTID related technical knowledge. This article is excerpted from Section 29 of Understanding MySQL Principles of Master and Subordinate Note: This article is ...

Superset is an incubator project of apache, positioned as a modern, quasi-commercial BI system superset Apache Superset (incubating) is a modern, enterprise-ready business intelligence web application Superset is an incubation project of apache, positioned as a modern, quasi-commercial BI system. Superset (Caravel) is an open source data anal ...

Background: Before the Mid-Autumn Festival, I tried to build a node environment. I ran a little. After returning, I began to write, add, delete and check with node. But our company encapsulated a lot of things. I am also the caller. Perhaps the directory structure of each company is different. I will talk about our company here. First, I will i ...

After mysql 5.7, the processing of group by is different. Here we do some research based on a demo. Official documents: https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by   demand Statistical user login times, display user Id and name, as follows ...

Recently on the project, customers asked me to help see a view with slow queries, provided that they had optimized it internally before giving it to me. When I saw their optimization, they simply used hint statements, and it didn't work. First of all ...

install $ npm install --save sequelize # You also need to install one of the following: $ npm install --save pg pg-hstore // postgreSql $ npm install --save mysql // mysql or mariadb $ npm install --save sqlite3 $ npm install --save tedious // MSSQL Establish connection const Sequelize = require('sequelize') const sequelize = new Sequelize(d ...

This article only describes IP, virtual IP and scan changes in the same segment of the public network, and will introduce IP changes in different segments later. The experimental environment: 1. Stop RAC Cluster Services Cluster services are stopped at two nodes: [root@odb09 ~]# /u01/app/11.2.0/grid/bin/crsctl stop cluster -all [root@odb09 ~] ...

java web development process - tomcat 1. Setting up servers server (tomcat) Operational steps: servers - > New - > server - > Apache - > Tomcat 7.0 - > next - > Tomcat Install Location - > Borwse (select the location of tom ...

Original Link: https://my.oschina.net/u/1772925/blog/600871 Using the MySQL database, you first install the MySQL database, and all the SQL scripts in this article are tested and execu ...