We want to custom the storage for metadata, and how to do we can?
Have you checked out our documentation on this?: https://docs.dremio.com/deployment/metadata-store-config.html
Where do you want to store the metadata?
We don’t want to maintain nfs, and want to use database(mysql) instead of nfs.
You cannot use MySQL to store Dremio’s metadata. Dremio uses RocksDB to persist and retrieve metadata. RocksDB writes various database files and logs to whatever storage you have configured for the
db path on the Dremio master coordinator node. You can store this on a locally attached drive, instead of NFS, if you like.