Skip to main content

Migrate from Multi-Container setup

Let's say your current Appsmith instance is located in the folder ~/appsmith-old, and you'd like the new setup be at ~/appsmith-new. (This are just example folder names, please use what you prefer.)

Then we can see a rough folder structure like this for ~/appsmith-old:

~/appsmith-old
├── data
│ ├── certbot
│ │ ├── conf
│ │ └── www
│ ├── mongo
│ │ ├── db
│ │ └── init.js
│ └── nginx
│ └── app.conf.template
├── docker-compose.yml
├── docker.env
└── encryption.env

And like this for ~/appsmith-new (after the steps in this document are done):

~/appsmith-new
├── docker-compose.yml
└── stacks
├── configuration
│ ├── docker.env
│ └── mongo-init.js
├── data
│ ├── backup
│ ├── certificate
│ ├── mongodb
│ └── restore
└── letsencrypt
├── accounts
├── archive
├── conf
├── csr
├── keys
├── live
├── options-ssl-nginx.conf
├── renewal
├── renewal-hooks
├── ssl-dhparams.pem
└── www

Now let's go over the steps to be performed.

1. Shutdown old appsmith instance

🚨 Please ensure you are aware of the following facts before proceeding:

  • This whole migration should take under 25-30mins, usually less than that.
  • All users who are currently logged-in, will be logged out. They can just log back in, once the new instance is up and running just fine.
  • Depending on your configuration, any docker-compose and docker commands below might need to be run with a sudo at the start.
  • Please check the output of commands to see if there's any errors, after running a command, and before proceeding to next steps.

Let's first define a couple of variables that'll be useful during our migration. Please use the appropriate paths in place of ~/appsmith-old and ~/appsmith-new.

old_path=~/appsmith-old
new_path=~/appsmith-new

Before we can start the migration, please stop the old server with the following command:

cd "$old_path"
docker-compose stop appsmith-internal-server

2. Export database

To export data from the running MongoDB database, we use the mongodump command, which will create a gzip archive with all the data. This file will then be copied to the new setup and imported.

Create backup folder to store dump file:

cd "$old_path"
docker-compose exec mongo mkdir -pv /data/db/backup

Dumping MongoDB data and compressed into a gzip file:

docker-compose exec mongo sh -c 'mongodump --uri="$APPSMITH_MONGODB_URI" --archive=/data/db/backup/appsmith-data.archive --gzip'

3. Migrate Configuration

The new setup uses a single docker.env file for all environment variable configuration.

Let's create the folder structure needed:

mkdir -pv "$new_path"/stacks/configuration

Migrate configuration from old location:

cat "$old_path"/docker.env "$old_path"/encryption.env >> "$new_path"/stacks/configuration/docker.env

Now, in the file "$new_path"/stacks/configuration/docker.env:

  • Unless you are using an external MongoDB database, in APPSMITH_MONGODB_URI, please change the @mongo part to @localhost, and remove the query params (the ? and everything after it). For example, if the current value is mongodb://root:rootpass@mongo/appsmith?retryWrites=true&authSource=admin, change it to be just mongodb://root:rootpass@localhost/appsmith.
  • Unless you are using an external Redis instance, in APPSMITH_REDIS_URL, please change redis://redis:6379 to redis://localhost:6379. That is, change the host from redis to localhost.

At the end of this docker.env file, let's add the following new environment variables:

APPSMITH_MONGODB_USER=<Your MongoDB User>
APPSMITH_MONGODB_PASSWORD=<Your MongoDB Password>
APPSMITH_API_BASE_URL=http://localhost:8080

Here, in place of <Your MongoDB User> and <Your MongoDB Password>, please use the same username and password that were given to APPSMITH_MONGODB_URI above. In the above example values, these would be root for user and rootpass for password.

4. Export https config & certificate (optional)

If you are not using a custom domain with your Appsmith instance, please skip this step.

If you don't have APPSMITH_CUSTOM_DOMAIN already configured in your docker.env, please add a line like below

echo APPSMITH_CUSTOM_DOMAIN=appsmith.mycustomdomain.com >> "$new_path"/stacks/configuration/docker.env

You can also move your certificate to the new container by running following commands:

mkdir -pv "$new_path"/stacks/letsencrypt
sudo cp -rfv "$old_path"/data/certbot/conf/* "$new_path"/stacks/letsencrypt

5. Setup new Appsmith with Fat container

Let's bring down the old instance in-full now:

docker-compose --file "$old_path"/docker-compose.yml down

Follow the official guide to start with a new Appsmith deployment at Docker Compose Configuration, also shown here in brief for reference:

cd "$new_path"
curl -L https://bit.ly/32jBNin -o docker-compose.yml
docker-compose up -d

Please note that you must create a new docker-compose.yml in "$new_path" folder, like with the curl command above. Don't copy it from "$old_path".

6. Import database

After your new deployment comes up (usually takes ~30 seconds), we will import the data that was exported from the old instance:

Create the folder to copy the archive file:

mkdir -pv "$new_path"/stacks/data/restore

Copy the archive file:

cp "$old_path"/data/mongo/db/backup/appsmith-data.archive "$new_path"/stacks/data/restore/

Import data from this archive:

docker-compose exec appsmith appsmithctl import_db

Note that this will ask you Importing this DB will erase this data. Are you sure you want to proceed, where you can respond with y. It is safe in this situation since the new database in the new setup only contains initial data and should be safe to be overwritten.

Once this is successful, we are ready to bring up our new instance!

7. Verify migration

Navigate to your Appsmith instance, the same way you used to with your old instance, whether using IP address, or custom domain, and verify that your Appsmith instance is working well, and all your data is intact.

After this, please designate a user as the superuser, to give them access to the Admin Settings page. You can follow the instructions at Configuring a superuser to apply this change. diff --git a/setting-up/migrate.md b/setting-up/migrate.md