Laravel Multi-SQLite: LiteFS

Important: LiteFS is outside our scope of support. We are not able to provide support or guidance for it. Use with caution.

Don’t use LiteFS with autostop/autostart on Fly Machines.The Fly Proxy can stop and restart Machines without knowing which Machine holds the LiteFS lease or has the latest data. This can allow a Machine with stale data to acquire the lease, causing LiteFS to discard newer changes and LTX files. The result can be a database rollback and permanent data loss.

This is a technology preview. “LiteFS” is a distributed file system that enables you to sync SQLite data across instances of your application. Read further on the official LiteFS documentation and follow along a LiteFS-configured sample Laravel repository here.

Laravel Specific Configuration

Take note of the following important steps in configuring your Laravel Fly App with LiteFS:

You’ll have to configure SQLite connection in your fly.toml file:

[env]
    ...
    DB_CONNECTION="sqlite"
    DB_DATABASE="/var/www/html/storage/database/database.sqlite"

Since we’re saving the SQLite database in the storage directory, make sure to mount a volume on it by following this guide here.
Execute litefs mount instead of starting the server in .fly/entrypoint.sh:
exec litefs mount

Make sure to properly configure the configuration file( etc/litefs.yml ) read by LiteFS:

fuse:
  # Point to the directory containing your DB_DATABASE in fly.toml
  dir: "/var/www/html/storage/database"

  # Allow none-root access to the directory above--required for web access
  allow-other:true

# Start the server, this was previously run in .fly/entrypoint.sh
exec: "supervisord -c /etc/supervisor/supervisord.conf"

Include a ( etc/fuse.conf ) file to enable allow-other option above to work.
Revise the generated Dockerfile to include the LiteFS image, install required packages, and copy the configuration files etc/litefs.yml and etc/fuse.conf to a proper location LiteFS can read.
Create a middleware to forward write requests to the primary node using fly-replay
Use a non-file session driver to allow fly-replay to work on Laravel CSRF protection.

​Laravel Specific Configuration

Laravel Specific Configuration