Does any way can change the new url after we already create_engine in SQLAlchemy?

Multi tool use
Multi tool use











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.




  1. Does it need to destroy old create_engine and create new? It's seems do not have way do destroy.

  2. If no need to destroy, how can change the url and make sure connection pool will use new url to connect?






python sqlalchemy







share|improve this question







New contributor




SaxonTseng is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




















  • 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















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.




  1. Does it need to destroy old create_engine and create new? It's seems do not have way do destroy.

  2. If no need to destroy, how can change the url and make sure connection pool will use new url to connect?






python sqlalchemy







share|improve this question







New contributor




SaxonTseng is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




















  • 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













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.




  1. Does it need to destroy old create_engine and create new? It's seems do not have way do destroy.

  2. If no need to destroy, how can change the url and make sure connection pool will use new url to connect?






python sqlalchemy







share|improve this question







New contributor




SaxonTseng is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











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.




  1. Does it need to destroy old create_engine and create new? It's seems do not have way do destroy.

  2. 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






share|improve this question







New contributor




SaxonTseng is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question







New contributor




SaxonTseng is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question






New contributor




SaxonTseng is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked Nov 21 at 3:54









SaxonTseng

11




11




New contributor




SaxonTseng is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





SaxonTseng is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






SaxonTseng is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












  • 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




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

















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',
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
});


}
});






SaxonTseng is a new contributor. Be nice, and check out our Code of Conduct.










 

draft saved


draft discarded


















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






























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.










 

draft saved


draft discarded


















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.















 


draft saved


draft discarded














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





















































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







rzga5GfM,5XW44v2
-
RNAxJvIBCwEGVLVB5oH4ckTJW7J,AgIaacVHFEpoI1g9,IGP8q08fwtDQ PHT2qUB1nw9LFr3ZqQ6HESg8,3 TQh,sxt,b,2eQDb

Popular posts from this blog

xlwings: Save and Close

Image
1 I am trying to find out how to save and close to an existing workbook using xlwings after writing in it: import xlwings as xw list_of_values = [1, 2, 3] workbook_path = 'abc.xlsx' wb = xw.Book(workbook_path) ws = wb.sheets['sheet1'] ws.range('E35').value = list_of_values wb.save() wb.close() When I get to wb.save(workbook_path) , there is a prompt stating: 'A file named abc.xlsx' already exists in this location. Do you want to replace it?' I want to overwrite the file immediately without the prompt coming up. According to the docs, wb.save() should automatically overwrite (see: https://docs.xlwings.org/en/v0.6.4/api.html). I have also tried wb.save(workbook_path) but the pop-up still appears. Appreciate any help on this please. p.s. - I am basically try...
Read more

UPSERT syntax error linked to UPDATE in PostgreSQL (python)

Image
1 1 I'm still learning PostgreSQL. During my testing, I have only been using INSERT statement in either psycopg2 and now asyncpg. I now have the need to UPDATE data in my test database, instead of replacing all of it. I'm currently trying to do a simple replacement test in a testing table, before I move to development table with more data. I want to replace any $1 name that is in CONFLICT with a name that is already in the table users. I'm trying the query code, which is passed to the DB via asyncpg. I keep getting a syntax errors, so I'm a little lost on how to correct these errors. What is the proper syntax for this query? '''INSERT INTO users(name, dob) VALUES($1, $2) ON CONFLICT (name) DO UPDATE "users" SET name = 'TEST' W...
Read more

Some classess of my CSS file are not rendering into Django templates (most classess render without problems)

Image
up vote 0 down vote favorite I'm starting with Django, I've been throught this several hours, please help me! on my *.html file I have this code (and more): {% load static %} <link rel="stylesheet" href="{% static 'css/style.css' %}"> and since I added that static file, my page has style.. but some classes don't render, for example this div: <div class="nav-profile-image"> If I delete the class .nav-profile-image from style.css, the page still the same, that image has no container, it's very strange. I uploaded all the app on branch "problems": https://github.com/franchodl/robohome/tree/problems view trying to render: home url for home: http://127.0.0.1:8000/propietario/ template: ./own/templates/own/home.html static files: ./static ...
Read more