Mixing
Does any way can change the new url after we already create_engine in SQLAlchemy?
0
I use postgresql streaming cluster with sqlalchemy, since the database server can scale out or failover so I need to change the new url when it detects the scale out or failover in my API, but I can not find how can change new url in existing running create_engine with connection_pool open.
- Does it need to destroy old create_engine and create new? It's seems do not have way do destroy.
- If no need to destroy, how can change the url and make sure connection pool will use new url to connect?
python sqlalchemy
asked Nov 21 '18 at 3:54
SaxonTsengSaxonTseng
11
add a comment |
0
I use postgresql streaming cluster with sqlalchemy, since the database server can scale out or failover so I need to change the new url when it detects the scale out or failover in my API, but I can not find how can change new url in existing running create_engine with connection_pool open.
- Does it need to destroy old create_engine and create new? It's seems do not have way do destroy.
- If no need to destroy, how can change the url and make sure connection pool will use new url to connect?
python sqlalchemy
asked Nov 21 '18 at 3:54
SaxonTsengSaxonTseng
11
This is the kind of thing you’d use a proxy for. I don’t know much about the postgresql ecosystem but I’m using proxysql for the same thing with MySQL. You connect sqlalchemy to the proxy and the proxy monitors the health of your database nodes and forwards the queries to an appropriate node in the cluster. A quick google brought up pgpool but not sure what the canonical option is for Postgres.
– SuperShoot
Nov 21 '18 at 5:45
add a comment |
0
0
0
I use postgresql streaming cluster with sqlalchemy, since the database server can scale out or failover so I need to change the new url when it detects the scale out or failover in my API, but I can not find how can change new url in existing running create_engine with connection_pool open.
- Does it need to destroy old create_engine and create new? It's seems do not have way do destroy.
- If no need to destroy, how can change the url and make sure connection pool will use new url to connect?
python sqlalchemy
asked Nov 21 '18 at 3:54
SaxonTsengSaxonTseng
11
I use postgresql streaming cluster with sqlalchemy, since the database server can scale out or failover so I need to change the new url when it detects the scale out or failover in my API, but I can not find how can change new url in existing running create_engine with connection_pool open.
- Does it need to destroy old create_engine and create new? It's seems do not have way do destroy.
- If no need to destroy, how can change the url and make sure connection pool will use new url to connect?
python sqlalchemy
python sqlalchemy
asked Nov 21 '18 at 3:54
SaxonTsengSaxonTseng
11
asked Nov 21 '18 at 3:54
SaxonTsengSaxonTseng
11
asked Nov 21 '18 at 3:54
SaxonTsengSaxonTseng
11
asked Nov 21 '18 at 3:54
SaxonTsengSaxonTseng
11
asked Nov 21 '18 at 3:54
SaxonTsengSaxonTseng
11
11
This is the kind of thing you’d use a proxy for. I don’t know much about the postgresql ecosystem but I’m using proxysql for the same thing with MySQL. You connect sqlalchemy to the proxy and the proxy monitors the health of your database nodes and forwards the queries to an appropriate node in the cluster. A quick google brought up pgpool but not sure what the canonical option is for Postgres.
– SuperShoot
Nov 21 '18 at 5:45
add a comment |
This is the kind of thing you’d use a proxy for. I don’t know much about the postgresql ecosystem but I’m using proxysql for the same thing with MySQL. You connect sqlalchemy to the proxy and the proxy monitors the health of your database nodes and forwards the queries to an appropriate node in the cluster. A quick google brought up pgpool but not sure what the canonical option is for Postgres.
– SuperShoot
Nov 21 '18 at 5:45
This is the kind of thing you’d use a proxy for. I don’t know much about the postgresql ecosystem but I’m using proxysql for the same thing with MySQL. You connect sqlalchemy to the proxy and the proxy monitors the health of your database nodes and forwards the queries to an appropriate node in the cluster. A quick google brought up pgpool but not sure what the canonical option is for Postgres.
– SuperShoot
Nov 21 '18 at 5:45
This is the kind of thing you’d use a proxy for. I don’t know much about the postgresql ecosystem but I’m using proxysql for the same thing with MySQL. You connect sqlalchemy to the proxy and the proxy monitors the health of your database nodes and forwards the queries to an appropriate node in the cluster. A quick google brought up pgpool but not sure what the canonical option is for Postgres.
– SuperShoot
Nov 21 '18 at 5:45
add a comment |
0
active
oldest
votes
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
});
}
});
draft saved
draft discarded
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%2f53405035%2fdoes-any-way-can-change-the-new-url-after-we-already-create-engine-in-sqlalchemy%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53405035%2fdoes-any-way-can-change-the-new-url-after-we-already-create-engine-in-sqlalchemy%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
This is the kind of thing you’d use a proxy for. I don’t know much about the postgresql ecosystem but I’m using proxysql for the same thing with MySQL. You connect sqlalchemy to the proxy and the proxy monitors the health of your database nodes and forwards the queries to an appropriate node in the cluster. A quick google brought up pgpool but not sure what the canonical option is for Postgres.
– SuperShoot
Nov 21 '18 at 5:45