We are in need of encrypting MySQL data at rest. Came across the community edition keyring plugin where master key information are stored locally. Maintaining keyring and data files in same location wouldn’t be an ideal solution. So we are forced to have it in some remote server but won’t it cause single point of failure?
Could be of great help if some one could share how they are ensuring high availability(HA) of remote servers where key details are maintained especially in production environment?
i.e 100% availability as DB is the base for all application working.
How do MySQL entreprise edition achieve this as few vault server options are provided?