Tools to manage external storage.

[neoark]

Hello,

Do you have plans to add tools to manage external storage? Like, add load balance ability or ability to reassign images from one external storage to another? Ability Delete/reorder External Storage.

Thanks

 

[Rodolfo]

No plans for that. Besides that is extremely awkward to manage large piles of files across servers using PHP, I don't see the need for this.

 

[neoark]

So what is the best method to move external storage? Manually editing mysql database?

 

[Rodolfo]

Let's say that you have an OLD storage that you want to split in two new storages: NEW and NEWER.

1. Add both NEW and NEWER via Dahboard > Settings > External storage (make sure to reflect the same URL of OLD)
2. Go to your OLD storage and copy 50% of the files to NEW and the other 50% to NEWER. At this point you have both NEW and NEWER containing OLD (files).
3. Go to your database and assign the storage_id to each image that corresponds to either NEW or NEWER
4. Get rid of OLD

It is extremely easy. You may say, what about MySQL editing?... Is easy as took a file datetime range and apply the change:

UPDATE chv_images set storage_id = <id> WHERE storage_id = <OLD ID> AND (image_date_gmt
BETWEEN 'DATETIME 1' AND 'DATETIME 2');

Key here is to use a date as delimeter, if you want to move from one storage to another you only need to update without the date clause.