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
4
votes
1 answer

Regarding High Availability for MSSQL Server

Already used in MySQL : Real Time Replication (synchronization) between primary and secondary server is done using master and slave commands. So What is the equivalent feature for MsSQL. Which Replication method should be used for real time…
darshan doshi
  • 51
  • 3
4
votes
1 answer

MSSQL: Restore a DB to the latest file in a backup set

I have a MSSQL 2008R2 DB in SIMPLE recovery mode that is periodically backed up with BACKUP DATABASE MyDB to DISK = 'Z:\MyDB.cbak' WITH COMPRESSION This runs periodically, creating multiple backups sets in the file. I want to restore the latest…
DrStalker
  • 6,946
  • 24
  • 79
  • 107
4
votes
2 answers

Database (MySQL) and SSD lifetime - "lot" of writes to DB

In company where I work we started using SSD for our internal 3 GB MySQL database Difference in perfomance is HUGE, which is great. What I am worried about is lifetime of SSD Writes to DB are perfomed 24hrs/7days, very few reads. Should I be worried…
Peter
  • 167
  • 1
  • 3
  • 16
4
votes
2 answers

Large lag on mysql replication (Relay_Log_Pos and Exec_Master_Log_Pos does not increase)

Today my two slave's (one mysql 5.1 and second MariaDB 5.5, master is mysql 5.1) started lagging. Similar situation are quite often with lags rises to even 10000 seconds, because slaves have worse hardware configuration then master but now I'm…
B14D3
  • 5,188
  • 15
  • 64
  • 83
4
votes
3 answers

Store Cron Jobs into a database

In order to build a system to maintain thousands of cron jobs on a Linux system, I'm facing the problem of being able to handle them in a scalable way. I need to use a database (I was thinking of using MySQL) for storing the jobs instead of default…
eldblz
  • 385
  • 2
  • 11
  • 21
4
votes
3 answers

Backup MySQL databases in 1 file but with separated .tar.gz for each db

I'm now using this in cron to backup all my databases in 1 sql.gz file: 0 0 * * * root mysqldump -u root -pPASSWORD --all-databases | gzip > /home/backup/db/`date +\%G-\%m-\%d`_db.sql.gz I'd like to have one .tar.gz file within whom X…
MultiformeIngegno
  • 1,687
  • 9
  • 26
  • 31
4
votes
1 answer

Is it safe to modify innodb_data_file_path value for mysql 5?

I recently experienced data corruption after changing the value of this parameter in my.cnf from : innodb_data_file_path = ibdata1:10M:autoextend:max:128M to : innodb_data_file_path = ibdata1:10M:autoextend:max:256M I am not completely sure this…
drcelus
  • 1,254
  • 4
  • 14
  • 28
4
votes
8 answers

MS SQL Layout for best performance

We have purchased a new server to act as a MS SQL backend. I am curious to know what the best setup would be for it. The server is a Dell R710 it has 6 hard drives 2x 74GB 15k and 4x 146GB 15k This is currently setup in a RAID 1/Raid10…
ITGuy24
  • 1,576
  • 1
  • 15
  • 29
4
votes
8 answers

Good beginners books on databases?

I am looking for recommendations on database books. Ideally, I would like a book spending no more than 1/4 covering the basics of the abstract / theoretical stuff, and then delves into the practical aspects. If the relevant "Dummies book" is good,…
JDelage
  • 211
  • 1
  • 4
  • 9
4
votes
7 answers

Should databases containing customer information go in a DMZ?

We're deploying a simple newsletter webapp on a stand-alone LAMP platform in the company DMZ. There is some discussion as to whether the MySQL server should be removed from the DMZ and put in the internal network. The server is behind a firewall…
paul
  • 181
  • 1
  • 7
4
votes
2 answers

informix + Fatal error in shared memory creation

please advice how to solve this problem I have linux with informix DB its fail on - Fatal error in shared memory creation su - informix -sh-2.05b$ oninit -v ONCONFIG /usr/informix/etc/onconfig.active is not owned by user with id 4000. …
Eytan
  • 611
  • 6
  • 13
  • 27
4
votes
1 answer

What's the advantage of splitting a mysql table into smaller ones without physical distribution?

I've seen such design in my company. A big mysql table is split into tens of smaller ones of identical schema on the same server in the same db, without any physical distribution, no innodb_file_per_table, no partitioning, etc. The data is…
Arrix
  • 235
  • 1
  • 5
4
votes
2 answers

Where do I start re: my physical application server moving to virtual machines?

My company develops, among other things, a Linux database and application server. The database backend is Sybase ASA. We treat it as a walled garden in order to help keep our support and test loads low. We have a lot of customers asking us to make…
JesseDyer
  • 153
  • 7
4
votes
2 answers

Log the error and warning while restoring the sql dump on MySql

How to log the error and warning while restoring the SQL dump on MySQL ? Following are the steps we were doing. mysql> CREATE DATABASE dbname; mysql> USE dbname; mysql> SOURCE dbdumpname.sql
Aha
  • 409
  • 3
  • 8
  • 18
4
votes
3 answers

What hardware & software consideration does a major website require to properly manage 1000+ servers?

Sorry for such a high level question. I understand the basics of server load balancing, but the concept of managing 30,000 servers is a bit foreign to me. Is it really just the same concept of balancing 2 or 3 servers scaled up 10,000 times? How…
Jonathan Coe
  • 391
  • 1
  • 3
  • 11
1 2 3
…
99 100