Janusgraph connect with MySQL Storage Backend

[liu molong]

Hello，

I request your help regardding the janusgraph connect with Mysql or other  Relational DBMS. Because I'm trying to code a module which can connects to Mysql.

And current this module can connect with Mysql Server and do some simple operations like add/delete/query and so on.

But There‘’s some different when do query, I see that sliceStart/sliceEnd when do getSlice。

question 1：

Is it necessary to use sliceStart/sliceEnd when query?Beacuse I just try to  replace the Storage with MySQL,I am not sure whether the slice is necessary for JanusGraph.

question 2:

why don't you plan to support Mysql? Is it for some special reason? 

I will be very appreciate that if you can give some suggestion for the Mysql plan.

Thanks

[BO XUAN LI]

Hi Molong,

Did you have a chance to read https://docs.janusgraph.org/advanced-topics/data-model/ yet? JanusGraph needs a column-family type database which can efficiently sort the cells by column. For example, the extensive usage of “sliceStart” and “sliceEnd” in CQLKeyColumnValueStore is based on the assumption that Cassandra can store entries sorted by Clustering Column (https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/whereClustering.html).

As far as I know Mysql cannot store data in a user-specified sorting order. That being said, Mysql allows using index to accelerate ORDER BY operations. So I guess you can make use of ORDER BY to achieve the sorting order, but I am not sure how efficient that would be.

Some resources on creating a storage backend:

https://groups.google.com/g/janusgraph-dev/c/9JrMYF_01Cc/m/UfIGcD98AAAJ 

https://www.youtube.com/watch?v=rQM_ZPZy8Ck

Best regards,

Boxuan

--
You received this message because you are subscribed to the Google Groups "JanusGraph users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgraph-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/janusgraph-users/219c2de9-207b-45fa-b7a8-0639783a560fn%40googlegroups.com.

[Liu]

Thank you so much~ And I will read them to get some useful infomation.