Scaling

2 min read Updated 1 day ago

Scaling

As your application grows, you may need to upgrade your database to handle more traffic, store more data, or improve query performance. Ploi Cloud makes it easy to scale your managed database.

Resizing Your Database

To upgrade (or downgrade) your database plan:

  1. Navigate to your database
  2. Click the Resize option
  3. Select a new plan
  4. Confirm the resize

The resize operation is performed with minimal downtime. Multi-node databases handle resizes gracefully using rolling upgrades.

What Changes When You Resize

When you resize, the following resources are adjusted:

  • CPU - More processing power for complex queries
  • RAM - More memory for caching and query operations
  • Storage - More disk space for data

Cloning a Database

You can create an exact copy of your database for testing or migration purposes:

  1. Navigate to your database
  2. Click the Clone option
  3. Confirm the clone operation

The clone creates a new, independent database instance with all your data, users, and settings. It runs on its own infrastructure and has separate billing.

When to Scale

Signs that you need a larger plan:

  • Slow queries - Queries that used to be fast are getting slower
  • High CPU - CPU usage consistently above 80%
  • Memory pressure - Frequent cache misses or out-of-memory events
  • Storage filling up - Disk usage approaching the plan limit
  • Connection limits - Applications failing to connect due to max connections

Scaling Best Practices

  • Monitor before scaling - Use the Monitoring tab to confirm that resources are the bottleneck
  • Optimize queries first - Sometimes a query optimization avoids the need to upgrade
  • Test with a clone - Clone your database and test your application against the larger plan before committing
  • Scale during low traffic - While resizes are low-downtime, it's still best to do them during quiet periods

Next Steps

  • Monitoring - Understand your current resource usage
  • Properties - Tune engine settings for better performance