Connecting two different databases

Well, you'd need to create two services in your DI. It's just that if any component relies on existance of 'db' component, your code might not work as desired, i.e. Models. But in Phalcon everything can be overriden.

can you please share the code example if possible to elaborate your answer.

Well, you'd need to create two services in your DI. It's just that if any component relies on existance of 'db' component, your code might not work as desired, i.e. Models. But in Phalcon everything can be overriden.

/**

• Database connection is created based in the parameters defined in the configuration file
• NOTE: The mysql libraries and PDO will automatically use Unix sockets if the host is defined as 'localhost'.
• To force TCP/IP you need to set an IP address 127.0.0.1 in config.ini, which doesn't make sense on a same box, it needs to be changed to a real IPv4 where MySQL instance is hosted remotely. */

$di->setShared('db', function () use ($config) {
    $dbConfig = $config->database->toArray();
    //set your DB as usual....
    }

$di->setShared('dbAudit', function () use ($config) { //this is used for Audit purposes i.e. only inserts
    $dbConfig = $config->databaseAudit->toArray();
    //set your DB as usual....
    }