Is there an advantage to putting the database on a separate database server?

1 Answer

Answer :

answer:It depends on how much traffic you have and how data-intensive it is. Also, read-only requests are a lot lighter on resources than read-write. At the extremes, say you are running eBay or Amazon.com – that requires separate servers. And if you get a few thousand hits a day, it probably works just as well either way. Obviously the distance between those extremes is immense, and you have to figure out where your application is. If your site is smaller, you could combine them and you would know pretty soon if you needed a second server. If you make the web application modular, changing the data source later is pretty easy.

Related questions

Description : Where can I learn quickly the differences between using SQL Server 2008 and Toad for Oracle?

Last Answer : answer:The SQL code IS different. Oracle and SQL Server syntax can differ from the ANSI version of SQL. For example, when you write a JOIN in SQL, you MUST use the OUTER JOIN ON syntax, where ... can also use the Query Builder to write queries for you by dragging and dropping - just like Access.

Description : How to solve this problem I have with a restore (backup) file I made in SQL Server 2008?

Last Answer : try to see if you have volume optimization enabled, it prevents certain changes from happening and really gives the user a hell of alot more trouble than it is worth.

Description : When to use stored procedure and when function in SQL Server 2008?

Last Answer : There’s no technically right answer here – I think I’d do the SP calling SP.

Description : Will using .NET 3.5 server side for a web site place any notable restrictions on what web browers can use the site?

Last Answer : .NET 3.5 VSTS feature won’t restrict you on any navigation features.VSTS is solely browser independent.You could publish your site on any browser, but you need to do some customization while using firefox.Some addin features are needed to make your Server side setup function properly.

Description : Can I force my Fedora Server to send an email when booted?

Last Answer : Yes. It’s fairly straightforward, too. But what you might want to do is register with a dynamic DNS service like dyndns.org and use something like ddclient to update that automatically.

Description : Free PHP Web Server for Dreamweaver?

Last Answer : answer:This is probably your best bet for getting PHP, Apache, and MySQL running easily. http://www.apachefriends.org/en/xampp.html It works well on most operating systems. I can't help with Dreamweaver ... add that xampp runs on your computer. No need for a external server. It is great for testing.

Description : What is a web server ?

Last Answer : A web server is a special kind of hardware and software that can be used to understand any data stored on that server that can be accessed via the Internet.

Description : Empty entries in a mysql/php5 site database,... why?

Last Answer : How are you migrating the database? What are you using to export and import?

Description : How do I create a simple program that will pull information from a database, insert it into a few formulas, and spit out the answers?

Last Answer : answer:Welcome to Fluther. I have only the vaguest notion of the survey that you're trying to accomplish, but I do understand data. What will serve you very well for this is a ... simple enough exercise, which will only get more complex as your understanding improves and your needs increase.

Description : What are the most important components of a database ?

Last Answer : There are 3 most important components of a database. Namely - data , fields , and records.

Description : Am I putting myself at an advantage, or disadvantage, by posting my "for sale" items in this format, rather than the way most people sell their stuff on Facebook?

Last Answer : Your photobucket is awkward and difficult to see you are selling something. It took me longer than a buyer is willing to take to find the right arrow at the bottom of the page. And who looks for ... searches. And, you can post the ad over multiple locations (Kansas City, Wichita, Topeka, Lawrence).

Description : What is the advantage to putting a wind farm off shore?

Last Answer : answer:More continuous winds that are not disrupted by the land mass. In Hawaii, it would make sense for a wind farm to be one the north, windward side of the island, not the southern leeward side of the island.

Description : What is advantage of putting a telescope in space?

Last Answer : Telescope is an instrument that helps to see lovely object. Hubble telescope can produce clear images of astronomical objects which are very far from the earth.

Description : Which statement is true about a bare metal hypervisor? A. It can only be hosted on an existing operating system. B. It requires a separate license for the native operating system. C ... system. D. It runs directly on server hardware to provide virtual machines with timesharing resources.

Last Answer : It runs directly on server hardware to provide virtual machines with timesharing resources.

Description : Which of the following describes a relational database? 1) It provides a relationship between integers 2) It consists of separate tables or related data 3) It retrieves data related to its queries 4) It provides a relationship between floats

Last Answer : 2) It consists of separate tables or related data

Description : Points to resolve corruption of SQL server database?

Last Answer : Often the corruption for the SQL server database can't be resolved. And the best thing one can do is just roll over the past backup. And by that there is going to be certain amount of the data loss. But you have to make use of that instead of losing everything.

Description : What are the different modes of mounting a Database with the Parallel Server ?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.

Description : Applications such as a Web server or database server that can run on a virtual machine image are referred to as ______________ a) virtual server b) virtual appliances c) machine imaging d) all of the mentioned

Last Answer : virtual appliances

Description : Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based ... and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Last Answer : Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content

Description : Applications such as a Web server or database server that can run on a virtual machine image are referred to as ______________ a) virtual server b) virtual appliances c) machine imaging d) all of the mentioned

Last Answer : virtual appliances

Description : Applications such as a Web server or database server that can run on a virtual machine image are referred to as ______________ a) virtual server b) virtual appliances c) machine imaging d) all of the mentioned

Last Answer : virtual appliances

Description : Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based ... and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Last Answer : Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content

Description : What do you need to restore report server database on another machine?

Last Answer : SSRS Encryption key

Description : What are the different modes of mounting a Database with the Parallel Server?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is ... parallel mode, other instances that are started in parallel mode can also mount the database.

