Questions tagged [database]

System that handles large amounts of data in an organised fashion

Filter by
Sorted by
Tagged with
1 vote
1 answer
39 views

Why did our AWS Aurora RDS spike and lock up?

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 ...
Harpua's user avatar
  • 83
0 votes
0 answers
30 views

PostgreSQL + Removing old Host from DB not succeeded

We have HDP cluster with 152 workers machines - worker1.duplex.com .. worker152.duplex.com , While all machines are installed on RHEL 7.9 version We are trying to delete the last host - worker152....
King David's user avatar
0 votes
0 answers
13 views

Share WHM Mysql Database Between to cpanel [closed]

i have WHM Server. where i have multiple c panels and multiple domains. Cpanel1 is connected to my.domain1.com Cpanel2 is connected to my.domain2.com Cpanel3 is connected to my.domain3.com on Cpanel1 ...
Aftab Amin's user avatar
1 vote
0 answers
22 views

How to enable SQL trace for AWS Oracle RDS

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-...
Craig's user avatar
  • 11
0 votes
1 answer
32 views

Unable to install Nectari's BILicense Server software on Windows Server

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 ...
YDY's user avatar
  • 21
-1 votes
0 answers
32 views

Why managed DBs costs more than plain VMs?

I tried to create a database cluster at Digital Ocean (I am sure that everything else works similarly at other cloud providers, Digital Ocean is just an example here). I select the most basics plan, ...
Валерий Герасимов's user avatar
1 vote
0 answers
48 views

Large WordPress E-Com Site - Very slow performance (High volume of Post Meta data and Order Data)

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 ...
Jayjay95's user avatar
0 votes
0 answers
10 views

Why restoring a partial backup is overwriting my whole Google Cloud database?

I have two projects in Firebase/Google Cloud, one for Development and another for Production (where the app is live). Steps I took I exported a specific collection from the database of my Production ...
Fernando Claros de Luna's user avatar
0 votes
1 answer
130 views

Connecting to Oracle Autonomous Database with PHP and OCI8

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: ...
Harley's user avatar
  • 101
0 votes
2 answers
87 views

Issues with VPS provider limiting CPU usage with data processing Spring Boot application

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). ...
BullyWiiPlaza's user avatar
0 votes
1 answer
134 views

MySQL Update Statement taking long time to update small table with 4 rows

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)...
LinuxGnut's user avatar
  • 217
1 vote
1 answer
72 views

Logged in users cannot store visualizations within their OpenSearch tenant space

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. ...
Mogget's user avatar
  • 111
0 votes
1 answer
363 views

Azure SQL Elastic Pool max size lower than max size of database included in pool

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 ...
Stephan's user avatar
0 votes
0 answers
19 views

Unable to enable Singlestore studio in Singlestore kubernetes operator

I deployed a singlestore test cluster using the documentation from https://docs.singlestore.com/db/v7.3/deploy/kubernetes/ on AWS. The deployment was successful, and I managed to get the cluster up ...
sethu2912's user avatar
0 votes
0 answers
170 views

Inconsistent Clickhouse database query performance

