Does any way can change the new url after we already create_engine in SQLAlchemy?
up vote
0
down vote
favorite
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
New contributor
add a comment |
up vote
0
down vote
favorite
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
New contributor
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 at 5:45
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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
New contributor
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
New contributor
New contributor
New contributor
asked Nov 21 at 3:54
SaxonTseng
11
11
New contributor
New contributor
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 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 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 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 at 5:45
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
SaxonTseng is a new contributor. Be nice, and check out our Code of Conduct.
SaxonTseng is a new contributor. Be nice, and check out our Code of Conduct.
SaxonTseng is a new contributor. Be nice, and check out our Code of Conduct.
SaxonTseng is a new contributor. Be nice, and check out our Code of Conduct.
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 at 5:45