vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| dear all, we are migrating from a single database with MyISAM tables to a cluster with NDB type tables (both MySQL). With MyISAM we do huge bulk inserts using a temporary table and load infile. This method does not work in the NDB type. Temporary tables do not work. ALTER table in a NDB cluster is unreliable and/or slow. We have millions of pageviews, so any downtime is really not an option. Is there a tested method for bul inserts in NDB clusters? |