We are moving out site from single dedicated server to AWS. AS part of the AWS implementation we will be using a load balancer across multiple web hosts (to a single DB). In order to support this configuration we need to move from file based session data to DB but in testing this breaks the site.
The process we are testing is to change local.xml to DB session and then clearing session/cache of server. Going to the site root works, but as soon as you try logging in or go through checkout you are prompted with the Magento installation screen?!? Same happens when you go to the admin page.
So, it appears that it's working for HTTP but not HTTPS? Also noticed that no cache is being created in var - the cache folder is created but no subfolder/files. Permissions are 777 on var.
Any help appreciated.