Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database]

System that handles large amounts of data in an organised fashion

A database is a system of handling and organising large amounts of data that can be easily created, reference or edited.

SQL (Structured Query Language) is a database computer language that is designed for managing the data in a relational database management system.

Some popular database systems include:

  • FileMaker Pro
  • IBM DB2
  • Microsoft Access
  • MySQL
  • Microsoft SQL Server
1684 questions
8
votes
2 answers

How to Link an SQL Server 2008 Server to an SQLite Server?

I want to "Link" an SQLite server with an SQL Server 2008 server. E.g. using the sp_addlinkedserver command. How do I do this? I have searched far and wide, but found no solution for this problem. The closest attempt I have found is…
user48962
  • 181
  • 1
  • 3
7
votes
3 answers

Is a MySQL database a viable alternative to LDAP?

(Apologies if I'm asking the wrong kind of question or in the wrong place.) We run IT for our association (all volunteers). We have got a server with member database in OpenLDAP, mail server, ftp and a bunch of homemade web-applications. Most of…
Roberto
  • 193
  • 1
  • 9
7
votes
11 answers

Which database servers are not interrupted by server reboots? (Clusters?)

We have been asked to deliver a system where the central database server continues its operations, even when applying security updates to the server's operating system or to the database server software. As far as I see it, this includes security…
Lars D
  • 282
  • 2
  • 16
7
votes
4 answers

Is MySQL required on both the database server and the webserver? why?

Is MySQL required on both the MySQL database server and the web server that it is connecting to? If it is required on both the web server and database server, please explain why this is. Moreover, if it is required on both, is it required or…
AnchovyLegend
  • 187
  • 1
  • 7
7
votes
3 answers

Dell SSD options and 3rd party SSDs in Dell hardware

Anyone have any experience with Dell's SSDs? We're looking at using them for a machine running a key value database like Tokyo Tyrant. They're expensive as well as being pretty small. Only 25/50GB for $850/$1700. Is there any magic to them that…
Nathan Milford
  • 792
  • 2
  • 10
  • 21
7
votes
5 answers

How can I tell if an Oracle database is mounted and activated?

IANADBA, but I'm writing a script that will take action as long as the oracle standby database hasn't been activated. What I'm looking for is two queries (or sets of queries, if necessary). 1 - Is the database mounted (as in, has someone done…
Matt Simmons
  • 20,396
  • 10
  • 68
  • 116
7
votes
2 answers

Does anyone have any experience when it comes to speed of Amazon RDS vs MySQL on a Small server?

EC2 Small vs Amazon RDS - which is faster for MySQL? (I have one database, well-indexed and tuned. About 10,000 rows on each table.) How's the performance like?
Alex
  • 8,471
  • 26
  • 75
  • 99
7
votes
8 answers

Should I ever DELETE (SQL and DB) anything?

I am curious, should I ever delete anything? Right now I am building a site (for myself) which allows you to subscribe to users which you then receive a message every time the user has upload content. Or comments, if there is a thread and someone…
user274
7
votes
6 answers

iSCSI for databases, good idea

Is it a good idea to have a transactional database running on a server that uses iSCSI? They main argument is that you can have two servers accessing the same disk array, so if one server breaks the other one can kick in an do the work. So I have…
Franz Kafka
  • 237
  • 3
  • 12
7
votes
4 answers

Is MySQL Good Enough for Large Scale?

My question is probably fairly common, but I wanted to ask it anyway. When choosing a database type for large scale application (social networking, for example), is MySQL able to handle it? I mean, hundreds of thousands, if not millions of…
dcolumbus
  • 475
  • 1
  • 5
  • 10
7
votes
3 answers

Is the community MySQL safe for production use?

Or Will I need to get the enterprise version? This is because I found this on MySQL's site: If you are running a MySQL production level system, we would like to direct your attention to the product description of MySQL Enterprise Edition…
n_kips
  • 205
  • 1
  • 2
  • 5
7
votes
4 answers

How to find the next generated value for a auto-increment column?

I face some trouble with IBM DB2's auto-increment columns. At first, all my columns were defined as GENERATED ALWAYS, but since I had trouble with this when using the "db2 import ..." command, I changed them to GENERATED BY DEFAULT. This is…
Tim Büthe
  • 352
  • 2
  • 5
  • 16
7
votes
1 answer

Can I specify where my database files are stored *per database* in MySQL?

Is it possible to have two databases hosted on a single MySQL instance, but have the files stored in two different physical locations? For example: db1 stored in: C:/ProgramData/MySQL/MySQL Server 5.1/Data/ db2 stored in: E:/MySQL/MoreData/ I know…
Rob Sobers
  • 333
  • 1
  • 4
  • 13
7
votes
4 answers

postgreSQL vs Cassandra vs MongoDB vs Voldemort?

Which database to decide upon? Any comparisions? Existing: postgresql Issues Not easily scalable horizontal. Needs sharding etc Clustering does not solve the data growth problem Looking for: Any database that is easily horizontally scalable …
Ram on Rails
  • 209
  • 2
  • 5
6
votes
3 answers

How do I set the default table type as innodb in my.cnf?

For mysql...is there a way to set it so that every table that gets created is innodb?
Alex
  • 8,471
  • 26
  • 75
  • 99
1 2 3
…
99 100