Can I configure my own metadata storage?

Yes. You can configure metadata storage on the Druid side. You can then initialize the metadata store, then import your metadata. The example MySQL commands are here.

Here’s some context.