MySQL session management

I. Summary:

Now, as Web networks continue to provide enterprises with an economical way to sell their goods and services, we will still see more Web-based applications. An internal feature of Web, and the most common technical problem that enterprises face when designing and maintaining their web infrastructure, it is a stateless interaction between the user's browser and the web server. This kind of stateless interaction may be good for randomly accessing pages or clicking hyperlinks. However, just like online banking and e-commerce, there are still many web applications that need to understand the interaction and current status of users on the website. Improper storage and access security authentication, or adding or deleting columns may be placed in a virtual shopping cart, which may cause disastrous consequences.

Like cookies we know, however, cookies are small plain text messages sent by Web servers to Web browsers and are stored in users' computers as text files, these cookies are generally used to save the user's access status. When the user accesses the same website again, the Cookie information will be sent back to the server, so that the server can restore the user's last access status. The fundamental purpose of using cookies is to achieve data transmission between different pages during user access, so as to solve the problem of HTTP stateless. Cookie technology can enhance the service functions of websites and bring convenience to users. However, there are still many restrictions and limitations on Cookie. In view of the limitations of Cookie technology, we propose the concept of Session and integrate the Session technology into the language. Session refers to all the information stored on the Web server during the user's access to the Web server that is related to the user's access status. Each newly created session has a unique identifier string called the session ID, which is saved on the Web server, other session information is saved and read under the index of the session ID. The duration of a session from creation to deletion is called the session lifetime. The duration of the session lifetime is determined by the session management mechanism. The difference between cookies and sessions is that cookies store user access status information in users' computers through Web browsers, and sessions are stored on Web Servers through session management mechanisms.

In this section, we will explore how MySQL and MySQL clusters use a cost-effective, high-performance, open-source data-centric session management solution.