enable retention periods for data hosted on self-hosted MySQL