[Solutioning] Access the Databases with dynamic IP

[vivek-kumar-pandey]

Is your feature request related to a problem? Please describe. Accessing the staging or production databases becomes problematic when using an ISP with dynamic IP addresses. The current reliance on IP whitelisting for secure access poses challenges when IPs frequently change, making it difficult to maintain consistent and secure connectivity. As the IP whitelisting is working for us so far, so we haven’t invested in these alternatives. Since Gourab is facing issues due to this dynamic IP, we can come up with some solutions to fix it

Describe the solution you'd like Implement a solution that ensures secure and consistent access to Google Cloud SQL databases, even in environments with dynamic IP addresses. Try with

• Cloud SQL Proxy

Describe alternatives you've considered

• None

Additional context NA

Acceptance Criteria

• [ ] The implemented solution should provide secure access to Google Cloud SQL databases.
• [ ] The solution must be capable of accommodating dynamic IP addresses without compromising security.
• [ ] For production environments, the solution should be secure, such as IP whitelisting or equivalent measures.
• [ ] The solution should be well-documented to facilitate easy implementation and maintenance.

Documentation Add whatever documentation will be required here.

[thebelrobot]

I have tried the approach but this did not help me much as I have ISP infrastructure limitations too. So, I have purchased a static IP from ISP to find the easiest solution.

But for the understanding of my setup process, I am going to take up a story to write a step by step documentation on the same in next sprints.

[Satendra-SR]

@thebelrobot let's keep this open as the action items are not achieved yet and we decided to work on this anyhow. Reopening it

[Satendra-SR]

Deprioritising it for now