Store canonical info about subscriptions in mysql

Redis is transient storage and should be treated as such

Change-Id: Iff63c68bbcdb0d2fce00a9226f22ae86e43ae392