How to use the new database connection methods

We’ve seen some fairly major changes to the database functionality so I want to check the best practices for setting up connections to make sure I’m doing things correctly.

Let’s assume I have a hosting server which allows a connection to the MySQL database via localhost. If I want to connect directly to that database from my computer then I have a different set of login credentials but my app wants to use localhost when live.

Should I create two connections in globals, one via localhost and one via the IP address? Would this give me the ability to use the Database Manager fully as it’s using the IP connection but still use localhost when live?

Could someone explain the methods and best approaches to this?