We have datacenter in 3 zone and 3 different url. Connect to database postgres is psql "hostname=url1,url2,url3 \port=......" Yandex understand what is master now and if master with url1 broken, Yandex start using url2 or url3. url2, url3- slave. But in backend we can't pass 3 url. We connect to database with "hostname=url1 \port=......" We have only 1 url and can't using slave. Can we pass 3 url to backend(asp.net core). If database in datacenter1 work correctly - using url1, if datacenter1 broken- using url2 in datacenter2
1
There are 1 best solutions below
Related Questions in ASP.NET
- Implementing Azure AD B2C Authentication in .NET 8 Blazor Project (RenderMode: InteractiveAuto)
- Azure Application Insights Not Displaying Custom Logs for Azure Functions with .NET 8
- IIS Rewrite Module exclude bots but allow GoogleBot
- Angular 16 sending null values to API
- I am the domain admin, newbie, how do I connect youtube.com on my domain?
- Dropdown list showing SQLServer2005SQLBrowserUser$DONSERVER instead of Active Directory group name in ASP.NET MVC C#
- ASP.NET Identity, Losing Ability to Login until Application Pool Recycles
- How to unprotect ASP.NET FormAuthentication cookie
- How does it work using ASP.NET FormAuthentication
- What is the purpose of a completely standalone 'this'?
- Is there a way to read .csproj PropertyGroup variable in c#
- MSBuild trying to copy different dll with similar name into project sporadically
- Minimizing IdentityServer4 Round Trips in Microservice Architecture with Ocelot
- Azure AD guest account in web app authentication user claims data
- Receiving 400 bad request on post when customer auth handler is used
Related Questions in POSTGRESQL
- Only the first SQL script gets executed inside Docker Postgres container
- Compare fields in two tables
- Hibernate ClobJdbcType bindings: what are the diferences?
- Postgres && statement Error in Mybatis Mapper?
- Can this query be optimized? (Choosing a random row to insert, that excludes previously inserted Rows)
- Connection terminated unexpectedly while performing multi row insert using pg-promise
- Processing multiple forms in nodejs and postgresql
- How to copy data from SQLite to postgreSQL?
- PGAdmin4 configured behind a reverse proxy but unable to connect to Postgresql server
- Updates to pgsodium encrypted values don't use specified key_id
- Connecting to Postgres running in a Docker container using psql
- Can't connect to local postgresql server from my docker container
- Django Arrayfield migration to cloud sql (Postgresql) not creating the column
- Get list of matching keywords for each post
- docker-compose can't reset postgresql database
Related Questions in .NET-CORE
- Repository manager receives the wrong connection string in .net core
- How can I overwrite the localization strings in a library
- Custom type resolution
- How to enable log to console Cosmos Client SDK requests
- Issue with Entity Framework Core: .Include() and .AsNoTracking() not displaying expected related entities
- Using Python CDK to bundle dotnet 8 code to AWS Lambda function
- How to make Visual Studio 2022 project launch Windows Terminal instead of PowerShell?
- Custom Metrics stop saving in App Insight after one hour
- How to send select input data for form submission?
- When I use built-in DockerFile in Visual Studio, I see no errors, but when I try to create image and container using terminal I get an error
- Failure to Execute the DBCommand: SQLite Err. 1 - C# / .NET / Entity Framework Core
- KeyCloak Handshake causing timeout
- problemas con los CORS en .net core 7 y angular 15
- Access Registed Scoped Services and Transient Services using GetService()
- .NET Core DB vs JSON model design
Related Questions in MASTER-SLAVE
- STM32 SPI slave doesn't read data correctly and transmits incorrect data
- First mysql docker containers restarting when a second mysql container is started
- Latency when backup becomes primary
- Changing binlog_format in MariaDB slave
- failover-abort-no-good-slave error in Redis-Sentinel auto failover
- Execute a function every 10 ms with also some offset and random jitter
- How does data reading works in redis in terms of master slave server
- Cloudera configuration between Master and Slave Nodes
- How to run two Java versions on same jenkins slave
- how to use redline in jmeter master-slave
- In distributed jmeter load testing, got stuck at 'Waiting for possible shutdown message on port 4445'
- Is any solution related to SparkConnectGrpcException?
- What is the meaning of Slave Offset and how is this term defined in plc programming context?
- How to test load-balancer of MaxScale
- RedBean PHP for master/slave MYSQL databases
Related Questions in YANDEXCLOUD
- CLI using local env instead of it's own
- Can not call API from yandex cloud server, but from local machine it's working fine
- LoadBalancer has EXTERNAL-IP address equal pending
- Supply binary content inside a JSON string via curl
- MlflowException: API request (Caused by ResponseError('too many 503 error responses'))
- Can we pass 3 url to backend(asp.net core, 1 master, 2 slave) appsettins.json have 1 connectionstring yandex cloud? postgresSql master-slave
- How to fix this MongoClient connection?
- How to continue function execution after response is given?
- Add timestamp to name of created VM's instance in bash script
- How to connect in django s3 files storage from yandexcloud?
- Yandex-Tank unable to run JMeter - Unable to access to JMeter executable file or it does not exist
- Granular permissions in Yandex Cloud Object Storage
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
There are two particular FQDN types in Yandex Cloud managed databases that can help you here: one always points to the master, second always points to the least lagging replica.
How does it work? When the master is switching in your managed Postgres cluster, a script goes to the DNS and amends the master pointing FQDN, resolving it into the correct IP. The exact process handles the consistency of the replica pointed FQDN.
You don’t have to pass three hosts. Use the master FQDN instead.
https://cloud.yandex.com/en/docs/managed-postgresql/operations/connect#special-fqdns