Should this work on a VPS? Perhaps on a SSD? (Assuming that the VPS is running a version of Linux with Encrypted LUKS as an option?)
If so, what effect would it have on a website running on it?
If the system is not in your possession then it would be possible to
compromise it, however you'd need a government type opponent to be able to live extract that data. Solid State Drives are just as secure (encryption wise) as standard hard drives; the only difference is that solid-state-drives spread their data contents over the whole drive so as to share the contents over the whole storage media. This is done because SSD's have a limit on how many times a thing can be re-written.
If you had an encyrpted folder in the form of a single encrypted file that would allow you to mount that file remotely, that would work and it would be secure against attackers because the key would only be on your system and not oh the host server's memory. VeraCrypt can do that (and its free software).
I hope that helps, if you'd like anything cleared up please write back
Best regards,
warmfuzzy
--- Mystic BBS v1.12 A35 (Linux/64)
* Origin: PHATstar RetroBOX! (700:100/0)