DocumentationCommerceContent and Design

Use a media database

Last update: Tue Aug 29 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Experienced
  • Admin
  • User
IMPORTANT
The database media storage method is deprecated as of Adobe Commerce and Magento Open Source 2.4.3.

By default, all images, compiled CSS files, and compiled JavaScript files of the Commerce instance are stored in the file system on the web server. You can choose to store these files in a database on a database server. One advantage of this approach is the option of automatic synchronization and reverse synchronization between the web server file system and the database. You can use the default database to store media or create one. To be able to use a newly created database as media storage, you must add information about it and its access credentials to the env.php file.

Database workflow

  1. Browser requests media - A page from the store opens in the customer’s browser, and the browser requests the media that is specified in the HTML.

  2. System looks for media in file system - The system searches for the media in the file system and if found, passes it to the browser.

  3. System locates media in database - If the media is not found in the file system, a request for the media is sent to the database that is specified in the configuration.

  4. System locates media in database - A PHP script transfers the files from the database to the file system, and sent to the customer’s browser. The browser request for media triggers the script to run as follows:

    • If web server rewrites are enabled for Commerce and supported by the server, the PHP script runs only when the requested media is not found in the file system.
    • If web server rewrites are disabled for Commerce, or not supported by the server, the PHP script runs anyway, even if the required media is available in the file system.

Use a database for media storage

  1. On the Admin sidebar, go to Stores > Settings > Configuration.

  2. In the left panel, expand Advanced and choose System.

  3. In the upper-left corner, set Store View to Default Config to apply the configuration at the global level.

  4. Expand Expansion selector the Storage Configuration for Media section and do the following:

    img-md
    w-600 modal-image
    Advanced configuration - storage configuration for media

    • Set Media Storage to Database.

    • Set Select Media Database to the database you want to use.

    • To transfer the existing media to the newly selected database, click Synchronize.

    • Enter the Environment Update Time in seconds.

  5. When complete, click Save Config.

recommendation-more-help
2b0136b4-ef75-405f-9734-60d741f198de