apache / incubator-hugegraph

A graph database that supports more than 100+ billion data, high performance and scalability (Include OLTP Engine & REST-API & Backends)
https://hugegraph.apache.org
Apache License 2.0
2.58k stars 512 forks source link

创建一个新的图,可以和原来的图共同存储在同一个mysql后端中吗? #2554

Open SkrDrag opened 3 weeks ago

SkrDrag commented 3 weeks ago

Feature Description (功能描述)

两张图能使用同一个mysql后端的配置吗 jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://210.45.xxx.xx:3306 jdbc.username=xx jdbc.password=xxxx jdbc.reconnect_max_times=3 jdbc.reconnect_interval=3 jdbc.ssl_mode=false

@dosu

github-actions[bot] commented 1 week ago

Due to the lack of activity, the current issue is marked as stale and will be closed after 20 days, any update will remove the stale label

JackyYangPassion commented 2 days ago

Feature Description (功能描述)

两张图能使用同一个mysql后端的配置吗 jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://210.45.xxx.xx:3306 jdbc.username=xx jdbc.password=xxxx jdbc.reconnect_max_times=3 jdbc.reconnect_interval=3 jdbc.ssl_mode=false

@dosu

此处只要是配置 store=hugegraph_01 store=hugegraph_02

dosubot[bot] commented 2 days ago

是的,两张图可以使用同一个 MySQL 后端的配置。你只需要在每个图的配置文件中指定不同的 store 名称即可。例如:

graph1.properties:

backend=mysql
serializer=mysql

store=hugegraph_01
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://210.45.xxx.xx:3306
jdbc.username=xx
jdbc.password=xxxx
jdbc.reconnect_max_times=3
jdbc.reconnect_interval=3
jdbc.ssl_mode=false

graph2.properties:

backend=mysql
serializer=mysql

store=hugegraph_02
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://210.45.xxx.xx:3306
jdbc.username=xx
jdbc.password=xxxx
jdbc.reconnect_max_times=3
jdbc.reconnect_interval=3
jdbc.ssl_mode=false

这样,两张图就可以共享同一个 MySQL 后端,但使用不同的存储空间 [1][2][3]

To continue talking to Dosu, mention @dosu.