Feature: data verification during server restart

[cubxxw]

Checklist

• I've searched for similar issues and couldn't find anything matching
• I've discussed this feature request in the OpenIMSDK Slack and got positive feedback

Is this feature request related to a problem?

❎ No

Problem Description

Add a data verification mechanism to prevent dirty data after the server restarts

Solution Description

At present, our server does not verify data after restarting, which may cause dirty data to appear in the system. I propose to add a data verification mechanism to verify the data after the server is restarted to ensure the correctness and integrity of the data.

Benefits

1. You can discover and repair dirty data as soon as possible after the server restarts to ensure the accuracy and integrity of system data. This is critical for many business systems.
2. Add a periodic data verification mechanism to detect data anomalies earlier and reduce losses. This is especially important for business-critical data.

Potential Drawbacks

none

Additional Information

More details, such as customized verification rules for different business data. The importance of the data is divided into different levels, and a differentiated verification strategy is adopted.

[cubxxw]

https://github.com/Stone-afk Discuss it here or in slack

[Stone-afk]

1

[Stone-afk]

click the wrong place =。=

[cubxxw]

LGTM

[Stone-afk]

???

[skiffer-git]

A separate module (rpc) needs to be added to manage sequences. Redis is used for caching, while MySQL is used for persistent storage.

[skiffer-git]

Sequence Manager Module:

1. Provides several interfaces to external entities, which can be viewed specifically in RedisModel.go.
2. Saves the maximum sequence to MySQL in steps of 100.
3. When restarting, it loads the sequence from MySQL. If data anomalies are discovered, it directly increments the maximum sequence by 100.

[kubbot]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 7 days.

[cubxxw]

@Stone-afk how are u?

[Stone-afk]

This problem is a bit more complicated than I imagined, and getting familiar with the project code takes some time. In recent months, I have been very busy with work and cannot find time to do it. Brother, why not assign it to other developers.

[cubxxw]

This problem is a bit more complicated than I imagined, and getting familiar with the project code takes some time. In recent months, I have been very busy with work and cannot find time to do it. Brother, why not assign it to other developers.

okkey

[kubbot]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 7 days.

[kubbot]

This issue was closed because it has been stalled for 7 days with no activity.