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

Query database in Cloud Platform / PaaS {AWS, Azure, GCP} from outside the platform/PaaS?

Is it generally possible to query a database housed in PaaS "A" from a request originating in a different PaaS "B" (or does it depend on the PaaS)? Asked in another way: Can an app that is hosted in PaaS "B" make a query to a database housed in…
cellepo
  • 125
  • 8
2
votes
3 answers

How to restore the SQL Server model database?

Since a few days ago, when I try to start the SQL Server service, it fails with the following error logged to the NT Application Log: An error occurred during recovery, preventing the database 'model' (database ID 3) from restarting. Diagnose…
Christoph Rüegg
  • 145
  • 2
  • 6
2
votes
1 answer

How do I backup a database to a .sql statement?

How do I backup a database to a single SQL file? After it's backed up, how can I load it/restore the database with InnoDB? It must be InnoDB.
Alex
  • 8,471
  • 26
  • 75
  • 99
2
votes
6 answers

MySQL replication out of sync

I have a master-master replication system. However, due to an auto-increment issue, I got an error in replication...and it stopped replicating. Someone told me to do: stop slave; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; start slave; It didn't work.…
Alex
  • 8,471
  • 26
  • 75
  • 99
2
votes
0 answers

How to associate existing RDS instance to Elastic Beanstalk, with the right storage size?

I found the post How to associate an existing RDS instance to an Elastic Beanstalk environment? and tried to associate my existing RDS instance to Elastic Beanstalk by following it: First, creating a manual snapshot from my existing RDS instance,…
Jorge Orpinel Pérez
  • 121
  • 4
2
votes
2 answers

strange raw device perfromance on Aerospike ASD 3.15.1.4

I have a cluster of 4 servers. One of the namespaces is raw device based. The devices reside on a SAS mechanical hard drive. Now here is the weird part of the story. I am running one of the tests with small records (2x50 bytes = 100 bytes total). I…
Boris Epstein
  • 75
  • 5
2
votes
1 answer

Azure cosmosDB incredibly poor performance

I have a mongoDB on Azure cosmos and the performance is horrible. I have below the time for a few requests that my app does on startup and as you can see Mlab is up to 150 times faster! I am using the free sandbox database on Mlab and the D1 shared…
Pier-Olivier Marquis
  • 121
  • 1
  • 5
2
votes
1 answer

"Requested registry access is not allowed." Powershell

I'm trying to find database size of DC which is located in NTDS service. My script is: $Computer = "abe.com" $Reg = [Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey('LocalMachine', $computer) …
Ender
  • 614
  • 3
  • 9
  • 14
2
votes
1 answer

Azure elastic database pool storage limit briefly drops to zero

Yesterday and today I my azure web app experienced bunch of timeouts and 502's for few minutes. While investigating I found out that database storage limit and storage used dropped to zero at that time. Application (one app, many databases) was not…
PTwr
  • 123
  • 5
2
votes
1 answer

Are the limitations of SQL Server Express the bottleneck?

Question: What is the best way to determine whether the limitations of SQL Server Express are the bottleneck in an environment? Are there some performance counters that would be a good indication for example? Would some of the information within SQL…
dbr
  • 1,852
  • 3
  • 23
  • 38
2
votes
1 answer

Google Cloud SQL / App Engine concurrency limits

I've been using Google App Engine to host my APIs and keep banging up against the limitation of concurrent database connections. The docs say that you can only have up to 12 concurrent connections per "app engine instance"…
Dan
  • 21
  • 1
2
votes
0 answers

pg_restore changing object owner not working ,

I just try the solution found here : https://stackoverflow.com/questions/31469008/postgresql-backup-database-and-restore-on-different-owner And I still have an error on the inexistent object owner. What I do: pg_dump -F c -f fnam.sql.tgz -h…
Plup
  • 161
  • 1
  • 7
2
votes
1 answer

Create a database for scalability

I know this sounds like a programming question which means it should be on stackoverflow but i believe server admins worry about this more and i am not looking for just the programming answer to this question. How do i create a database for…
user274
2
votes
1 answer

How can I restart a server and connect it to an existing cluster?

I have three Nginx servers + php7 + memcache + Cluster Galera + Mariadb + Monit. Everything works and all three are connected. But if I now want to edit the my.cnf file to play the utilized RAM or the number of connections. I can not get that single…
Tarrio
  • 41
  • 1
  • 1
  • 4
2
votes
2 answers

Creating postgres tablespace permission denied even though owned by postgres

I have been trying to create a tablespace in postgresql 9.5 and I have been consistently getting issues with permission denied. I have finally decided I'm going to create a directory in / just to see if I could get anything to work but with no luck…
csteifel
  • 293
  • 1
  • 6
  • 11
1 2 3
…
99 100