Questions tagged [database]

Question 1

I just installed MariaDB on a brand new Ubuntu 24.04 LTS server, and most online configuration tutorials suggest I run mariadb-secure-installation right after installation, otherwise my database ...

Question 2

By default, SlickStack installs MySQL locally and connects WordPress to a localhost database. I want to skip that, and connect to a remote (managed) database server instead... What is the proper way ...

Question 3

I'm trying to import a full database dump using impdp into a different Oracle 19c (Standard Edition 2) environment, but the REMAP_DATAFILE parameter doesn't seem to be working. My goal is to import a ...

Question 4

I run SQL Server instance on Docker, using the command: docker run -d --rm -e "TZ=Europe/Rome" -e MSSQL_COLLATION=Latin1_General_CI_AS --name sql_server -e 'encrypt=disable' -e 'ACCEPT_EULA=...

Question 5

I need to install Oracle Database 12c on my local machine, but I’m unable to find a working download link. The official Oracle website seems to have removed or restricted access to older versions. I’...

Question 6

I had a WordPress site built in xampp and my machine crashed. I was able to recover the htdocs and database folder for the website. The DB folder has all the .frm/.ibd files along, with a .opt file. ...

Question 7

So this is the situation. I had xampp on my work computer. I was building a new website and the machine crashed. We were able to recover the main DB which has both the .frm and .ibd files. We also ...

Question 8

We are running pgpool II with three PostgreSQL DBs - one main and two replicas. The env is running in k8s deployed with bitnami postgresql-ha helm chart. The pgpool II configuration is as follows: We ...

Question 9

MariaDB 10.3 I am investigating a Wordpress / Woocommerce installation, which is quite slow. I threw the slow log into ChatGPT, which suggested adding indexes to the status column of the ...

Question 10

After many attempts I was able to restart a badly corrupted db by adding innodb_force_recovery = 6 to my.ini However now, I am unable to start the server at all unless that line is permanently in the ...

Question 11

I have a problem with connecting to my DB while Wireguard VPN is activated. The problem appears both when the DB is on my machine (localhost) and when it's a machine on the same network (using the ...

Question 12

I'm aware this is a common issue, but none of the other posts helped me solve our issue (1, 2, 3, 4, 5, 6 ). I installed mariadb using an ansible as part of an openstack installation, and it crashed ...

Question 13

My Laravel(hosted on EC2) app database(Mysql) is hosted in AWS RDS it was working fine but now it gives the error "SQLSTATE[HY000] [1130] Host '172...***' is not allowed to connect to this MySQL ...

Question 14

During an unattended installation of Oracle Database 19.3.0 on Windows 10, the following error occurs: "SEVERE: PRCZ-1082 : Failed to add Windows user or Windows group "REG-XSPY-NUM12$" ...

Question 15

I’m running a WordPress site on a server with AlmaLinux 9 and cPanel. The site itself is fast, but the admin panel is very slow. When I check the server using htop, I see php-cgi processes consuming ...

Question 16

My question is about system design (and not solving a technical hurdle), but it's nonetheless quite specific. I currently have an application storing big chunks of data in text files. The context of ...

Question 17

I have a website in Arabic, and the website was displaying unreadable characters like Ø±Ø³Ø§Ø¦Ù„. I managed to fix the issue by changing the settings in MariaDB 10.6.19. character_set_client ...

Question 18

I have Test MariaDb 10.6 database installed in our DEV server. I set a test analytics database on it, just to TEST how an application's built-in monitoring would work (and it worked). But, due to the ...

Question 19

I am trying to install a zabbix proxy 4.4 using the installation manual: commands used for installation: #wget https://repo.zabbix.com/zabbix/4.4/ubuntu/pool/main/z/zabbix-release/zabbix-release_4.4-1+...

Question 20

macOS Sonoma 14.2.1 (23C71), just updated to 14.5 (23F79) Story I had a python script (norgis ALKIS-Import) importing a lot of Data into my Postgres Database over the weekend. When I came back today ...

Question 21

Given is a Windows desktop application (written in Java) that communicates directly with a DBMS (SQL). There is no service layer between the desktop application and the DBMS. How can one secure the ...

