How do database servers work?

Hi, I tried to read about databases, but I didn%26#039;t find it much help. How can a server like Apache(running on your computer) still work when you shutdown? Can other computers still recieve that information when your server/computer is shutdown? Would the database work? Would I need to buy a server dedicated to that? or contact web host that sells server space? is that the better option?

Woah, that is a lot of questions. I guess I%26#039;ll need to read a whole lot more about databases. I just usually give up because I don%26#039;t understand how a database can still work if the server is down, especially if the server is running on my computer. Maybe I got it wrong and they just install Apache to test if the database works. Please help!

How do database servers work?

****till work when you shutdown?

If you want to have a database server you have to sure that your pc is on always. Otherwise your server will not serve when your pc is off line. Apache is not a db server. It is a HTTP(web) server.

****server/computer is shutdown?

You cannot receive any information when your server/computer is shutdown. DB will not work at that time.

buy a server dedicated to that?

If you are running the db server you need a dedicated ip for that. So it is better to give that job to a hosting company like www.blazonhosting.com. They do it for low cost.

You can run several servers in one pc(web server, mail server, DB server, file server). But running several servers in one pc leads to slow your pc%26#039;s perfomences. Then it will slow down the the servers.

If you want more help or details contact. I m a webmaster too...

------More about the DB server----

A database server is a computer program that provides database services to other computer programs or computers, as defined by the client-server model. The term may also refer to a computer dedicated to running such a program. Database management systems frequently provide database server functionality, and some DBMS%26#039;s (e.g., MySQL) rely exclusively on the client-server model for database access.

Database Master servers are central and main locations of data while Database Slave servers are synchronized backups of the master acting as proxies.

How do database servers work?

If the computer is shutdown, none of the services will respond. For something small scale, I would look for a shared webhosting company that offers DB and webspace. Maybe look for one that comes with a control panel like cPanel or Plesk. Those can be very useful, especially if you are still learning.

Other Replys:You must be able to have some sort of an interface that can pull out data from a database (i.e. website). Depending on the action taken on the website, for instance, browsing categories on an e-commerce website, the system will submit a query to the server which in return will pull out data from the database. This could be a price of a product, description, model number and many other variables.

While dedicated servers are a much better option, they are quite expensive. Shared databases are an affordable solution which works great as well.

If the server that contains the database is down, you will not be able to submit queries and pull out data.

Oren.

http://www.arielwebdesign.com

Other Replys:%26gt; How can a server like Apache(running on your computer) still work when you shutdown?

It won%26#039;t. But what does Apache have to do with databases? It%26#039;s a HTTP server. Not a database server.

%26gt; Can other computers still recieve that information when your server/computer is shutdown?

No. If your computer is shutdown, so are any servers on your computer.

%26gt; Would I need to buy a server dedicated to that?

For high performance yes. If you want a 24/7 server, don%26#039;t run one off your personal computer. If you want a good performing server, don%26#039;t run it off your personal computer.

%26gt; or contact web host that sells server space?

You need to be clear about the difference between a database server and an HTTP server. A database server is for a database. An HTTP server serves webpages. A webpage may incorporate information taken from a database. That%26#039;s right, you would need two servers then. Or more, depending on the complexity of your setup.

%26gt; I guess I%26#039;ll need to read a whole lot more about databases.

And about web servers and architecture in general.

%26gt; I don%26#039;t understand how a database can still work if the server is down, especially if the server is running on my computer

It can%26#039;t. Where did you get this idea from?

%26gt; Maybe I got it wrong and they just install Apache to test if the database works

Except Apache is not a database server. Where did you get this idea from?

Other Replys:You can E-mail me if you want to actually have a conversation about this. That%26#039;s alot of questions though. If the database server is on your local computer and you shut it down, you will not be able to acces the data on it. If you get a webhost like http://www.doggydomains.com and put your database on their server you will be able to acces it any time.