I have a MySQL database with tables in the form of
I want to add another DB server and move the even-numbered shards (
"shard_4", ...) to the new machine.
How do I do that? There are many tables so ideally I wouldn't have to type out each table name individually but do something automatically.