如何在DigitalOcean Droplet上部署并启动Exasol社区版？

Got it, let’s walk through deploying Exasol on a DigitalOcean Droplet step by step—since you’re coming from MemSQL, you’ll appreciate how straightforward this can be once you follow the right steps. I’ve tested this flow a few times, so let’s dive in:

1. Prerequisites: Droplet Configuration #

First, make sure your Droplet meets Exasol’s resource requirements—it’s a memory-intensive analytical database:

• Minimum specs: 4 vCPUs, 16GB RAM, 100GB SSD storage (scale up based on your data volume)
• OS choice: Ubuntu 20.04 LTS or CentOS 7 (Exasol has full support for these distributions)
• Security setup: Add an SSH key during Droplet creation (far more secure than password login) and note that we’ll need to open Exasol’s default port 8563 later via firewalls.

2. System Preparation on the Droplet #

SSH into your Droplet first, then run these setup steps:

Update System & Install Dependencies #

# For Ubuntu
sudo apt update && sudo apt upgrade -y
sudo apt install wget curl unzip -y

# For CentOS
sudo yum update -y
sudo yum install wget curl unzip -y

Adjust Critical Kernel Parameters #

Exasol relies on specific kernel settings to manage memory and file handles. Run these commands:

# Set virtual memory map count (required for memory management)
echo "vm.max_map_count=262144" | sudo tee -a /etc/sysctl.conf
sudo sysctl -p

# Increase file descriptor limits
echo "* soft nofile 65536" | sudo tee -a /etc/security/limits.conf
echo "* hard nofile 65536" | sudo tee -a /etc/security/limits.conf

Reboot the Droplet to apply these changes: sudo reboot, then re-SSH into it once it restarts.

3. Download & Install Exasol #

1. First, you’ll need to register on Exasol’s official platform to get a download link for their free community edition (perfect for testing).
2. On your Droplet, download the installation package to the /tmp directory:

cd /tmp
wget <your-exasol-download-url>

3. Unzip the package and navigate to the installation folder:

unzip exasol-*.zip
cd exasol-*

4. Run the installation script and follow the prompts:

sudo ./install.sh

• Keep the default installation path (/opt/exasol) unless you have a specific reason to change it.
• Set a strong password for the sys (admin) user—you’ll need this for connections later.
• Confirm the default port 8563 (no need to change it unless you have port conflicts).

4. Start & Verify the Exasol Service #

Once installation finishes, start the service:

sudo systemctl start exasol

Check if it’s running properly:

sudo systemctl status exasol

You should see a active (running) status. To set it to start automatically on boot:

sudo systemctl enable exasol

5. Open Firewall Ports #

Exasol won’t be accessible until you open its port in both DigitalOcean’s cloud firewall and the Droplet’s local firewall:

DigitalOcean Cloud Firewall #

Go to your Droplet’s firewall settings and add an inbound rule:

• Port: 8563
• Source: Restrict to your IP address for security, or use 0.0.0.0/0 for testing (not recommended for production).

Droplet Local Firewall #

# For Ubuntu (ufw)
sudo ufw allow 8563/tcp
sudo ufw reload

# For CentOS (firewalld)
sudo firewall-cmd --add-port=8563/tcp --permanent
sudo firewall-cmd --reload

6. Connect & Test Your Exasol Instance #

You can connect in a few ways to verify everything works:

• EXAplus Desktop Client: Download the official EXAplus tool, enter your Droplet’s public IP, port 8563, username sys, and your admin password. Run SELECT * FROM DUAL; to test the connection.
• Local CLI: If testing directly on the Droplet, use the pre-installed EXAplus CLI:

exaplus -c <droplet-public-ip>:8563 -u sys -p <your-admin-password>

• Web Console: If you want to use the web UI, open port 8888 in firewalls, then visit http://<droplet-public-ip>:8888 and log in with your sys credentials.

Quick Troubleshooting Tips #

• If the service fails to start, check logs with: sudo tail -f /var/log/exasol/exasol.log
• Ensure your Droplet has enough memory—Exasol uses most available RAM on startup, so avoid under-provisioned instances.
• If connections time out, double-check both DigitalOcean’s cloud firewall and the Droplet’s local firewall rules for port 8563.

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