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

downloading a big database (postgres) to a local copy

I have a pretty big postgres DB on Amazon RDS (about 9GB when zipped), and sometimes we need to copy it and do some tests on it on our local machines. Doing a DB dump (pg_dump) and downloading it is simply too slow and honestly been just getting…
Ronen Ness
  • 169
  • 9
3
votes
0 answers

postgresql invalid command \

When trying to import an .out file back into a postgres database, I get many (thousands) of rows like this: psql:G:/Backup/main_db_backup.out:251875: invalid command \ With a different number where "251875" is each line Does this mean the restore…
SLipman
  • 31
  • 1
  • 2
3
votes
1 answer

Galera cluster - cannot start MariaDB (CentOS7)

I'm trying to install a Galera cluster with 3 mariadb VM's (all of them CentOS 7). I've never done this before, so I was following this guide: http://tunnelix.com/mariadb-galera-cluster-installation/ The problem is that after I enter my settings on…
João Santos
  • 39
  • 3
3
votes
3 answers

VMware ESXi: Pause process of VM (for allowing NFS storage to restart), any side effects on databases, AD, special cases?

Situation: On an integrated All-In-One ESXi/ZFS-Storage server, where the storage VM uses bare metal disks and exports the filesystems via NFS (or iSCSI) back to ESXi, which uses it as pool storage for the other VMs, there exists a problem when time…
user121391
  • 2,502
  • 13
  • 31
3
votes
0 answers

How to handle point in time restore without binlogs/How to split database

I thought about this 3 days already and asked in IRC but I wanna consult your expertise too. Basically it is about a High Traffic Site that uses Drupal (don't get me started, I have no choice in this matter). Drupal does some very not so smart…
pdanjou
  • 65
  • 3
3
votes
1 answer

Is it possible to determine what content database a deleted SharePoint site collection existed in?

The situation is going to come up when somebody deletes their site colleciton and wants it to be restored. But how can we tell what content database the site was in so that we can restore from a database backup?
Jim
  • 1,555
  • 7
  • 25
  • 30
3
votes
1 answer

Recover mysql database innodb 'table doesn't exist'

Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd. I've tried the innodb-force-recovery on all levels 1 to 6 and a whole lot of other…
FabioG
  • 81
  • 1
  • 1
  • 5
3
votes
1 answer

Apache Spark infrastructure - combining compute and storage nodes

I have an infrastructure question around Apache Spark, which I'm looking at rolling out in a greenfield project with (at most) approximately 4 TB of data used for modelling at any given time. Application domain will be analytics, and training of the…
analystic
  • 141
  • 2
3
votes
2 answers

Storing changes to multiple databases in a single centralized database

The setup: multiple MySQL databases at different locations with the same scheme. The databases are in production. The motivation: we want to present information in these databases in a web interface, clearly showing which database the row originated…
B4x
3
votes
2 answers

Should we move our database to our (shared) web host?

The company I work for has been using an Access database for the past eight or so years (I've only had to put up with it for five). We're beginning work on an online ordering system so it's about time (actually, well past time) to move on to…
Cogwheel
  • 135
  • 4
3
votes
1 answer

Is it unusual for a database client to install the server's SSL certificate?

We use Amazon RDS for our databases at work. Recently we got an automated email from Amazon stating they'd be updating the SSL certificates and that if we didn't upgrade our database instances within X amount of time, they would cease to function.…
soapergem
  • 719
  • 4
  • 13
  • 29
3
votes
4 answers

Mainframe performance

I am working for an insurance company with about 180 employees. About half of these employees register something in their Claims system (sales, consulting services, claims handling etc.). The core system is written in Cobol and runs on a mainframe.…
David
  • 447
  • 1
  • 5
  • 11
3
votes
1 answer

How can postfix hash: databases be replaced by static: or inline:?

What is the syntax to replace a postfix hash-Database, for example domain.tld PREPEND my-header: foobar with a static map? docs define it as Example: "inline:{ key=value, { key = text with whitespace or comma }}". Several ways to replace it seemed…
allo
  • 1,620
  • 2
  • 22
  • 39
3
votes
1 answer

mongodb keep looping while trying to sync data

I'm converting my my standalone mongodb into a replica set. I've added one more member (and I want to add two more members later, and to shutdown the primary server). My primary mongodb is running 2.2.3, and the new replica member running the latest…
Dor
  • 43
  • 5
3
votes
1 answer

How does fail2ban 0.9 database storage actually works?

Fail2ban 0.9 introduce database storage to save bans on restart. But I can't find out the actual mechanism of it work. There is dbpurgeage parameter which controls lifetime of old bans, defaults to 24 hours. As I see from code research, fail2ban…
user196318
1 2 3
…
99 100