database on seperate server

hi,

is it possible to setup a database server seperatley and a file server in a config file or what changes are needed for this?

my thoughts were to setup a vps for the site, another for the database serve and another for the file server.

mabe another for the actual site and setup round robin dns, i have looked at documentation about a cluster but i did not see anything about where to specify the database server where can this be done?

thanks again

ummm not sure personally however I'm sure this is what some of the larger sites like Facebook etc would have set up!

Thousands of servers and databases working together to achieve whats required  .... ?

Yes you can. The database settings are in inc/header.inc.php

However these servers should be linked together via a gigabit ethernet or higher fiber link. If they are not, then the servers will not be able to transfer data back and forth fast enough to make this method worth it.

thanks for the responses.

deano92964 • can it only work if they are on the same network then?  my thoughts were you could setup say 3 servers maybe on ec2.

one database server, the other two identical sites but just both pointing to the database server with load balancing in place in front of the two web servers, is this not possible?

does it not just store the files and database in one place in the code? i cannot see any documentation on this so thought might be best to ask on here to guys who have been running and experience with it.  any help appreciated.

thanks again

For performance it's best they be on the same network. If mysql has to fetch data via an internet link it will hurt performance. Reason is there is latency and also it is not a fast as a lan network link. So it's best not to do it that way.

The files can reside on different servers as well. Some of the paths are in inc/header.inc.php and those that are not in there it's just a matter of replacing a folder name with a network link.

But again. If the servers are not part of a very high-speed local area network then there is no point in doing it. You would be better off with increasing computer power. Servers are available with 4 sockets per board and CPU's are available with 16 cores now. So in theory you can set up a single server with 64 cores. Max out the memory and go for the fastest hard drives. The hard drives will be your bottleneck.

For data that is rarely accessed then a separate server accessed via an internet link is fine. But when speed is required then they must be linked via a lan or you will be disappointed with the performance.

hi,

can someone please show how i can update my dolphin website database with my old different website database.
what i mean is i want members on my old non-dolphin website to login without creating an account.can it be possible please i would be glad to be helped thank you.

thanks again deano92964 •

just read so much on here about performance issues i was thinking a multiple server setup would be best, with ec2 i think you maybe able to have them link on same lan but i will check it out with the guys over there.

so hard drive space is the main issue?

i have read about installing

eAccelerator

or other like this, have you experience in doing this and did it work for you or what optimization is best for to tune apchae to get the most out of dolphin?

i dont want my site to grow quick and get a bad name because it crashed after so many connections at once?

i have read also about version 7.1 however this talk was a year or two ago, is this happening still and will it be faster or is it faster now than what it was a year or so ago in 7.0.9?

again i appreciate your help and guidance mate.

No. Not the space. The speed of the drive. On low end servers the CPU and memory is the bottleneck. On highend multi core servers the harddrive becomes the bottle neck as it becomes the slowest part of the computer. So SATA II 10000 RPM or SCSI 15000 RPM drives are recommend which are currently the fastest on the market.

eAccelerator is no longer a caching engine as of the latest versions. I have it installed but did not notice much of a performace gain. Most of my gain in performace was when i increased memory, number of cores on the processor and tweeked mysql database performance per this docs. http://www.boonex.com/trac/dolphin/wiki/HostingServerSetupRecommendations

Dolphin does perform better now than in past versions. And should continue to improve.

Just make sure you tweek database performace and go with a decent server.

thanks deano92964•                         

i was thinking either dedicated or vps, possibly vps to begin with then upgrading.

si is there any php/apache tuning tools you could recommend?

thanks again for the help.

also does boonex have access to my site? i.e. Call home" for license checking so they some how have access to the system on my server?

thanks again

 No. I am not aware of any tools. I looked, could not find any.

No. You have it backwards. The call home means dolphin checks to see of your licence is valid. Your copy of dolphin queries their server not the other way around. Thats all. It's nothing. All software that has licensing does this. It is a perfectly normal procedure.

thanks again deano.  so they cant access anything else on my system? member details etc, dont want people signing up and getting spammed from other sites that boonex has took their emails? that is all.

thanks again, i read the hosting setup recomendations, and says about tuning mysql and using a php cache so i will try folowing this setup as the results looked better when running with this, is this what you have found?

i was going to start with a vps, 2 cores running 2.93ghz, 2gb ram and 50gb hard drive to begin with then scale up if needed.  the vps at the data centre are on the same network so if i wanted to add a seperate database server then speed should not be an issue i am told by the provider?

thanks again for your help and i am sure i will be purchasing some of your mods that i have looked at also.

cheers