Questions tagged [database]
System that handles large amounts of data in an organised fashion
1,692
questions
0
votes
0
answers
14
views
Rsyslog is not saving logs from different networks correctly
I am trying to set up rsyslog server, that would save the logs into database. I coded web app easily maintain and search through logs. But I have multiple networks there (not at home, but in work ...
0
votes
1
answer
26
views
sql server max memory change event viewer log
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 ...
-1
votes
0
answers
26
views
Access DB on a server outside LAN
On my pc I have installed mysql server on port 3307 and there is a database that runs on it. I need to access it outside of my local network
In particular, I am interested in accessing from a net core ...
-4
votes
0
answers
28
views
connection with sql server
My task is to create a database in MS SQL that can be accessed via IP. I opened port 1433 in the router and in Windows. I set port 1433 in sql scm, the 2ip port is open. I have a static IP. But when ...
1
vote
1
answer
119
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 ...
0
votes
0
answers
31
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....
1
vote
0
answers
55
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-...
0
votes
1
answer
34
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 ...
1
vote
0
answers
77
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 ...
0
votes
0
answers
12
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 ...
0
votes
1
answer
166
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: ...
0
votes
2
answers
106
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). ...
0
votes
1
answer
183
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)...
1
vote
1
answer
82
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. ...
0
votes
1
answer
435
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 ...
0
votes
0
answers
28
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 ...
0
votes
0
answers
199
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 ...
0
votes
0
answers
28
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 ...
0
votes
0
answers
61
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 ...
0
votes
1
answer
79
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?
0
votes
0
answers
29
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 ...
0
votes
0
answers
215
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 ...
0
votes
0
answers
124
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 ...
0
votes
0
answers
216
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 ...
-1
votes
1
answer
609
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 ...
0
votes
0
answers
197
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 ...
0
votes
1
answer
148
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 ...
0
votes
0
answers
328
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 ...
0
votes
0
answers
51
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 ...
0
votes
1
answer
137
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 ...
0
votes
1
answer
228
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 ...
0
votes
0
answers
47
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 ...
0
votes
1
answer
726
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 ...
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 ...
0
votes
0
answers
382
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 ...
1
vote
0
answers
91
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 ...
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 ...
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 ...
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
...
0
votes
2
answers
47
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 ...
0
votes
1
answer
424
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 ...
0
votes
0
answers
470
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 ...
0
votes
0
answers
159
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 ...
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 ...
0
votes
2
answers
1k
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 ...
0
votes
1
answer
130
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 ...
1
vote
0
answers
612
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....
2
votes
1
answer
832
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 ...
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 ...
-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
------------------------------------------
...