all, is it possible to mysqldump specific tables from multiple databases in a single run?
what I am trying to do is get replication slaves to a starting point but am somewhat challenged by the nature of our architecture. specifically, we have a large number of relatively-static (updated only a few times/yr w/plenty of advance notice) tables which are relatively big (~50GB among them) and a small number of tables that are relatively small (~1GB among them) but are updated continuously (several million DMLs/day). what I had done w/a single DB was dump/load the static tables to a new slave then dump/load the dynamic ones w/a --master-data which took ~1 min (acceptable off hours). that got me to a point I could do a change master... then slave start and be in business. I am now trying to merge in a small, secondary application (only ~50K DMLs/day) which is currently in a separate database. I can not (even off hours) lock the entire database (main one) long enough to do a full dump with locks so I see my options as: 1. hope someone here knows how to do my original question 2. get architecture to sign off on consolidating tables into a single database (in progress). 3. hope someone here know an approach I hadn't even thought of (paradigm shifting w/o a clutch). thoughts? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
