So I can create a multi-tenant database connection pool for multiple databases. Basically, I want to create an instance-level connection pool (not create a connection pool for each database) and ask the connection for a specific database and access the database on request
I have a database available in AWS RDS with the Multi-AZ function. I also tested the failover to understand that it was working. But my doubt is this:
- During the failure of the primary database, the secondary database is increased as the primary database. So what happens to the previous primary database? Will it be restarted and placed as secondary?
- If it restarts, there is only one instance during that period and what if it also fails?
- Also what are the conditions of failure. Or just consider AWS
I spoke to a small bank CTO. It has 4 different heterogeneous legacy databases that need to be updated when a mortgage rate changes, which is obviously a problem.
What solutions does the DBA community have to solve this problem?
Is there a script What can be done to notify you of DB problems (connection, crash, status, no session, etc.) without necessarily warning or scheduling jobs in SQL Server 2012?
If so, I would be happy if you can share.
Suppose you have a missing children's database of hundreds of thousands of photos and you want to query those photos with one that a user is uploading. How would something like that work? Do you compare one by one until you find an image that matches more than 90%?