Gourd baby eating gourd

MySQL directory structure In order to save the table structure, InnoDB and MyISAM create a file to describe the table structure in the corresponding database subdirectory under the data directory. The file name is as follows: InnoDB 5.7. opt Database structure.frm Table structure.ibd Table data storage default storage location (independent tablespace) One of ibdata1 Table data storage locations (system tablespace) InnoDB 8.0. ibd table structure is integrated with table data, and exists in this file without. opt MyISAM 5.7. frm table structure MYD table data MYI stores indexes MyISAM 8.0. sdi table structure (. frm renamed)

The predecessor of Mycat is Alibaba's famous Cobar. After a period of open source, Cobar has no longer been maintained. Alibaba gave up the project. In addition, some problems were found in the use of Cobar. In 2013, a group of domestic open source software enthusiasts improved the Cobar project and named it Mycat, which is the birth of MyCat. MyCat is completely free and open source and does not belong to any commercial company. Authoritative Guide: https://www.yuque.com/books/share/0576de75-ffc4-4c34-8586-952ae4636944 Mycat is an open source database middleware. It is a database middleware server that implements the MySQL protocol. We can regard it as a database agent. We can use MySQL client tools and command lines to access Mycat. Mycat can use MySQL native protocol to communicate with multiple MySQL servers, or JDBC protocol to communicate with most mainstream database servers, It includes mainstream databases such as SQL Server, Oracle, DB2, PostgreSQL, and supports MongoDB, a new NoSQL storage mode. It will also support more types of storage in the future; Generally, Mycat is mainly used to proxy MySQL databases, although it also supports

Briefing the access security of programs has always been an important part of development. There are two commonly used security frameworks in the Java EE open source world: Apache Shiro and Spring Security. The former is simple in structure and easy to use, while the latter is complex in structure and powerful in function. Over the years, each has a large number of supporters. Shiro can easily develop good enough applications, which can be used not only in the Java SE environment, but also in the Java EE environment. Shiro can help us complete: authentication, authorization, encryption, session management, integration with the Web, caching, etc. Shiro's API is also very simple. The four core functions are Authentication, Authorization, Session Management and Cryptography. Authentication: identity authentication/login to verify whether the user has the corresponding identity; Authorization: authorization, that is, permission verification, to verify whether an authenticated user has a certain permission; That is, to judge whether a user can do something. A common example is to verify whether a user has a role. Or fine-grained verification of whether a user has a certain permission on a resource; Session Manager: session management, that is, after the user logs in, it is a session. Before exiting, all its information is in the session

Overview of microservices The entire microservice architecture consists of a large number of technical frameworks and solutions, such as: Service basic development Spring MVC、Spring、SpringBoot Service Registration and Discovery Netflix Eureka, Apache ZooKeeper, etc Service call RPC calls include Alibaba Dubbo, Rest calls include Dubbox, which is an extension of Dangdang Dubbo, and Rest implemented in other ways, such as Ribbon and Feign Distributed configuration management Baidu's Disconf, 360's QConf, Taobao's Diamond, Netflix's Archaius, etc load balancing Ribbon Service fusing Hystrix API gateway Zuul Batch task Dangdang's Elastic Job, Linkedln's Azkaban Service tracking Hydra of JD, Zipkin of Twitter, etc The emergence of Spring Cloud can be said to usher in a ray of light for the microservice architecture. With the huge support and technical support of the Spring Cloud community, the implementation of microservice architecture has become extremely simple. Unlike the frameworks we listed earlier, it is just a solution to a problem in microservice, but a comprehensive solution to the implementation of microservice architecture

One of the message queues

The configuration file is the most popular

Convention is better than configuration

Common knowledge about NoSQL and Redis

Some configurations have been replaced by spring boot, and the first record is the first record...

Who still uses jsp now...