Back to articles
DevOps & Systems

Configure Oracle ARM VPS for Ghost CMS and SQLite with High Performance and Millions of Views

A detailed guide to configuring an Oracle ARM VPS for Ghost CMS and SQLite, optimizing performance and reducing costs for personal blogs and small businesses aiming for millions of...

DPTCloud Engineering4 min read
Configure Oracle ARM VPS for Ghost CMS and SQLite with High Performance and Millions of Views

Configure Oracle ARM VPS for Ghost CMS and SQLite

To build an effective, cost-efficient, and high-performing blog or personal website, choosing the right platform is critical. Oracle ARM VPS stands out due to its strong performance, low cost, and flexible scalability. This guide walks you through a simple and effective configuration to run Ghost CMS with SQLite—a perfect solution for personal blogs, websites, or small businesses aiming to reach millions of views.

Requirements and Preparation

Before starting, ensure you have:

  • An Oracle Cloud Infrastructure (OCI) account with Free Tier or ARM Compute Instance activated.
  • An Oracle ARM VPS (e.g., VM.Standard.A1.Flex) with at least 2 vCPU, 8GB RAM, and 50GB SSD.
  • SSH access to the server (using ssh or putty).
  • Node.js and npm installed (Ghost CMS requires Node.js 16+).

Configuration Steps

Run the following commands on your Oracle ARM VPS to install and configure Ghost CMS with SQLite:

1. Update System and Install Node.js

# Update the system
sudo apt update && sudo apt upgrade -y

# Install Node.js (v16 or higher)
curl -sL https://deb.nodesource.com/setup_16.x | sudo -E bash -
sudo apt install -y nodejs

2. Install Ghost CMS

# Create directory for Ghost
mkdir ~/ghost && cd ~/ghost

# Install Ghost CLI and run local installation
npm install ghost-cli@latest -g
ghost install local --db=sqlite3 --no-prompt

3. Configure SQLite and Ghost

After installation, Ghost creates a configuration file `config.production.json`. Open it for editing:

{
  "url": "https://your-domain.com",
  "server": {
    "port": 2368,
    "host": "127.0.0.1"
  },
  "database": {
    "client": "sqlite3",
    "connection": {
      "filename": "/home/your-user/ghost/content/data/ghost.db"
    }
  },
  "mail": {
    "transport": "direct"
  },
  "logging": {
    "level": "info"
  }
}

4. Configure Nginx as Reverse Proxy

# Install Nginx
sudo apt install nginx -y

# Create Nginx configuration file
sudo nano /etc/nginx/sites-available/ghost
server {
    listen 80;
    server_name your-domain.com;

    location / {
        proxy_pass http://127.0.0.1:2368;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
    }
}
# Enable configuration
sudo ln -s /etc/nginx/sites-available/ghost /etc/nginx/sites-enabled/
sudo nginx -t && sudo systemctl reload nginx

Optimize Performance and Increase Views

To improve performance and achieve millions of views, consider:

  • Content caching: Use Redis or Nginx FastCGI Cache.
  • Image optimization: Use Cloudflare or TinyPNG to compress images.
  • Access analytics: Install Google Analytics or Plausible.
  • SEO optimization: Optimize titles, descriptions, URLs, and content according to SEO standards.

Verify and Validate

Run the following command to check if Ghost is running:

ghost status

Visit https://your-domain.com to view your website. If it doesn’t load, check the logs:

ghost log

Troubleshooting

  • Ghost fails to start: Verify configuration file and ensure Node.js and npm are correctly installed.
  • Cannot access website: Check firewall (UFW) and ensure ports 80 and 443 are open.
  • SQLite errors: Ensure the `content/data` directory has write permissions.

References

Related infrastructure & engineering guides: NVMe Cloud VPS for Docker, Nginx & Databases

DPTCloud Tier III Infrastructure

Recommended NVMe Cloud VPS Plans to Deploy This Setup

Enterprise RAID 10 NVMe SSDs, CMC & FPT District 9 uplinks with Anycast Anti-DDoS and 99.99% SLA.

View 22 VPS Plans
ECO · vn-02

VPS-2E

94.600 ₫ / mo

10% VAT included

  • CPU: 2 vCPU
  • RAM: 2 GB
  • SSD: 30 GB NVMe
ECO · vn-02Recommended

VPS-3E

170.500 ₫ / mo

10% VAT included

  • CPU: 2 vCPU
  • RAM: 4 GB
  • SSD: 50 GB NVMe
BASIC · vn-01Recommended

VPS-05

457.600 ₫ / mo

10% VAT included

  • CPU: 4 vCPU
  • RAM: 8 GB
  • SSD: 50 GB NVMe

Related Articles

View all
ZaloZalo SupportDiscord0384 753 478