Mysql Big Data table processing problem _ MySQL

Mysql Big Data table processing problems one mysql on the server has A very large Table A, which grows very fast and reads and writes very frequently. the reading and writing of Table A will affect the performance of the entire database. Cache is also used. In addition, what solutions are generally used to solve this problem?

Thought:

1. Table A is vertically split to different servers;

2. Table A must also perform A horizontal switch, because one server cannot be installed.

3. What about MongoDB and other databases used for table?

Please.