Like to write, or directly through the mysql to write, just read read through redis, the write operation is not the same may be called a bottleneck?
Extension for consideration, if there are two cluster, a cluster is business logic to handle the cluster, as service clusters; Is a database cluster, notes for the database cluster, the two cluster logically separate,
Business cluster (cluster) service need frequent calls database cluster (database cluster) to read and write operations, if use the mysql database cluster + redis way, don't know what to support level of read and write operations, not be achieved few thousand times a second to read and write? Two is a millisecond, speaking, reading and writing ok?
If you can, it writes a second can read and write operations support?
There is also a doubt, redis support cluster, or take a redis + mysql, for example, if the database cluster, there are three host memory data of the three hosts will be redis synchronization into the same? If it is, the synchronization error will be a few seconds?
My thinking is, if the business cluster casually to the database in the cluster which the host to read or write data, if three hosts are not synchronized, for example, I want to read A resource of A state, you may not have access to the host of A data, or in the three hosts A state, it would be wrong
Only 95 points available, only to choose 50 points, very hope to have ace intellectualize, because this paragraph of time I'm thinking of a system problem, the framework of database of this unknown
CodePudding user response:
If a single machine can't meet you can only consider twemproxy mysql cluster redis have a tidb or directing a sharding