New to redash, never used the product before. Looking for some assistance with doing an upgrade on hosted solution. I see the detailed commands in the update guide but that doesn’t help me much as this is my first time working with this product. any help would be greatly appreciated.
Starting Redash upgrade:
Found version: 8.0.0
Current version: 7.0.0+b17535
I asked my developer that uses it and he’s not sure and these were the only notes he had for the upgrade which is what I tried:
service supervisord restart
cd /opt/redash/current/bin
./upgrade
(run restart after upgrade)
yum update
(VM updates)
Create checkpoint on VM before upgrade.
Delete checkpoint after successful install.
I see. So that upgrade path has been deprecated since we use Docker now. The easiest option here is to migrate from your non-Docker instance to a Docker instance of the same version (V7 -> V7) and then upgrade your Docker instance to V8 using the steps shown in our “How To Upgrade” doc.
Starting from the Redash V8 release we’re no longer building the tarball version of a release – only Docker images. This of course doesn’t prevent you from deploying Redash anyway you want, but the bin/upgrade script won’t work with the new releases.
Just noticed this on the web site and I’m now I am a bit stressed. So how do we upgrade without moving to docker. Step by step please.
We have MySQL 5.7 database with most of the data that we access from redash queries running on the same machine. (not sure if that is what you are asking or if you are refering to some redash db - but in any case everything is on one machine and is working well)
Have been running redash in AWS for ages and upgraded to 7, now getting to 8 is a bit of a learning curve. Got 8 running in docker and in EC2 instance (requires 2Gb RAM, hence t2.small that is more expensive). Probably can get also 7 working in docker and then replace DB and upgrade, but
how to replace DB within docker image?
how to split docker image building and build ECS cluster with necessary networking?
There I need help. Is somewhere some examples or documentation that I could use?
Building images in EC2 instance and deploying them to ECS and figuring out networking? Is that the strategy to go for?
Also has someone been able to get redash in docker running on mac? As it would be significantly easier to do development and building on mac and then deploy to AWS ECS?
There are two options for you to move to a Docker based deployment:
Move everything to Docker
The new AMIs have everything running in Docker. To move to such an instance:
Create a backup of your Postgres database.
Start a new Docker based AMI.
Update the Docker image to use the same version as you were using previously (v7 in your case).
Import the Postgres database backup you created in step 1.
Check that everything is working properly.
Upgrade to V8.
Move only Redash to Docker
The other option is to move only the Redash services to Docker, but keep the same Postgres/Redis you were using before on the host.
Check how the setup script works to manually setup Docker and Docker-Compose.
Use a similar docker-compose.yml, but remove the Postgres, Redis and Nginx services from it. Also you will need to setup it up in a way that allows the Docker containers to access ports from the host (to be able to communicate with Postgres/Redis).
Update version to be the same version as you were using previously.
Stop old services and start Docker Compose.
Make sure that everything is working properly
Upgrade to v8.
Obviously I skipped lots of details here, but wanted to provide the layout in case someone wants to take a stab at it.
I got docker based v8 working on EC2 but the goal is to move it all to ECS and drop EC2 instance. Not sure yet if that is more cheaper or not?
I was planning to build everything on docker and then deploy images to ECS and setup cluster and networking in a way where they can be talking to each other.
That would need docker compose rework I guess.
Added bonus would be to setup DB in RDS and have redash talking to it.
Roger, then I focus on getting v7 on docker to work on EC2 t2.small instance (was sofar running on micro with 1Gb and 1Gb swap) and update the DB and upgrade to v8. 2Gb RAM is enough I guess?