Does AgensGraph support connection pool?
In some project, I need to use a connection pool in AgensGraph.
I found "pgpool-II" and "pg bouncer" that support a connection pool function in PostgreSQL.
So can I use those modules in AgensGraph without any configuration or specific libraries?
connection-pooling agens-graph
asked Nov 13 '18 at 1:50
Kevin LeeKevin Lee
527
add a comment |
In some project, I need to use a connection pool in AgensGraph.
I found "pgpool-II" and "pg bouncer" that support a connection pool function in PostgreSQL.
So can I use those modules in AgensGraph without any configuration or specific libraries?
connection-pooling agens-graph
asked Nov 13 '18 at 1:50
Kevin LeeKevin Lee
527
add a comment |
In some project, I need to use a connection pool in AgensGraph.
I found "pgpool-II" and "pg bouncer" that support a connection pool function in PostgreSQL.
So can I use those modules in AgensGraph without any configuration or specific libraries?
connection-pooling agens-graph
asked Nov 13 '18 at 1:50
Kevin LeeKevin Lee
527
In some project, I need to use a connection pool in AgensGraph.
I found "pgpool-II" and "pg bouncer" that support a connection pool function in PostgreSQL.
So can I use those modules in AgensGraph without any configuration or specific libraries?
connection-pooling agens-graph
connection-pooling agens-graph
asked Nov 13 '18 at 1:50
Kevin LeeKevin Lee
527
asked Nov 13 '18 at 1:50
Kevin LeeKevin Lee
527
asked Nov 13 '18 at 1:50
Kevin LeeKevin Lee
527
asked Nov 13 '18 at 1:50
Kevin LeeKevin Lee
527
asked Nov 13 '18 at 1:50
Kevin LeeKevin Lee
527
527
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You can use pg extension like pgpool or pgbouncer in AgensGraph, most of extensions are guarenteed but some extensions are not 100%, you need to make sure from AgensGraph provider, Bitnine.
answered Dec 9 '18 at 3:51
Chris KChris K
161
add a comment |
PG-Pool just works fine with the connection pool feature.
As you understand, PG-Pool support connection pool, load balance, auto failover trigger of postgresql and PG-Pool HA by watch-dog.
Among those features, connection-pool, failover trigger and PG-Pool HA work greatly without other library.
However if you are required for the load balancing feature, you should contact to the agensgraph provider for extra support or guide, since the cypher query is not able to get parsed by the original PG-Pool.
answered Feb 12 at 0:01
GyeongSu Karl JeongGyeongSu Karl Jeong
764
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53272628%2fdoes-agensgraph-support-connection-pool%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can use pg extension like pgpool or pgbouncer in AgensGraph, most of extensions are guarenteed but some extensions are not 100%, you need to make sure from AgensGraph provider, Bitnine.
answered Dec 9 '18 at 3:51
Chris KChris K
161
add a comment |
You can use pg extension like pgpool or pgbouncer in AgensGraph, most of extensions are guarenteed but some extensions are not 100%, you need to make sure from AgensGraph provider, Bitnine.
answered Dec 9 '18 at 3:51
Chris KChris K
161
add a comment |
You can use pg extension like pgpool or pgbouncer in AgensGraph, most of extensions are guarenteed but some extensions are not 100%, you need to make sure from AgensGraph provider, Bitnine.
answered Dec 9 '18 at 3:51
Chris KChris K
161
You can use pg extension like pgpool or pgbouncer in AgensGraph, most of extensions are guarenteed but some extensions are not 100%, you need to make sure from AgensGraph provider, Bitnine.
answered Dec 9 '18 at 3:51
Chris KChris K
161
answered Dec 9 '18 at 3:51
Chris KChris K
161
answered Dec 9 '18 at 3:51
Chris KChris K
161
answered Dec 9 '18 at 3:51
Chris KChris K
161
161
add a comment |
add a comment |
PG-Pool just works fine with the connection pool feature.
As you understand, PG-Pool support connection pool, load balance, auto failover trigger of postgresql and PG-Pool HA by watch-dog.
Among those features, connection-pool, failover trigger and PG-Pool HA work greatly without other library.
However if you are required for the load balancing feature, you should contact to the agensgraph provider for extra support or guide, since the cypher query is not able to get parsed by the original PG-Pool.
answered Feb 12 at 0:01
GyeongSu Karl JeongGyeongSu Karl Jeong
764
add a comment |
PG-Pool just works fine with the connection pool feature.
As you understand, PG-Pool support connection pool, load balance, auto failover trigger of postgresql and PG-Pool HA by watch-dog.
Among those features, connection-pool, failover trigger and PG-Pool HA work greatly without other library.
However if you are required for the load balancing feature, you should contact to the agensgraph provider for extra support or guide, since the cypher query is not able to get parsed by the original PG-Pool.
answered Feb 12 at 0:01
GyeongSu Karl JeongGyeongSu Karl Jeong
764
add a comment |
PG-Pool just works fine with the connection pool feature.
As you understand, PG-Pool support connection pool, load balance, auto failover trigger of postgresql and PG-Pool HA by watch-dog.
Among those features, connection-pool, failover trigger and PG-Pool HA work greatly without other library.
However if you are required for the load balancing feature, you should contact to the agensgraph provider for extra support or guide, since the cypher query is not able to get parsed by the original PG-Pool.
answered Feb 12 at 0:01
GyeongSu Karl JeongGyeongSu Karl Jeong
764
PG-Pool just works fine with the connection pool feature.
As you understand, PG-Pool support connection pool, load balance, auto failover trigger of postgresql and PG-Pool HA by watch-dog.
Among those features, connection-pool, failover trigger and PG-Pool HA work greatly without other library.
However if you are required for the load balancing feature, you should contact to the agensgraph provider for extra support or guide, since the cypher query is not able to get parsed by the original PG-Pool.
answered Feb 12 at 0:01
GyeongSu Karl JeongGyeongSu Karl Jeong
764
edited Feb 12 at 0:34
answered Feb 12 at 0:01
GyeongSu Karl JeongGyeongSu Karl Jeong
764
answered Feb 12 at 0:01
GyeongSu Karl JeongGyeongSu Karl Jeong
764
answered Feb 12 at 0:01
GyeongSu Karl JeongGyeongSu Karl Jeong
764
764
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53272628%2fdoes-agensgraph-support-connection-pool%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
