symfony2 multiple database

2
votes

i use symfony2 with FOSuserBundle.

i need 2 database connections one for Usermanagement and another remote database connection.

how can i use them simultaneously?

can parameters.ini file have double database params? sth like this

[parameters] database_driver="pdo_mysql"
database_host="localhost"
database_port=""
database_name="symfony"
database_user="root"
database_password=""
database2_driver="pdo_mysql"
database2_host="remote_ip"
database2_port=""
database2_name="symfonydb2"
database2_user="root"
database2_password=""

1
symfonyparametersfosuserbundlemultiple-databases
Did you check this link? symfony.com/doc/current/cookbook/doctrine/… – Víctor B.

1 Answers

2
votes

To answer your questions:

how can i use them simultaneously?

Like @vbergae said, just take a look at How to work with Multiple Entity Managers

can parameters.ini file have double database params?

For sure, you'll just have to reference in your config file it like this:

  • %database2_driver%
  • %database2_host%
  • %database2_port%
  • %database2_name%
  • %database2_user%
  • %database2_password%