Programmer Group

Catalog 1. Environmental planning 2. binlog is enabled for all Mysql to ensure that the server IDs of all MySQL are different 3. The master database authorizes the master-slave replication user 4. The main database makes the database data fully available, and then pushes the backup file to the slave database 5. Restore backup files from the d ...

Common replication sets The common architecture of online environment is replica set, which can be understood as one master and many slaves. Below: 1 master and 2 slave Below: one master one slave one arbitration Server information: Three machines are configured with 2-core 16G memory storage disk 100G "host" : "10.1.1.159:27020""host" : "1 ...

Description: According to the technical feedback, some people mistakenly deleted the online mongodb table data in the morning, the user has feedback to the customer service, now it is necessary to restore the data to the user. The first step is to determine the schema of the database for deleted data 1.1, Single point:If there is a backup, sta ...

Spring Cache defect Spring Cache is a very good cache component. But in the process of using Spring Cache, Xiao Hei also encountered some pain points. For example, now there is a requirement: obtain user information in batches through multiple userids. Option 1 At this point, our code may be as follows: List<User> users = ids.strea ...

Introduction to Portal.MVC The project is based on MVC4+EF, with the basic functions of role, authority, user center and account (login, registration, password modification, password retrieval, etc.). Open source projects for reference nopcommerce This is an MVC project of e-commerce architecture. I simplified it. Before that, it was ...

1. introduction When there is a large amount of data in a table, it is natural for us to think of splitting the table into many small tables. When we execute the query, we go to each small table to query. Finally, we summarize the data set and return it to the caller to speed up the query. For example, the order table and inventory table of e-c ...

[TOC] MySQL Create Capable Database Architecture Notes Database Monitoring Content to monitor Monitor the availability of a database: instead of just monitoring the existence of a database process, connect to the database over the network and determine if it is available Monitor database performance: QPS TPS, Number of concurrent threads, inn ...

Source code: GitHub point here || GitEE point here 1, Relational data source 1. Dynamic data source The basic functions of dynamic management data source: data source loading, container maintenance, persistent management. 2. Relational database Different manufacturers of relational databases provide different connection methods, driver packag ...

Recently completed a small Demo of curriculum, and the code has been uploaded to GitHub The completion mainly depends on the jar package tool jxl.jar Sample Excel file: Reading and analysis of Excel file public static void readXLS(final File file, Context context) { final StringBuilder sb = new Strin ...

1, SELECT clause /* Basic query: select * from Table name [where condition]; select Field list from table name [where condition]; Extended query, 5 clauses of select statement: (1)where where Condition is used to filter out the qualified records (rows) from the table (2)group by (3)having (4)order by (5)limit These five clauses can appea ...