I have a MySQL database that is shared across 16 different database servers, and i also have 1 replica for each machine. To save money as product becomes less popular I am wanting to shard down into a single MySQL instance. I know i am able to simple SQL dump the database and import it. I am looking for the fastest way to import and export, the data since the product is active. The data set is about 1.2tb in total. 1 day of downtime is alright.
Best way to export and import 1.2tb of data to and from MySQL? is there a way to pipe it? Should I build import the data with out indexes and then build them? Any configuration files changes I should make for the import?
