Elxis CMS Forum

Support => Database => Topic started by: active on June 28, 2011, 22:53:50

Title: handling multiple server
Post by: active on June 28, 2011, 22:53:50

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 ! ???

Title: Re: handling multiple server
Post by: babis1 on June 28, 2011, 23:11:59

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

Title: Re: handling multiple server
Post by: active on June 28, 2011, 23:18:26

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

Quote from: babis1 on June 28, 2011, 23:11:59

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

Title: Re: handling multiple server
Post by: datahell on June 30, 2011, 21:19:30

You need a mysql cluster.

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