Course contentsShow
← Cloud and Infrastructure
Lesson 404 of 2,9898. Managed DatabasesFree lesson

Option Groups for Engine Features

Enabling optional database engine features through option groups for advanced functionality.

What You'll Learn

You'll learn how to enable optional add-on features for your database engines using option groups, extending your RDS instances beyond their default capabilities.

What Are Option Groups?

An option group is a configuration container that lets you turn on specific, optional features for your database engine. Think of it like a menu of add-ons at a restaurant—your database comes with a standard setup, but option groups let you customize it with extras that enhance functionality.

Not every feature is included by default in RDS because some add overhead, licensing costs, or complexity. Option groups give you the choice to enable only what you need.

How Option Groups Work

When you create an RDS instance, it's associated with an option group (often a default one). The option group specifies which additional features are active. Different database engines support different options.

For example:

  • Oracle databases might offer options like advanced security or data compression
  • SQL Server might include options for native backup to cloud storage
  • MySQL/MariaDB might enable audit logging plugins

Each option can have its own settings and may require specific instance types or engine versions to work properly.

Why Use Option Groups?

Option groups let you:

  • Enable features without rebuilding your database
  • Standardize configurations across multiple instances
  • Manage advanced capabilities separately from basic parameters (which use parameter groups, as you learned previously)

Unlike parameter groups (which tune engine behavior), option groups add or remove entire feature modules.

Key Takeaway: Option groups are specialized containers that activate optional database engine features, allowing you to extend RDS functionality beyond the default installation without manual software installation or complex configuration.