I want to create LVM using sshfs or NFS. Is it possible at all? I tried searching over web but did not find anything. Forgive me if this question is wrong for this community.
According to Is there a way to do something like LVM over NFS? it is possible.
Sensible is another matter: as noted in the answer to that question, if NFS (and/or the network) has an issue at any point, there is a strong chance your LVM will get corrupted.
I would have to assume that same risk applies (possibly more so) to SSHFS.
A possibly less brittle solution might be to have LVM underpinning your NFS exports - that sounds less risky, but without knowing your use case, I don't know if it would do what you wanted it to.
In this case, it does sound like using LVM on your NFS server, and then exporting the LVM volume using NFS would be functionally equivalent, while avoiding (some of) the potential for corruption.
I suppose sharding could be mentioned here - see https://stackoverflow.com/questions/5541421/mysql-sharding-approaches for discussion about that.