Questions tagged [database]

System that handles large amounts of data in an organised fashion

Filter by
Sorted by
Tagged with
0 votes
1 answer
21 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
22 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 ...
-1 votes
0 answers
18 views

Create an infrastructure monitoring view using graph

I am looking to create an infrastructure monitoring app where a client running on each server sends data regarding server health like CPU, ram, and load as well as MariaDB, aerospike, and rabbitmq ...
0 votes
0 answers
44 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 ...
  • 99
-1 votes
0 answers
24 views

Exposing database on local DNS using Traefik v2

I'm new to Traefik. It's likely that I use incorrect terminology and/or am more confused than I think I am. Corrections are gratefully accepted. I want to expose a database in my local network (domain ...
  • 99
0 votes
0 answers
8 views

PostgreSQL Subscribers and Publishers (Multi-Master Scenario)

I'm currently trying to develop a solution that would be trying to focus on Multi-Master Databases So here is how it's supposed to operate I want so that whenever an Agent makes a change to a database,...
  • 101
0 votes
0 answers
16 views

Determine the number of connections initiated to the database

We have a 3 tier architecture application wherein there is a recent surge in the number of inactive sessions in the database. We are using oracle database and weblogic application server. We have 'n' ...
  • 111
0 votes
1 answer
50 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 ...
  • 176
0 votes
2 answers
77 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 ...
  • 65
0 votes
0 answers
20 views

Synchronization concerns regarding MQTT and InfluxDB

I'm trying to implement mosquitto broker with InfluxDB. My concern is that the data won't be stored properly, because InfluxDB is a "real-time" database and the MQTT protocol is asynchronous....
  • 101
0 votes
0 answers
17 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 ...
  • 11
0 votes
0 answers
83 views

Alternatives to RDS Proxy for PG serverless database usage

What other managed Postgres database services exist that are designed for serverless use? i.e hosted databases that have a similar proxy layer that can handle thousands of connection requests spawned ...
  • 143
1 vote
0 answers
52 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....
0 votes
0 answers
28 views

Fixed IP address to an EC2 Instance in CloudFormation

I'm developing an infrastructure in CloudFormation where the database and the application is separated, but since I don't know what IP my application will receive, I can't create a filter for the ...
0 votes
0 answers
134 views

error connecting sequel pro to mysql on mac localhost

i just installed mysql on my mac, with brew. I then started the service and made the secure installation to add a password. now i can login into my sql from terminal but i'd like to connect also ...
0 votes
0 answers
28 views

Hard Limit of The Number of AWS RDS Instance

As I checked in this document > https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Limits.html#:~:text=DB%20instances,the%20current%20Region it shows the default limitation(Soft-Limit) as ...
2 votes
1 answer
126 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 ...
  • 421
0 votes
0 answers
406 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
-1 votes
1 answer
514 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 ------------------------------------------ ...
0 votes
0 answers
113 views

Restoring MySQL in Jenkins Job - ERROR 2003 (HY000): Can't connect to MySQL server on '172.18.0.3:3306' (111)

I am trying to restore db from a file with commands run as Build step 'Execute shell' in Jenkins. I am getting ERROR 2003 (HY000) when I run the restore command through Jenkins jobs. However same ...
  • 131
1 vote
2 answers
62 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 ...
0 votes
1 answer
199 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 ...
  • 63
-1 votes
1 answer
52 views

Unable to get subdomain to connect to MariaDB

So far I can reach the DB from the main domain lets say example.com but connection from the subdomain lets say portal.example.com, don't work. I am currently running Nginx & Varnish & Apache ...
  • 1
0 votes
0 answers
28 views

How to know the DB SSH Tunnel credentials from the server itself

I'm a dev and I need to connect to a DB from an external database client, like Navicat or DataGrip in my case, this is very useful because it allows me to create a project and store queries in ...
  • 101
0 votes
1 answer
118 views

Minimise client side connection to multi-tenant Postgres databases

My employer currently have multiple Postgres instances (one per customer, having a unique site code) which are physically separated on customer premises. Each customer has 1-4 databases running inside ...
0 votes
0 answers
192 views

Can I recover a db password?

For our project in GCP, the app has a production Postgres db instance, we don't have the current password, therefore we can't access the db other than through the app. If we change the password, then ...
0 votes
1 answer
67 views

Receving 502 Bad Gateway when trying to access via URL

Unable to access my VM using SSH and receiving 502 Bad Gateway when trying to access via URL. Get below error : {"@type":"type.googleapis.com/cloud_integrity.IntegrityEvent", "...
2 votes
1 answer
29 views

How to install cbexport and cbimport on a standalone linux vm to connect to remote couchbase server

I need to use cbexport to export buckets in couchbase and place it in S3. Although I have the credentials to access couchbase I cannot login to the vm on which it is running. So I cannot use the ...
  • 45
0 votes
1 answer
213 views

Can I use an UNC path on remote MSSQL server in a store procedure to access remote file?

I have a store procedure on a remote MSSQL server. It has bulk insert from a file.That file is on another server. The file is shared on Ubuntu via Samba. Can that store procedure access my file? What ...
  • 101
-1 votes
1 answer
70 views

Regarding how Big companies set up their databases [closed]

I am trying to understand how do companies which handle a large database requests set up their infrastructure. I have recently created a few python applications which store data in PostGres and ...
1 vote
1 answer
6k views

Not able to backup of postgres DB from DBeaver

Hope you are doing great. We have postgres install on centos server and accessing it through DBeaver from Ubuntu machine. Whenever we try to take backup of Database it is giving error as "Native ...
0 votes
0 answers
12 views

Difference between DB having user-password protection, DEK, TDE

I am a total noob in systems and have questions about DEK. What are differences(or advantages of one over the other) between knowing your username and password for your DB(mysql or mariadb) and DEK. ...
0 votes
0 answers
151 views

Allowing docker to access local webhost Database

I am creating a webapp for my business using AppSmith, hosted on Docker. AppSmith requires access to a database in order to read/write information. Previously I have used MariaDB which is also hosted ...
  • 101
0 votes
2 answers
907 views

How to find joins performed without indexes?

I run a WordPress website on Mariadb 10.6, and recently I saw an error Joins performed without indexes in Mysqltuner. Although the number is not very large, Mysqltuner recommends that you keep ...
0 votes
1 answer
59 views

Why my simple searching query is too slow?

I don't know why searching in my "cities" table is so slow. My query looking for a table "cities" located about 25km from the city. I use this simple query and the database takes ...
0 votes
0 answers
288 views

Can't install/uninstall SQL Server

When I try to install SQL Server Express I got this error Unable to install SQL Server (setup.exe) Then I'm trying to uninstall everything related to the SQL server to avoid previous installation ...
  • 101
0 votes
1 answer
858 views

Mysql database often stops and won't restart

Server: Linode Dedicated 4G Ubuntu 18.04, Webmin + Virtualmin Every now and then, mysql server stops and fails on restarting. Here is the logs I was able to find: Apr 11 20:54:57 bamboo kernel: [ 2082....
  • 199
1 vote
1 answer
132 views

Idle database connection lost

I am able to connect to the database server (Firebird), run queries, all those fun things, but after an undetermined period of inactivity, the next query attempt generates the following error Unable ...
0 votes
0 answers
892 views

MySQL (MariaDB) Not Starting '/usr/sbin/mariadbd: Shutdown complete - mariadb.service: Failed with result 'exit-code'.'

I'm getting an error when i try to start mariadb.service service: Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" ...
0 votes
0 answers
14 views

Quorum at Scylla. DR orchestrator

I have a strech cluster with Scylla for 2 data centers with a balancer. The principle of operation is Every_Quirum. (After reading the documentation, I came to the conclusion that all DPCs should work)...
0 votes
0 answers
220 views

Are MySQL/MariaDB and Postgresql compatible?

I want to install multiple applications on my web server. For most of them, using PostgreSQL is possible or the only option. But in one of them's installation guide, only MariaDB is mentioned. If I ...
  • 1
0 votes
1 answer
397 views

Best way to store database file on a NAS and run the server on a computer

I have a txt file more than 250go I want to create a database with that and access it by a python program that I'll be coding. I have a NAS server on my local network ( 1gbit network ) And I would ...
0 votes
0 answers
9 views

Best server option for Django project [duplicate]

I have a Django on Postgres web application. It's a business management software. There are no serious calculations going on, but there's a lot of requests from a database. Right now it's running on ...
  • 115
1 vote
0 answers
717 views

Only rdsadmin account on AWS RDS with full master permissions

Good afternoon all, I'm hoping someone is able to help with the following. On our main live database it's just been brought to our attention that we need to be able to kill user processes that are ...
0 votes
0 answers
129 views

Best Parctice of High Availability For MariaDB

I'm preparing to run a MariaDB Cluster with HA and I'm Looking for the best practices. Years back I used to run MariaDB in master-master mode, and there was a big issue. whenever any of the nodes(two ...
0 votes
0 answers
330 views

Manually close database connections for AWS Aurora Serverless PostgresDB?

Is there any way to manually close all open connections to an AWS Aurora Serverless Postgres database? Because the database is serverless, it is not possible to restart the database.
  • 101
0 votes
0 answers
305 views

How do I use the pgpass.conf file to allow promptless connection to a database

for testing purposes I have a postgres service/database running on my local computer. Right now I am using a batch file to change default userlogin, but I cannot use SET PGPASSWORD to pass along a ...
0 votes
0 answers
25 views

Server Layout for Web-, API-, Database-, VPN- and SIP Server

i have the possibility to redo our Server Infrastructure - i need your advices and best practices to design a good foundation for future expansion. As we are a quite small company with a very limited ...
0 votes
0 answers
72 views

I want to know how to change ip from expire pool to normal after date is extended

I been searching for a solution regarding freeradius revert from expired pool to normal pool when the user paid. I just entered a date and time for a particular user for expiry in mysql. MYSQL ...
  • 1
0 votes
0 answers
13 views

How to get Azure Policy Rule JSON script for existing resource

I want to create the custom policy for our databases. the default PITR Backup policy is 7 days but I want that all our newly added databases should be 35 days backup policy, Please any one guide ma ...

1
2 3 4 5
34