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
0
votes
3 answers

Migrating from Oracle to Netezza and trying to see what datatype differences there are

I am going to be working on a migration of Oracle DW to Netezza, and I need to understand if there are any major "gotchas" with data types, etc.
Bob
0
votes
4 answers

Choosing the right computer for MySQL database

I have a 6 years old computer (WinXP) working as MySQL database server. Finally decided to invest on a new computer to replace this old one but do not know what do I need to focus to have the best performance. What is better processor speed, dual…
Gerardo Abdo
0
votes
0 answers

Configuring database alarms for and AWS RDS datbase

I'm using an AWS RDS MySQL 8.0db.t3.micro 100GB DB for an app and am trying to determine the best alarms to set (the Laravel application is served through Vapor and through their UI, you can receive notifications if there are database spikes). Is…
Eric
  • 111
  • 1
0
votes
0 answers

Secure external database access from AWS application

Today we have a solution whose infrastructure is entirely hosted on AWS. Among other things, there is an API (API Gateway + lambda) which communicates with a database through a VPC to VPC connection secured with Security Groups and database…
Maxime Rossini
  • 241
  • 3
  • 8
0
votes
1 answer

Proxy or gateway between application and database server

We are going through implementing ISO 27001 processes we have a requirement of having a proxy server between the application and database server, can someone suggest an architecture and tools to use?
Pawan
  • 123
  • 1
  • 5
0
votes
0 answers

How to configure Azure Data Factory to handle larger files?

I have an azure data factory pipeline that reads a 100 mb CSV from blob storage and inserts it into an Azure SQL DB that has tons of space (200 GB). I also have a 1 MB version of the same files, just with most of the data removed, as a test…
SeaQwell
  • 1
0
votes
0 answers

What is the efficient way to copy large database from one server to another?

I have a SQL server's full database backup job that runs daily at night. Currently, I need to stay up late every night to copy that backup file (around 300GB in size) to 5 servers in different locations over the Internet via FTP. I use FileZilla but…
Parkeralex
  • 1
  • 1
0
votes
0 answers

SQL DB failing to send server email - intermittent

Recently, we noticed an issue in SASS 2014 logs regarding the failure of some emails to send: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2023-06-29T11:20:17). Exception Message:…
Gytis Varnelis
  • 1
0
votes
0 answers

could not load private key asn.1 decoding failure Navicat

I have a Problem with my Navicat when i want to connect with a SSh-Key to our Company Servers i cant because Navicat give the folloing Error: could not load private key asn.1 decoding failure Has anyone an Idea what is going on?
Marvin Fratzke
  • 1
  • 1
0
votes
0 answers

Creating a non-public DNS alias for a database in Google Cloud Platform (GCP)

I am currently working on setting up a database in Google Cloud Platform (GCP), and I would like to create a non-public DNS alias for it. The purpose of this alias is to provide a more user-friendly name for accessing the database internally within…
Isla Yoder
  • 1
0
votes
1 answer

How to add a new database on replication?

I have a mysql replication with two servers. There are actually 3 databases on it. On master : server-id = 1 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 4 max_binlog_size = 1G bind-address …
erwann le guevedec
  • 1
0
votes
0 answers

How to see what is my Amazon elastic beanstalk rds password?

How can I retrieve the database password for my Elastic Beanstalk environment running on the "Aurora MySQL" engine? I have an IAM user with the necessary permissions to manage the application, but I couldn't find the password in the Secret Manager…
Muzamel Saleem
  • 1
  • 1
0
votes
0 answers

Openstack DB issues

Had a power issue and my openstack will not fully come up. It is showing that I have VM's but from 5 years ago and not recent ones. I need help bringing it up. I am running an OLD version of the software. +-----------------+-------+ | Field …
ebarak
  • 1
0
votes
1 answer

Mariadb creates a subprocess after crash

We recently had a crash on our Mariadb server (10.6.5) on a Debian 9 VM. The process was restarted without error but now there's a second mariadb process like so : mysql 26718 5.1 42.4 15062644 12788308 ? Ssl Apr13 61:53…
Ror
  • 321
  • 3
  • 16
0
votes
1 answer

Apache Ignite - Automatic Cluster Snapshot Create / Restore Procedure

When trying the Apache Ignite cluster snapshot procedure (snapshot create, restore), the restore operation is not successful. Before the restore procedure, we have destroyed the cache which we want to restore (according to the official…
cookie_marsh
  • 1
  • 2
1 2 3
…
99 100