1 domain 1 sql but 2 server

[crampz]

Do you think a domain will run with 1 sql but 2 servers/host at the same time?

crampz Reviewed by crampz on 3rd Jan 2011. 1 domain 1 sql but 2 server Do you think a domain will run with 1 sql but 2 servers/host at the same time? Rating: 5

[desiboy]

ya..its possible and its called Mysql Replication .

[crampz]

how? what can i do? or give me a tutorial sir.

[desiboy]

Before trying to implement it , think if you need it or not..you don't need it , unless you have damn big site like FB , etc .
it's like Master and Slave system ..
main uses are to scale your database , and spread the load across multiple slaves and for security.

This is for Replication
http://dev.mysql.com/doc/refman/5.0/...ion-howto.html

[crampz]

sorry desiboy, but i want to use 2 cpanel and 2 same sql in 1 website/domain. This is possible?

[desiboy]

your question is not clear .
do you want to distribute the load on the databse , by hosting it on multiple server ??
or just use database on a different server from a site hosted on different server ??

and what scripting language do you use ?
do you use Vbulletin ??

[crampz]

My Answer is YES for all your questions.
I am using vbulletin forum and i want to run my website on multiple servers.
1 same database 1 domain but 2 hosting. If this possible?

[desiboy]

My Answer is YES for all your questions.
I am using vbulletin forum and i want to run my website on multiple servers.
1 same database 1 domain but 2 hosting. If this possible?

vBulletin has build in features to do this task..

http://www.vbulletin.com/docs/html/main/config.php



setup a database, and allow it to access from the server which has the php files ( take care of firewall ).
and make sure its in same subnet, or expect a heavy lag..

you can put any number of servers you want..you can even host the same php files on multiple server with same domain ( load balancing ). varnish + nginx .
I have done this thing once..but didn't had much advantage because the servers were in different continents ..

just forget this , if you on shared hosting.

[l0calh0st]

Keep it on one server, 2 servers will bring you more work. Its only if you site is huge.

[vizoomer]

yea and you mainly need to create a clutch of the servers to do that

edit:- cluster*