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

SQL Server Developer Edition versus SQL Server Standard

not sure I understand this but I am going to throw my assumption out there: SQL Server 2008 Standard & Enterprises editions are for running full database services on server (not just but for comparative sake), and SQL Server Developer Edition is…
Justin
  • 189
  • 1
  • 8
3
votes
2 answers

Use ansible initialize postgresql multiple times

Make this task will work the first time: - name: Initialize the Database command: /usr/pgsql-9.6/bin/postgresql96-setup initdb If run it a second time, will get the error: fatal: [192.168.0.1]: FAILED! => {"changed": true, "cmd":…
rawmain
  • 291
  • 1
  • 7
  • 17
3
votes
1 answer

MariaDB on docker keeps corrupting data

I'm using the official MariaDB mariadb:10.4.6-bionic image and I have a problem: my tables corrupt themselves. This had happened at least four times this month: on two different dev machines using docker-compose on the staging machine using docker…
Nicolas Reynis
  • 141
  • 3
3
votes
3 answers

MySQL backup and restore with views

I am having trouble getting mysql backups to run properly when their are views in the database. I think this might have something to do with needing a placeholder object for it. In any event I run this command: mysqldump -u myuser -pmypassword…
Codezy
  • 103
  • 1
  • 7
3
votes
0 answers

How to access database on Docker swarm without exposing ports to internet?

I had a really hard time coming up with a short and descriptive title for this... Let me explain: In classic Docker (no swarm mode) I had my system set up in a way that my PostgreSQL database would expose its main port (5432) only to localhost. That…
MadMonkey
  • 295
  • 1
  • 2
  • 8
3
votes
2 answers

AWS Database Migration Service requires a role not mentioned in documentation

I am trying to perform a database migration using AWS Database Migration Service (DMS) from a self-managed database on EC2 to AWS RDS. I get this message when I try to run the task to perform the migration. dms-access-for-tasks IAM Role not…
A Ahmed
  • 31
  • 1
  • 1
  • 4
3
votes
2 answers

Nosql autoscaling of compute

Most of the nosql autoscaling faces issue due to the fact the data have to be migrated during peak load. What if data is stored in a shared storage like CLVM which has less overhead(compared to NFS or shared file system). Now if each bucket/shard is…
kalyan
  • 249
  • 1
  • 3
  • 11
3
votes
1 answer

AWS EB and RDS: Invalid storage size for engine name mysql and storage type gp2

I'm trying to deploy my (python/django) application to AWS Elastic Beanstalk, but I am getting the error. Deployments have been working fine for the last few months, so I'm confused what could be the cause. Here's the error: ERROR: Updating RDS…
Deven
  • 133
  • 1
  • 1
  • 4
3
votes
1 answer

Installed Mysql on Debian, but got another database On Debian (MariaDB)

I used the same setup for Nginx server environment for Ubuntu 16.04 on Debian 9.3 but on Debian my database is MariaDB instead Mysql. apt-get install nginx python-certbot-nginx mysql-server php-fpm php-mysql -y I understand that's the default…
Arcticooling
  • 1
  • 3
  • 7
  • 22
3
votes
1 answer

Expandable Storage

I am developing a web application service and am looking to scale our internal servers. Our current server has ~1TB of storage capacity. Users create ~10gb of data which is added to our database daily. As you can see at our current rate, we would…
Gordon
  • 31
  • 4
3
votes
2 answers

Debugging mysql too many connections problem

I get a "too many connections" error from time to time with my mysql database, if I do a show status like 'Conn%'; I get a result like this +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Connections | 291 |…
mzehrer
  • 133
  • 1
  • 5
3
votes
5 answers

How do I restore to a SQL backup I made two days ago?

Database disasters only happen to other people, right? RIGHT?!? I'm sure this has never happened to anyone since the beginning of computer history, but, believe it or not, I'm having a problem with a database restore. Perhaps you can help. I'm…
Jason
  • 247
  • 2
  • 9
3
votes
0 answers

Determining Rails max threads and database pool size using Puma and NGINX

I noticed the default pool size for a Rails 5 App using Puma is equal to: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %> Which means that you can establish a max number of threads as an environment variable or it will default to 5 database…
Jorge Cuevas
  • 131
  • 3
3
votes
7 answers

My database using sql server 2005 express is over 4GB, I have no money, am I screwed?

Any thoughts of how to solve this? I tried creating another database and putting some tables there, but actually there is just 1 big table with almost 3 million rows, this table is using all the space, so separating tables is useless. I though…
sergiogx
  • 335
  • 3
  • 15
3
votes
1 answer

Cassandra tmpdir change location

Cassandra is failing to start if /tmp is set as noexec, which is pretty much default these days: java.lang.NoClassDefFoundError: Could not initialize class com.sun.jna.Native at…
Vladimir
  • 321
  • 1
  • 12
1 2 3
…
99 100