handling multiple server

[active]

Hello Everyone,

i have two server and two databases and one domain .
how to handling multiple server for connect to databses .

For Example :
Insert Query in www.MyNameWebSite.com/administrator . this query inserte two databases realtime !

[babis1]

why you want to do something like that  (i don't thing is the solution you want) ? mirror server is something different. also is an expensive but effective strategy

[active]

thank you for reply
my domain is 4 DNS and 2 DNS = server 1 , 2 dns = server 2 .

how to use insert contents ( For example ) and query in two databases ?
can i use two connection string and all query run into two server ?
thx

why you want to do something like that  (i don't thing is the solution you want) ? mirror server is something different. also is an expensive but effective strategy

[datahell]

You need a mysql cluster.

http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster.html
http://www.mysql.com/products/cluster/