inserting in multiple servers

[eluser]akioshin[/eluser]
hello again guys how can i insert,update,search,delete on multiple servers?

i mean if in the main server im inserting values in the database i also want this values on the second server so i was just wondering how can i do this, how can i insert to servers at the same time hope you guys can help me with this problem

[eluser]Fero[/eluser]
You can specify 2 databases and do every query twice.

[eluser]akioshin[/eluser]
thanks for the reply fero,i'm a newbie at this can you please tell me how? i always have this database error
A Database Error Occurred

Unable to connect to your database server using the provided settings.

[eluser]Las3r[/eluser]
That's either a wrong config (user+password) or firewall blockade.

You need to set up different databases in database.php in the /application/config folder , this works just fine.

Erik.

[eluser]drewbee[/eluser]
If you are replicating data IE one database is simply used as back up, it is far more proficient to do replication rather then double queries.

Best to let the database handle the duties it was designed to do. This cuts back on code, as well as performance.

http://dev.mysql.com/doc/refman/5.0/en/replication.html

http://www.howtoforge.com/mysql_database_replication

[eluser]rogierb[/eluser]
Don't forget to setup a user per IP your request are comming form.
So on your db servers, user 'username' is allowed form IP xx.xxx.xx.xxx and xxx.yyy.xxx.xx