Session management for MySQL

First, Summary:

Today, as Web networks continue to provide businesses with an economic way to sell their goods and services, we will see more investment in web-based applications. An internal feature of the Web, and one of the most common technical problems that enterprises face when we design and maintain its web infrastructure is a stateless interaction between the user's browser and the Web server. This stateless interaction may be great for random access to a page or for clicking on hyperlinks, however, like online banking and E-commerce, there are many Web applications that need to understand the interaction and current status of users on a site. The inability to properly store and access security authentication, or the addition and deletion of columns that may be placed in virtual shopping carts, can have disastrous consequences.

Like the cookie we know, however, cookies are small, plain text information that the Web server sends to a Web browser and is stored in a text file on the user's computer, which is typically used to hold the user's access state. When a user accesses the same Web site again, the cookie information is sent back to the server, allowing the server to restore the user's last access status. The fundamental purpose of using cookies is to implement data transfer between different pages during user access to resolve HTTP stateless issues. Cookie technology can enhance the service function of the website, bring convenience to the user. However, there are many limitations and deficiencies in cookies, the concept of session is proposed and the session technology is integrated into the language for the limitations of cookie technology. A session is any information about the user's access state that resides on the Web server during a user's access to the Web server. Each newly created session has a unique identity string called the session ID, the session ID is saved in the Web server, and 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 a session lifetime, and the length of the session lifetime is determined by the session management mechanism. Cookies are different in that the cookie places the user's access status information in a Web browser on the user's computer, and the session is stored in the Web server 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.