Shard-Query (source) now supports the MySQL “LOAD DATA INFILE” command.
When you use LOAD DATA LOCAL INFILE a single threaded load from the current process will be performed. You can specify a path to a file anywhere readable by the PHP script. This allows loading without using the Gearman workers and without using a shared filesystem.
If you do not specify LOCAL, then the Gearman based loader is used. You must not specify a path to the file when you omit the LOCAL keyword. This is because the shared path will the pre-pended to the filename automatically. The shared path must be a shared or network filesystem (NFS,CIFS,etc) and the files to be loaded must be placed on the shared filesystem for the Gearman based loader to work. This is because workers may run on multiple nodes and …
[Read more]