I need to move from sqlite to a distributed setup. What are my options?

I have an sqlite db that has grown to 30gb and I'm still pushing data to it everyday. I have a couple services that write to it using libsqlite3. Soon it will become too big to keep locally. What is the best way for me to migrate to a distributed setup? One way I can think of is sshfs but that won't work if my machine is offline. A solution that caches the most recently used parts of my db locally and keeps the rest somewhere else would be perfect. Most of the time I'll be using recently pushed data. I could start archiving years old data but accessing it will require manual work.