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?

 

[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/en/replication-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?

 

[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*

 

[crampz]

Sorry im just confused.

 

[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

[SLIDE]http://i.imgur.com/JmLyk.png[/SLIDE]

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 <3 .
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.

 

[ajinkya9]

Use Cloud Hosting> See this link
http://mediatemple.net/webhosting/cx/

• Load Balancing
• Moving to bigger boxes only goes so far. Scale across servers with a load balancing solution designed for your application.

 

[crampz]

Thank you guys, i wont do it anymore.

 

[McGrhill]

Quite possible. Its called as "distributed database".

But I guess u don't need to do this unless ur site is bigger one like wbb.

 

[cyber.crime]

You must give access to one server to Remote database you can found it in Cpanel
this about Remote Database i can't explain you, found it in google about Remote database articles