AWS Aurora MyRocks Support

Question

We are planning on exploring MyRocks database engine of MySQL.
I am aware that AWS RDS MariaDB supports it but haven't found any article if it's not supported by Aurora MySQL Compatible.

Is this available and will it be available in the future?

Thanks!

Kevin_Z · Answer

Hi,

1. For RDS MariaDB 10.6+ we support MyRocks storage engine: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MariaDB.Concepts.FeatureSupport.html#MariaDB.Concepts.Storage.MyRocks

When login to RDS MariaDB 10.6 run below can see

```
mysql> show engines\G
*************************** 1. row ***************************
      Engine: ROCKSDB
     Support: YES
     Comment: RocksDB storage engine
Transactions: YES
          XA: YES
  Savepoints: YES
*************************** 2. row ***************************
```

2. This is not currently supported by Aurora MySQL though. Running a Aurora MySQL (version 3.03.0, compatible with MySQL 8.0.26) Run above commands

```
mysql> show engines\G
*************************** 1. row ***************************
      Engine: FEDERATED
     Support: NO
     Comment: Federated MySQL storage engine
Transactions: NULL
          XA: NULL
  Savepoints: NULL
*************************** 2. row ***************************
      Engine: MEMORY
     Support: YES
     Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 3. row ***************************
      Engine: InnoDB
     Support: DEFAULT
     Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
          XA: YES
  Savepoints: YES
*************************** 4. row ***************************
      Engine: PERFORMANCE_SCHEMA
     Support: YES
     Comment: Performance Schema
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 5. row ***************************
      Engine: MyISAM
     Support: YES
     Comment: MyISAM storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 6. row ***************************
      Engine: MRG_MYISAM
     Support: YES
     Comment: Collection of identical MyISAM tables
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 7. row ***************************
      Engine: BLACKHOLE
     Support: YES
     Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 8. row ***************************
      Engine: CSV
     Support: YES
     Comment: CSV storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 9. row ***************************
      Engine: ARCHIVE
     Support: YES
     Comment: Archive storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
9 rows in set (0.04 sec)
```

3. For new features you can search from https://aws.amazon.com/new/?whats-new-content-all.sort-by=item.additionalFields.postDateTime&whats-new-content-all.sort-order=desc&awsf.whats-new-categories=*all

4. If you need this feature, you can try to request it through AWS Console left lower corner click Feedback and Feature Request. Or if you have support plan can also create support case to raise a feature request.

AWS Aurora MyRocks Support

Relevant content