双HDD服务器根据查询动态切换媒体存储路径的实现方法咨询

Hey there! Let's figure out how to dynamically switch storage paths based on your media files' dates—perfect for splitting between your two HDDs. Here's a practical, step-by-step approach tailored to your setup:

First, make sure your media table has a way to identify which files belong to 2018 or earlier. If you don’t already have one, add a field to track the file’s year (you can use an existing created_at timestamp to generate this):

-- Add a generated column to extract the year from created_at (PostgreSQL example)
ALTER TABLE media ADD COLUMN created_year INT GENERATED ALWAYS AS (EXTRACT(YEAR FROM created_at)) STORED;

-- For MySQL, use this instead:
ALTER TABLE media ADD COLUMN created_year INT AS (YEAR(created_at)) STORED;

Alternatively, you could add a storage_group enum field (like 'current' and 'archive_2018') if you prefer manual grouping, but a year-based field is more flexible.

Next, set up a separate filesystem disk for your archive HDD in your application’s config. Let’s assume your second HDD is mounted at /mnt/archive_hdd—here’s how you’d define it (example uses Laravel’s config/filesystems.php, but the logic applies to any framework):

'disks' => [
    'media_current' => [
        'driver' => 'local',
        'root' => storage_path('app/media'),
        'visibility' => 'public', // Adjust based on your access needs
    ],
    'media_archive' => [
        'driver' => 'local',
        'root' => '/mnt/archive_hdd/media',
        'visibility' => 'public',
    ],
],

Important: Double-check that your web server user (like www-data or nginx) has read/write permissions for the /mnt/archive_hdd/media directory.

Create methods in your Media model to automatically return the correct storage disk and file path based on the file’s year. This keeps your path logic centralized and clean:

class Media extends Model
{
    // Get the appropriate storage disk for this media file
    public function getStorageDisk()
    {
        return $this->created_year <= 2018 
            ? Storage::disk('media_archive') 
            : Storage::disk('media_current');
    }

    // Get the full absolute path to the file
    public function getFullFilePath()
    {
        return $this->getStorageDisk()->path($this->file_path);
        // Assumes 'file_path' is the relative path stored in your media table
    }

    // Get a web-accessible URL (if your disks are configured for public access)
    public function getFileUrl()
    {
        return $this->getStorageDisk()->url($this->file_path);
    }
}

If you’re not using Laravel, the core idea is the same: write a helper function that takes a media record, checks the year, and returns the correct root path to append to the file’s relative path.

Now you can seamlessly fetch or manipulate files using the model methods—no hardcoding paths! Examples:

// Fetch a single media file and get its full path
$media = Media::find($mediaId);
$absolutePath = $media->getFullFilePath();
$webUrl = $media->getFileUrl();

// Batch process files (e.g., generate thumbnails)
$mediaItems = Media::where('category', 'photos')->get();
foreach ($mediaItems as $item) {
    $disk = $item->getStorageDisk();
    if ($disk->exists($item->file_path)) {
        $fileContent = $disk->get($item->file_path);
        // Do your processing here
    }
}

If you already have files in the current storage path that need to be moved to the archive HDD, run a one-time migration script. Always back up your data first!

$archiveMedia = Media::where('created_year', '<=', 2018)->get();

foreach ($archiveMedia as $media) {
    $currentDisk = Storage::disk('media_current');
    $archiveDisk = Storage::disk('media_archive');

    if ($currentDisk->exists($media->file_path)) {
        // Copy the file to the archive disk
        $archiveDisk->put($media->file_path, $currentDisk->get($media->file_path));
        // Delete the original file (only after verifying the copy works!)
        $currentDisk->delete($media->file_path);
    }
}

When uploading new files, route them to the right disk immediately by checking the file’s year (either the upload date or the file’s original creation date):

public function uploadMedia(Request $request)
{
    $file = $request->file('media');
    // Use the file's original creation year, or current year if preferred
    $fileYear = date('Y', filemtime($file->getRealPath()));

    $disk = $fileYear <= 2018 
        ? Storage::disk('media_archive') 
        : Storage::disk('media_current');
    
    $filePath = $disk->put('uploads', $file);

    // Save to database with the correct year
    Media::create([
        'file_path' => $filePath,
        'created_year' => $fileYear,
        // Add other fields as needed
    ]);
}

内容的提问来源于stack exchange，提问作者Flak