MGR for high availability (single master, three nodes)
Keeplived floating IP implementation (application is more, think transparent to application can avoid a lot of problems)
Shading JDBC table (data volume is around 10000 per hour, permanent preservation, have a need to query statistics, press year + month table)
1, this scheme feasible in a production environment, please (used for the first time, lack)
2, is there any way to realize load balance (query request is more, want to send a query to a read-only database)
3, 10000 the amount of data per hour, permanent preservation, table a feasible (data structure is simpler, 40 varchar (30), to the historical data query statistics requirement (all statistics), but not very often)
CodePudding user response:
Ten thousand per hour, data volume is not large, in addition to the shading used, the production environment should be no problem