multiple mysql connections

[mohd...@gmail.com]

How can i setup multiple mysql database connections in frapi and how to call it

[David Coallier]

You would have to create a model that manages the creation of those connections then your actions would use the defined model.

On 13 December 2012 02:52, <mohd...@gmail.com> wrote:

How can i setup multiple mysql database connections in frapi and how to call it

--
David Coallier

[Louie Miranda]

Hi,

Posting the answer to help other frapi dev's as well. It's a bit of a hack. But, it works anyway for your needs. Especially, if you want MASTER/SLAVE access.

MASTER

- Insert/Updates

SLAVE

- Read only

So, on your model.

Class, Custom_Model_User

// Normal DB Model

$this->db = Frapi_Database::getInstance(); // LIVE DB

Class, Custom_Model_Slave

// Slave DB Model

$this->db = new PDO('mysql:host=localhost;dbname=frapi2', 'frapi2', 'frapi2'); // SLAVE DB

Hope this helps.

Regards,

Louie