Description : Which instances of an SAP system require a running database during their startup? Note: there are 2 correct answered to this question. ? A. Java Central Services Instance B. Additional Application Server Instance C.ABAP Central Services Instance D. Primary Application Server Instance

Last Answer : B. Additional Application Server Instance

Description : Consider an SAP system based on AS ABAP How many monitoring segments are used for the CCMS Monitoring Infrastructure? A. There is one monitoring segment for each host B. There is ... segment for each application server D. There is one monitoring segment for each central services instance

Last Answer : A. There is one monitoring segment for each host

Description : Ingres is a ........................ A) Socket B) Compiler C) Database D) Web server

Last Answer : C) Database

Description : In order to run JSP .................... is required. A) Mail Server B) Applet viewer C) Java Web Server D) Database connection

Last Answer : C) Java Web Server

Description : State whether true or false. i) Multithreading is useful for application that perform a number of essentially independent tasks that do not be serialized. ii) An example of multithreading is a database server that listens for ... B) i-True, ii-True C) i-False, ii-True D) i-False, ii-False

Last Answer : B) i-True, ii-True

Description : Which of the following is/are the Database server functions? i) Data management ii) Transaction management iii) Compile queries iv) Query optimization A) i, ii, and iv only B) i, ii and iii only C) ii, iii and iv only D) All i, ii, iii, and iv

Last Answer : A) i, ii, and iv only

Description : The reasons leading to popularity of client-server systems are: A) More powerful workstations on LANs B) Needed for graphical user interfaces of end users. C) Remove computing load for presentation services from the system managing a shared database resource. D) All

Last Answer : D) All

Description : Which one is not a server level threat? a. Malicious code b. CGI threats c. Database threats d. Buffer overflows

Last Answer : a. Malicious code

Description : Distance vector routing algorithm is a dynamic routing algorithm. The routing tables in distance vector routing algorithm are updated ........... (1) automatically (2) by server (3) by exchanging information with neighbour nodes. (4) with back up database

Last Answer : Answer: 3

Description : Explain client/server database system. 

Last Answer : 1. It has two logical parts client and server.  2. Computer networking allows some task to be executed on a server system and some tasks on client system. This leads to development ... as application server to receive and send requests from client machine to database server and vice versa.

Description : Salesforce SDK uninstallation from XCode?

Last Answer : Too many variables – only you know your code, how it was written, and how extensible (or not) it was in the first place. I assume you have been to the Saleforce API and SDK pages.

Description : Is there a program where you can identify music in a specific website?

Last Answer : Need Answer

Description : What is a good programming language to make a multiple choice quiz?

Last Answer : Google classroom should work.

Description : Is there a website that shows all the English words, idioms, etc ever invented, including archaic, unofficial, and newest words that have just been invented?

Last Answer : The problem with such a lexicon would be that there have been a lot of slang, dialect, idioms, and unofficial words that 99% of people have never heard of. Besides that, the English language is ... pretty good vocabulary. Hopefully, someone will recommend some. I am unable to do this at the moment.

Description : How can I add HTML markup to this ajax result?

Last Answer : Need Answer

Description : Function or application allowing me to connect or disconnect wifi?

Last Answer : Some routers - Belkins and older Ciscos, had an app that would allow you to remotely-control your router from your phone. You didn't say what kind of router you have, so it's hard to guess. You can ... . Bottom line - you can do this easily if you have a wifi-based power switch and an app. example

Description : How can I become advanced in javascript in 2 months?

Last Answer : Study hard…work hard!!!

Description : Can you help fix this programming problem in Python?

Last Answer : You can’t treat arrays of digits as a single number. The easiest way to read a numeric string is to use the sys library to read a line from the keyboard. import sys print(“Enter value for mass”) mass = sys.stdin.readline() mass = float(mass)

Description : What's the best book for understanding Unity 2D?

Last Answer : Are you a beginner programmer in general, or just new to Unity? That would make a big difference in how I would respond.

Description : Programmers: Is this puzzle a "named problem?" and can you help me with it?

Last Answer : I'd call it enumerating a list of all combinations . There's a field of math called combinatorics which I did not study but I assume probably has a word for this. It doesn't seem like a puzzle ... each iteration, and tweak it to get the output format you want, but that's essentially it, I think.

Description : How do you get the link posted and not the updated page?

Last Answer : You don't have control over it. The URL that you referred to today is pointing to a page that is housed at a server somewhere else. It isn't under your control or Fluther's - it is under the control of ... a month or a year ago. Summary: it isn't under your control. You get the page they send you.

Description : I'm looking for a IT Project Idea for my Final Year. Can anyone suggest something?

Last Answer : How to maintain a question and answer site with trolls, spammers, and questions that violate the guidelines?

Description : How can i improve my skill sets?

Last Answer : You didn't say what you already know, but my main recommendation for something to learn is Python. It's a great learning language, it's free and easy to install, there are great ... and relatively easily. https://www.python.org/about/gettingstarted/ https://www.programiz.com/python-programming

Description : What should I study in order to write/program a career search software?

Last Answer : More programming. And logic. You need to understand how to develop a search for terms, and then also determine where to search, and then how to optimize search results in a relational database.

Description : Is it on all smartphones you can't post a link?

Last Answer : I can’t cut and paste easily with a smart phone. I could type the link by hand. I would have to write it to a pen and paper first and it would work. If I really need too I could boot up my new chrome book and make a link.

Description : How much work does it take to change on a program, from "Monday to Sunday" to whichever 7 days in a row?

Last Answer : It would depend on the individual program.