Development Process and software selection at various layers

The following is the final conclusion. The reason is not detailed.

 

1. Requirements

After understanding the user's needs, sort the functional requirements according to the user's classification and use the process classification to form a word. And report to the project team for discussion. After the application is approved, you can proceed to the next step.

 

2. Database Design:

To use powerdesiner or similar database design tools, you must design the database before any web project is launched, and report it to the project team for discussion before you can proceed to the next step.

 

3. Interface Design:

Use the prototype tool or HTML to design the prototype, and then report it to the project team for discussion. After the application is approved, you can proceed to the next step.

 

4. Development Framework

The spring + srping MVC + jdbctemplate framework of the project team is used in a unified manner. Other frameworks cannot be used for development in new projects, except for maintenance of old projects.

 

5. Code Generation

After the database is designed, use the codesmith template provided by the project team to automatically generate key code templates.

 

6. Database

MySQL 5.6 or later is selected. Currently, no other MySQL database variants are used, or PostgreSQL is not used. The InnoDB engine is required and the MyISAM engine is not allowed. The binary log and slow query log must be enabled for the production database.

 

7. Data Cache

Use the AOP-based data memcached cache technology provided by the project team in a unified manner. It must be updated in real time and cannot be used as a cache (that is, the database is updated and cannot be displayed on the interface in a timely manner ).

 

8. Database Connection Pool

Use the open-source druid to connect to the database. Other SQL statements, such as DBCP or c3p0, are not allowed. Optimize the SQL statements with high efficiency in Druid.

 

9. SQL statements

In principle, complex queries are not allowed. You must have an index in the where condition of the query, or use a primary key to query the query. If you need to perform a joint query, the query frequency, for example, is large, redundant fields must be added to avoid joint queries.

We recommend that you do not enter inner join, left join, right join, or subquery. Do not show group

 

10. Operating System

Select centos x64 6.4

 

11. Web window

Select Tomcat 7x64

 

12. Server Load balancer

Tengine is used when there are few servers (less than four servers) and haproxy is used when there are multiple servers