I'm struggling with this problem and I really need an advice. My project mainly needs a Social structure, users can be connected with some friendship relations, can create groups and so on. In this scenario a Graph database is a must.
However, each user also has some information that fit relational model. For example, purchases, points, historical data and so on.
At first, I thought that using two types of database could solve all my problems, so I've decided for OrientDB and MySQL. The main problem of this approach is that it's hard to mantain consistency between two databases if we are in a distributed scenario, where billion of users does operation on two databases. Moreover, MySQL as a RDBMS has some limitation for scaling.
So, I've thought: Why not use just OrientDB?
As far as I understand with its multi-model architecture and ACID transactions, I can reach the same RDBMS goal (lot of hooks), and at same time I haven't any problem with consistency. I can improve scaling problem too.
So, is it safe to use just one database, like OrientDB, to create a design like mine?