Distributed Database Cluster middleware _ MySQL

I am a distributed database cluster middleware developer. I have been developing for more than a year. today I want to summarize some of the things I know, provide some reference to developers who have recently come to this field. Life is not easy, making money is not easy, leaving is just to make more money. ---- I am only a developer of distributed database cluster middleware. I have been developing for more than a year. today I will summarize some of the things I know, provide some reference to developers who have recently come to this field.

Life is not easy, making money is not easy, leaving is just to make more money. ---- Xuejie

I just said the system I have developed:

The following article will provide a detailed analysis. here we will simply sort it out. That is to say, which aspects do you need to consider when developing distributed database cluster Middleware.

First, we will analyze what we are working on from the name:

1. Distributed

You need to consider its direction (detailed description later)

A) concepts in distributed architecture

B) distributed model

C) distributed system features

2. Database Cluster

We use MySQL for backend storage.

A) What is MySQL?

B) what are the functions of database clusters (what are Database/table sharding and vertical sharding)

C) What is the role of MySQL in the system?

3. middleware

What is middleware?

The above uses the name to determine what we need to know.

What technologies can we use to implement distributed database cluster Middleware?

1. network programming (socket, multiplexing, libevent, ACE) is required)

2. multi-thread programming is required (why not multi-process or single-thread)

3. memory management (for operating system memory application and release, how can we better manage the memory)

4. log management (how to store and store system logs)

5. metadata information management (can I recover to shutdown after the system is restarted ?)

Many problems are waiting for our research. For the time being, please refer to the above questions for updates.