Re: Loading large tables using the Synonym Switching Technique (SST)

[Rick James]

No SST. However, this has the equivalent effect:

1. CREATE TABLE `New` LIKE `Customer`;
2. Load `New` (by whatever means)
3. RENAME TABLE `Customer` TO `Old`, `New` TO `Customer`;
4. DROP TABLE `Old`;

Step 2 is the only long step.
Step 3 is atomic, so you have not down time.
Step 4 can be delayed until you are sure the replacement is OK.

(Perhaps FOREIGN KEYS, Triggers, and Views may be a problem.)