Question 22

I run MSSQL as a statefulset on Kubernetes (I use the official docker image) I wrote a startup script that should restore $n backups on $n databases. my problem is: first database gets restored ...

Question 23

My "MySQL" instance on a dedicated server decided to update by itself. Automatic updates should be beneficial for security reasons, but in this case the Database collapsed. A few months ago ...

Question 24

Can someone please advise me what could be the cause of this condition? I have a Rook Ceph cluster on which MySQL database with 3x replication is stored. This database is used by me for development ...

Question 25

I have 200TBs of PDF files(~800K), 100MB each on average, to be stored in MongoDB(GRIDFS). It is the cloud provider's policy to store PDFs in MongoDB Database only. I need guidance regarding MongoDB ...

Question 26

In the Windows Event Viewer application, I see a record that the maximum memory value of SQL Server is reduced by 99%. After this process, we could not access the database from anywhere. How can we ...

Question 27

This morning our aurora mysql serverless 2 spiked and basically locked up. We have a writer/reader and a reader associated with the cluster. On the reader we had an intense select query. This is the ...

Question 28

To enable sql trace under Oracle you would typically run the following via sqlplus after login: ALTER SESSION SET SQL_TRACE=TRUE On Oracle 19 RDS this results in the following: Error report - ORA-...

Question 29

Trying to install the BILicense Service for Sage X3 SEI (Sage Enterprise Intelligence) on a Windows 2019 server. This is a prerequisite before installing SEI for Sage X3. Straight out of the gate it ...

Question 30

I have an e-com store running on WordPress (Together with using WooCommerce) - We've operated the site for around 4 years now, and in that time, our website has grown heavily in sales and customer ...

Question 31

I'm using Oracle Cloud Infrastructure. I have a VM instance with Ubuntu-22.04-Minimal. Apache, PHP, and OCI8 are all installed and working. When I try to connect to the database I get: Warning: ...

Question 32

I developed a Java Spring Boot application with a PostgreSQL database. Since the data being processed is quite a lot, the processing can take time and it uses a lot of CPU (e.g. up to 100% obviously). ...

Question 33

I've got a ridiculously small table in MySQL that consists of four rows of data. Updating this table is taking a long time, often upwards of 50 seconds. CREATE TABLE log_CacheQueueEntity ( ID int(11)...

Question 34

We have recently switched 1 of our 3 clusters from Elasticsearch to OpenSearch. The cluster is receiving data into 30+ data streams and the data is searchable in Dashboards using index patterns etc. ...

Question 35

I am trying to save some money by utilizing Azure SQL Elastic Pools. I have a bunch of databases which only peak in usage once a while, so having them in a pool would be optimal. The problem now is ...

Question 36

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 ...

Question 37

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?

Question 38

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 ...

Question 39

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 ...

Question 40

I am using Mysql - Server version: 8.0.29 MySQL Community Server - GPL My server has 100GB RAM. Of it I allocated innodb_buffer_pool_size as 90 GB SET GLOBAL innodb_buffer_pool_size = 96636764160; I ...

Question 41

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 ...

Question 42

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 ...

Question 43

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 ...

Question 44

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 ...

Question 45

I am trying to make my own mail service using Postfix, but I run into an issue in the setup phase, and it's that postfix can't connect to the database. Here's what the error log says: ⛔Database ...

Question 46

So here's our use case: We have firmware that connects to server (simple php file - that takes post request) and add the data (350-500 bytes per request) to database. Now here's a issue we have 3k ...

Question 47

Even if I found many old questions around this topic, I'm still unable to connect to a mysql database remotely. Beside my own specific issue I'd like to point out what are my doubts, in hope to serve ...

Question 48

Haproxy load balancer - I configured 2 different domain SSL certificates and get a conflict. For example I have two domains api.xxx.com and api.yyy.com. If try to get api.xxx.com its showing yyy cert ...

Question 49

I'm setting up a new database server which I intend to use as a backend for many services. Each of these services generally only care about a single database in the system, so I'd like to isolate the ...

Question 50

In order to improve our security posture, we changed several dozen internal applications over to using a new username and password to access an AS400 database a few months back. However, there is some ...