June 20, 2013

Comment: An argument for not using mysqldump

…_schema) 2) FLUSH TABLES WITH READ LOCK; 3) Record Log File and Position from SHOW MASTER STATUS; 4) Run all mysqldumps of each… company with 650+ databases (450+ GB) in one mysql instance. mysqldump databases one by one : 7 hours mysqldump in parallel, 7 databases at… lifetime with LogicWorks All 650+ DBs (450+ GB), 10.5 hours, loading 32 mysqldumps in parallel at a time I am sure…