How to load test a server with mysql DBMS with your own queries?

Question

linux

Good afternoon.
There is a pretty loaded server with mysql.
DB - weighs 500GB
Average load 7000 requests to the database per second.
Of these, approximately 4000 SELECT queries and 3000 INSERT, UPDATE, DELETE queries.
At peaks, the number of requests reaches 12,000 - 14,000.
Slave replication goes from this server to another server, which is much weaker. It turns out that it pulls only write requests from the Master server (3000 requests) and normally withstands it.
I want to update the Master server, so I want to temporarily disable the replica and switch all requests to it. But I'm not sure that this server will withstand the load. More precisely, it is clear that it withstands the load on the record, but what will happen when all SELECT queries are switched to it is not clear. The master server has 8 times more RAM.
Therefore, I want to somehow evaluate the ability of this server to hold the load.
The first thing that came to mind was to log all SELECT queries to some file for an hour.
Then write a script that executes all these requests from the file already to the database of the server under test, also during. And monitor the load.
It is important to test the maximum approximate load.
Perhaps there are already ready-made scripts / software for these purposes. Please advise

Answer 1

Apache Benchmark, httperf and siege.