Folks, Clickhouse Server version: 22.8.21 (have tried a variety of 22.x and 23.x versions as supported by clickhouse-backup to restore my data with for testing, none seemed to improve the query ...
gwvandesteeg's user avatar
0 votes
0 answers
25 views

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 ...
Eric's user avatar
  • 113
0 votes
0 answers
57 views

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 ...
Maxime Rossini's user avatar
0 votes
1 answer
69 views

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's user avatar
  • 123
0 votes
0 answers
27 views

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 ...
SeaQwell's user avatar
0 votes
0 answers
193 views

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 ...
Parkeralex's user avatar
0 votes
0 answers
108 views

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 ...
Gytis Varnelis's user avatar
0 votes
0 answers
201 views

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 ...
Marvin Fratzke's user avatar
-1 votes
1 answer
553 views

Mysql server eating all RAM (100GB) when load is running

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 ...
santhosh's user avatar
  • 103
0 votes
0 answers
181 views

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 ...
Isla Yoder's user avatar
0 votes
1 answer
131 views

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 ...
erwann le guevedec's user avatar
0 votes
0 answers
305 views

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 ...
Muzamel Saleem's user avatar
0 votes
0 answers
50 views

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 ...
ebarak's user avatar
  • 1
0 votes
1 answer
132 views

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 ...
Ror's user avatar
  • 323
0 votes
1 answer
221 views

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 ...
cookie_marsh's user avatar
0 votes
0 answers
45 views

InfluxDB influxQL v1.8 : Wrong timestamp used for writing to database

I wrote a bash script for inserting the summary of the daily energy database "xxx_d" into the monthly database "xxx_m" - triggered on every 1st day of the month at 02 o'clock by a ...
6a5h4's user avatar
  • 1
0 votes
1 answer
678 views

Postfixadmin can't connect to mysql database (MariaDB)

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 ...
swegbarca's user avatar
0 votes
0 answers
27 views

How to handle scaling upto 3k concurrent connections [duplicate]

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 ...
Shamsudeen McHalwai's user avatar
0 votes
0 answers
310 views

Undestanding how to connect remotely to a Mysql database

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 ...
Kay's user avatar
  • 1
1 vote
0 answers
87 views

Haproxy 2 domain ssl crt conflit

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 ...
robin's user avatar
  • 11
2 votes
1 answer
2k views

How do I give a postgres user all privileges to a specific database?

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 ...
slondr's user avatar
  • 121
0 votes
1 answer
46 views

What's a good approach to finding the source application that's attempting to access a database with an incorrect password?

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 ...
tnk479's user avatar
  • 113
0 votes
1 answer
2k views

HAProxy and postgres

My haproxy configuration is as below, in the backend there is pg_autoctl cluster, another VM (bunty4) hosts the monitor and haproxy is installed on it. global maxconn 100 defaults log global ...
uozzyy's user avatar
  • 33
0 votes
2 answers
46 views

What database my applications will use if I have a locally installed database beside it's pod running on local Kubernetes?

I have installed mysql on my Ubuntu machine. I also have a locally running Kubernetes and deployed a mysql deployment on Kubernetes and can reach to that using kubectl exec -it mysql-b4769786-5hf4m sh ...
best_of_man's user avatar
0 votes
1 answer
405 views

How to upgrade a MariaDB database to utf8mb4_unicode_ci?

I have a Drupal 9.4.8 website a MariaDB database and phpMyAdmin. My website is already active with data in its 220 MB database. How to upgrade a MariaDB database to utf8mb4_unicode_ci ? Here is my ...
Mathieu's user avatar
0 votes
0 answers
421 views

zabbix connection to external database

0 I am trying to setup zabbix with two database , one on localhost and another on diffrent machine. zabbix server: 192.168.0.100 external database :192.168.0.154 I setup zabbix with localhostdatabaase ...
biplab 's user avatar
0 votes
0 answers
150 views

How to expose multiple databases in local network for other applications to connect with them

I am following up this question here, in which I made the incorrect assumption of being able to access a database using HTTP. Because I seem to lack conceptual knowledge, I would like to ask a more ...
linus's user avatar
  • 101
0 votes
1 answer
60 views

does it benefit if split multiple sites into multiple database in shared hosting env?

I have been wondering this for long time let's say I run a server where I hosted 2 PHP sites , they are both heavy on database query server is multi-core , let's say 4 core 8 thread with bunch of RAM ...
qtwrk's user avatar
  • 176
0 votes
2 answers
937 views

How to calculate log per second?

I have a log management system in which the Clickhouse database has been used alongside metrico/qryn, rsyslog on all the servers (Debian 11) send gathered logs from the system and applications to ...
Sinux's user avatar
  • 95
0 votes
1 answer
122 views

LOAD BLOB COLUMN INSTEAD OF FILE

Is there a way to load data from blob column instead of file like LOAD DATA FROM (SELECT A.B FROM A) INTO TABLE TEMP FIELDS TERMINATED BY ' ' ENCLOSED BY '"' LINES TERMINATED BY '\n' instead of ...
HARI's user avatar
  • 11
1 vote
0 answers
582 views

Postgresql - Master\Slave Async Replication - How to quickly fail back and forth?

I have two hosts set up as very simple master\slave. All servers connect to the floating IP 10.1.1.10. Host A: Designation: Master Floating IP - 10.1.1.10 Standard IP - 10.1.1.11 relevant pg_hba....
NOC_Ninja982134's user avatar
2 votes
1 answer
798 views

Azure SQL Elastic Pool: increase data size max GB with no downtime

We have an Azure SQL elastic pool with a data size max GB setting. We would like to increase this setting to a larger value. The question is: can you increase the size of the elastic pool max size ...
A X's user avatar
  • 519
0 votes
0 answers
1k views

ERROR 2003 (HY000): Can't connect to MySQL server on '1.2.3.4' (10060)

I've tried to look for a solution and there are many similar questions but somehow none of the solutions are working. I have a laravel app running on one of my ubuntu servers at 1.2.3.4 IP. I ...
Afifa's user avatar
  • 1
-1 votes
1 answer
3k views

Mysql is not starting in UBUNTU 20.4

Mysql fails to start in UBUNTU 20.4. i have no idea what the issue is. Almost i tried everything. nothing worked. sudo journalctl -u mysql.service -n 100 ------------------------------------------ ...
Seeking solution's user avatar
1 vote
2 answers
401 views

Connect Access 2016 to remote SQL Server - SQL Server Error 17

Good morning, I am trying to connect to a SQL server from a remote machine, with ACCESS 2016, using the "External data" option. Both are on the same network. It is important to note that I ...
Andy McRae's user avatar
0 votes
1 answer
405 views

mysql crashes when accessing database after upgrade from 5.5 to 5.7

After upgrading mysql from 5.5 to 5.7, one of innodb databases seems corrupted. mysqldump -u root -p mydatabase > mydatabase.sql Enter password: mysqldump: Error: 'Lost connection to MySQL server ...
peter's user avatar
  • 113

1
2 3 4 5
34