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[Read more...]