Message push method and system based on MQTT and MYSQL

Abstract

The invention discloses a message push method and system based on MQTT and MYSQL. The method comprises the following steps: a server establishes a communication connection with a client based on an MQTT protocol; the server calls push data from an MYSQL database according to a business instruction and sends the push data to the client that has established the communication connection; and the server monitors a replay confirmation message of the client, and resends the push data if not monitoring the replay confirmation message of the client. According to the method disclosed by the invention, the connection mapping between the server and the client is maintained by adopting the MQTT, and a plurality of clients are connected with the server through a TCP long connection, so that the connection mapping between the clients and the server is simpler. Meanwhile, by means of the repeated confirmation mechanism of the server and the repeated extraction mechanism of the client, reliable message push is ensured.

Description

technical field [0001] The present invention relates to the technical field of communication, in particular to a method and system for pushing messages based on MQTT and MYSQL. Background technique [0002] With the development and popularization of the Internet and cloud computing, more and more enterprises deploy their services on the cloud. With the expansion of enterprise services, single-point servers are far from meeting the needs. The first choice is distributed, that is, to maintain a central node and a large number of service nodes. The communication between nodes and central nodes becomes a new problem, that is, how to realize reliable communication between central nodes and nodes. [0003] In the existing communication mode, each business of the client needs to maintain a separate connection with the server, and the maintenance is very complicated. Moreover, the communication messages between the client and the server cannot be guaranteed to be delivered reliabl...

AI Technical Summary

Problems solved by technology

[0003] In the existing communication mode, each business of the client needs to maintain a connection with the server separately, and the maintenance is very complicated

Moreover, the communication messages between the client and the server cannot be guaranteed to be delivered reliably, and the reliability of the communication cannot be guaranteed.

For example, the communication messages between the client and the server are not persistent. After the process restarts and the device restarts, the messages are lost and cannot be retransmitted, making it impossible to guarantee the accurate delivery of key messages.

Images