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
6
votes
4 answers

Windows Event Log Performance

Does anybody have an idea how efficient the windows event log is? I have a scenario where many events could be logged every minute. Is the windows event log well optimized to handle large number of events? Would it be comparable to SQL Server for…
Tomasi
  • 201
  • 2
  • 6
6
votes
2 answers

Any way to copy the schema from one MySQL database to another?

I have a MySQL database that contains almost 100 tables. I want to set up N additional MySQL databases on the same server, each running on a different port. And I want each additional database to have the same schema/table structures as the…
Continuation
  • 3,080
  • 5
  • 30
  • 38
6
votes
8 answers

What is the best strategy for detecting database intrusions?

Filesystem intrusions can be detecting using tools such as Snort but it is more difficult to detect intrusions into a database, such as deletion of rows, modification of tables, etc. What is the best way to monitor this to detect unwanted changes in…
davidmytton
  • 666
  • 3
  • 7
  • 17
6
votes
5 answers

Updating a MySQL Database

We have an online system using MySQL database. We need to merge an older backed up database (Full tables, not a dump file) with the current one. Without experiencing any server downtime, how would you do it? Note that the system is online 24/7. What…
Sajal Dutta
  • 613
  • 5
  • 18
6
votes
9 answers

One Database vs. Multiple Databases

I need to design a system which represents multiple "projects", one per client in SQL Server , something similar to StackExchange... same data model, different sites (one per customer). Each project has the same data model, but is independent of all…
Ricardo Sanchez
  • 195
  • 1
  • 6
5
votes
2 answers

Can't go back to root from postgres: forces to enter postgres password which it finds invalid

I've installed postgres on Ubuntu and it switched me to postgres user. I've opened psql created a database and then decided to switch back to root. However, it doesn't allow me: sudo su - results in it asking me [sudo] password for…
parsecer
  • 163
  • 1
  • 8
5
votes
2 answers

MySQL: Is it a security risk to deactivate the setting "bind-address"?

I have had a problem with a webapp connecting properly to a MySQL server and to solve it i tried to comment out the setting bind-address in the file my.ini. That seemed to solve the problem, however i was wondering if that is a nogo regarding…
flixe
  • 153
  • 1
  • 4
5
votes
1 answer

Migrating from DynamoDB to RDS

I'm considering the different options available for migrating a DynamoDB Database to RDS. The data structure makes much more sense in a relational format. There are 8 tables with around 1 million documents in each. We have worked out the mapping…
Peter Grainger
  • 163
  • 1
  • 7
5
votes
1 answer

Where are Azure SQL Database Backups Stored

I've got 5-6 Azure SQL Databases running. They run in the Basic and Standard pricing tiers. From what I've read backups run by default which allow for the Point in Time restore options to work. These are my questions: Where are these backups…
jrd1989
  • 698
  • 15
  • 48
5
votes
1 answer

Does a Galera equivalent for Postgres exist?

I've been working with Galera for a number of months and like the failover along with the redundancy. I've got a Postgres DB that is in testing and will probably move to production. Is there a Galera equivalent for Postgres? I read about "standby"…
Server Fault
  • 3,714
  • 12
  • 54
  • 89
5
votes
1 answer

What does "GC (Allocation Failure)" mean in my ElasticSearch 5.6 logs?

I see these constantly in my Elasticsearch 5.6.3 logs. Is this a signal that I should scale up and add more RAM? Or is this just normal operations for ElasticSearch? [GC (Allocation Failure) [ParNew Desired survivor size 11141120 bytes, new…
Antonius Bloch
  • 4,680
  • 6
  • 29
  • 41
5
votes
2 answers

Is it possible to take a snapshot of a database in Azure?

So, to clarify, I'm aware I could dump the database using tools written for the database that don't know anything about azure. I know I could do an import / export. And I know I could just extend the point-in-time recovery retention period for the…
Parthian Shot
  • 1,165
  • 4
  • 16
  • 32
5
votes
1 answer

Where should I write my database credentials in node.js app?

I'm deploying my node.js app, which is based on Ghost, on Google Compute Engine. However, I'm not sure whether it is a good behavior to write my database credentials in config.js. The config.js file is something like the follows: ... 'production':…
Blaszard
  • 352
  • 2
  • 6
  • 14
5
votes
1 answer

Amazon RDS "Freeable Memory" decreasing rapidly

I have noticed recently that freeable memory on my Amazon RDS (db.m4.large instance) is decreasing rapidly. Over the past few weeks, it has come down rapidly from almost 3700 MB to 1000 MB. There hasn't been any issues with the applications though.…
Rahul
  • 53
  • 1
  • 5
5
votes
3 answers

Where should migrations be run on elasticbeanstalk deployment process?

I'm very curious as to how people run a command like db migrate on their eb apps. If you add it as an .ebextensions I fear that when you have multiple instances for one app, there could be conflicts that occur if multiple servers are trying to run…
ThomasReggi
  • 621
  • 2
  • 10
  • 25
1 2 3
…
99 100