Questions tagged [database]

System that handles large amounts of data in an organised fashion

Filter by
Sorted by
Tagged with
0
votes
0answers
18 views

mysql storage filling up unexpectedly (RDS)

I am total newbie to database game. & I am using mysql 8.0 RDS 20GB free tier. I don't have much data on it.(just 300 Mb) But I always get a mail that you have exceeded 85% of storage limit.(...
0
votes
0answers
15 views

Application cannot connect to HAProxy Database

I am trying to connect my GLPI project to my HAProxy DB Server, I followed this guide to set it up. I am using CentOS 8 with Nginx and here's my HAProxy config: global log 127.0.0.1 local2 ...
0
votes
0answers
7 views

Do Galera (or MSSQL) support this clustering scheme?

Clustered databases can be scaled relatively easily. However, even assuming zero latency to spin up a new instance, there is a considerable delay before the newly added node is ready to serve requests....
0
votes
1answer
20 views

When creating a managed database should I have one instance per application?

Let's say I have 10 different applications that all have a postgresql database dependency and these applications must be deployed on Azure using Azure managed postgresql instances. Would it be best ...
0
votes
0answers
6 views

Persistent storage failure or Authorization Failure after Mongocontainer restart using docker-compose rebuild after Machine restart

I have set up a mongo container connected to a nodejs app. First I do docker-compose up --build where I start mongo as a service without auth, i.e commented out. Then I login to the mongo terminal ...
0
votes
0answers
19 views

Run MongoDB with Unbreakable Enterprise Kernel (UEK) on Oracle Linux

I am running MongoDB v3.4.9 on Oracle Linux Server release 7.7 with the Unbreakable Enterprise Kernel (UEK) 4.14.35-1902.3.2.el7uek.x86_64 for testing purpose. UEK is not official supported on Oracle ...
0
votes
0answers
17 views

How does nagios store monitoring data captured?

I have a few questions about nagios and databases: How and where does nagios store the data it collects? How can I transfer this data to the database? Thanks in advance.
1
vote
1answer
171 views

Why can't my AWS Lambda connect to my AWS RDS proxy?

I can connect to my database locally just fine (of course with the normal DB endpoint, not the proxy endpoint). However, I just can't seem to get my lambda function to connect to the same database ...
0
votes
0answers
8 views

Connection String OLEDBSQL Using Trusted Connection

I'm trying to switch my MSOLEDBSQLB connection string to support older ADO Recordset & MS DataShape connections to use TRUSTED style connection string and not able too. I have SQL native client ...
0
votes
1answer
13 views

Cross-region database latency much slower than ping?

We were recently discovering that an API request had about 500ms response times as seen in the logs from our server. We realized this was because we had our API running in aws-west-1 but a remote DB ...
0
votes
1answer
22 views

Migrating MS SQL Server database to Azure

I have an issue migrating my database from my PC to Azure. I cannot install the Data Migration Manager. I have already allowed port 1433 in my firewall and I am getting further in the installation ...
0
votes
0answers
7 views

Asterisk Integration Issue with CRM

I have configured V-tiger CRM. I want to integrate v-tiger CRM from Vici-dial asterisk but in v-tiger CRM there are not showing phone calls extension in extension store. I have configured the call ...
0
votes
2answers
31 views

Read DNS Zones from database

I've developed an application with Laravel (it's same as a site builder), clients can add their information to their profile, and finally, they can park a domain to the profile (by setting my DNS for ...
0
votes
1answer
16 views

Is it safe to backup volumes of running mariadb docker containers

Is it safe to backup data volumes of a running mariadb / postgres / mysql container? Should I stop the container prior to backing up the volumes?
0
votes
0answers
164 views

mariadb.service start stuck at activating

I just installed the mariadb in my ubuntu 19.10 by sudo apt install mariadb-server mariadb-client after when I am trying to start the server by sudo systemctl start mariadb.service shell get freeze I ...
1
vote
0answers
16 views

Why would files appear corrupt but then be fine days later?

The Setup: Dedicated CentOS 7 web server hosting a CRM database on a company’s internal network. Everyday, the server backs up to itself and then the backups are copied offsite. The Problem: This ...
0
votes
1answer
85 views

Exported MariaDB dump different size

I'm trying to copy a database from a MariaDB server on another. I made a dump of the database on server A with : sudo mysqldump -u root -p --databases database1 > /var/tmp/database1.sql I created ...
0
votes
0answers
23 views

Created Azure Database for PostgreSQL Servers with Private Endpoint, Wanted Public

I newly created a PostgreSQL server on Azure. As far as I remember, I chose the option "private endpoint" instead of "public endpoint". After its creation, I copied the connection strings from the ...
0
votes
2answers
21 views

Network Exception thrown after session timeout

My site will run fine and I can go through the entire site, but after my session times out, when I make another request to a page I get this exception: Server Error in '/' Application. The system ...
0
votes
1answer
57 views

How do I access my non-public AWS RDS MySQL database with MySQL WorkBench?

Trying to access my database in AWS with MySQL Work Bench, but the only way I'm able to access it is by making the database public and open to all inbound traffic. This is a huge security risk and I ...
0
votes
0answers
13 views

Open-Xchange Installation “The maximum number of contexts in every database cluster has been reached”

I'm currently trying to configure my Ubuntu Server with Open-Xchange for personal use. I've got Open-Xchange up and running (all the databases and users have been created, the site is reachable via ...
0
votes
1answer
29 views

Import of .SQL file is very slow with HeidiSQL

I have a database on a MariaDB server that I need to copy on a Galera Cluster on other machines. I used HeidiSQL to create a dump file which is pretty fast actually. The database is about 500Mb. ...
0
votes
1answer
178 views

Azure Database for MySQL servers: Location: service not available in this location for your subscription

I am trying to create an Azure DB MySQL server and under location I keep getting this error. " service not available in this location for your subscription." Could you guide me what needs to be ...
1
vote
0answers
20 views

Experimental setup of PostgresXL on Kubernetes with Local volumes

I'm making a Gedankenexperiment about deploying PostgresXL on Kubernetes (k8s) where each datanode uses local (Directly Attached) storage. Imagine we have the following nodes: 2x highend machines ...
2
votes
1answer
26 views

Perc H710 on Windows 2016

Excuse me for a naive question. I just got R720 with 4x3T on RAID 5 using H710. In the server manager, I saw disk with 8T which I suppose is the virtual disk I set up using H710; In volumes, there is ...
0
votes
1answer
67 views

fio numjobs & iodepth Values to Simulate Database PostgreSQL Workload?

I am trying to benchmark a ZFS RAID-10 array of SATA SSDs using fio with settings that are somewhat representative of database workloads like for PostgreSQL. For example, for random reads: fio --...
1
vote
2answers
36 views

How to create read replica from MSSQL to MySQL through RDS

I have a RDS instance with SQL Server Standard edition. This DB is used for transactions, I want to create read replica but I want the new replica to be MySQL/MariaDB or PostgreSQL. This is because we ...
0
votes
1answer
22 views

Upgrade mongodb replicaset 3.2 to 3.6 on live servers

I want to upgrade mongodb version(3.2 to 3.6) on prd environment W/O downtime. We have one primary node, one secondary node and one arbitrary. We are using ubuntu 16.04. So please guide me how can I ...
1
vote
1answer
20 views

Databases “Synchronized / In Recovery” after adding server to SQL Avaylability Group

I have an SQL AlwaysOn Availabilty Group configured with 2 nodes. The AG works without any problem with this 2 nodes and I can do a failover to/from any of them (this servers are on the same network). ...
0
votes
1answer
56 views

Kubernetes, pods with unique database server vs one shared database server

I'm developing an application that is shipped as a cloud service, that is there are n instances of that application and each is completely separated from one another and each of those separated clones ...
0
votes
0answers
15 views

How do you update services to talk to new IP in a master/slave database setup

I'm using postgresql. I have done a lot of reading into setting up redundant SQL setup and most of them boil to having a simple master-slave setup where the slave can become master at any point. Now ...
0
votes
2answers
59 views

How to import/upload a WordPress database without access to Cpanel

I finished a WordPress project. I already uploaded all the files through FTP, now I have to import the database, but the client doesn't want to give me access to Cpanel. How can I import / upload the ...
0
votes
0answers
65 views

Laravel with Galera DB cluster

I have a Laravel project and created a Galera DB cluster. A feature of the cluster is that it is available on three different IP addresses. How can I declare these IP addresses for Laravel to use? I ...
-1
votes
1answer
38 views

How to manage many identical instances of a MySQL schema over many machines? [closed]

I'm working on a project that has a MySQL database schema that's used on three different servers (MySQL databases) into 20 copies of the schema for each server (which are all identical in form but ...
0
votes
0answers
32 views

PostgreSQL service is constantly shutting down

I have a postgresql 11 database. I use Windows 10 OS. After my computer falls asleep I often have to manually turn on the service.Tell me maybe someone met such a problem.I'll be greateful for any ...
0
votes
2answers
110 views

Combining Two 2TB disks and One RAID-10 Array into A Single Logical Volume?

Is it possible to combine 2 disk and 1 RAID array into 1 single logical volume in Ubuntu 18.04? I am planning to set up a PostgreSQL database on this machine and think it is better to let it store ...
0
votes
1answer
94 views

Create tablespace in gcloud sql instances

I had created one PostgreSQL instance under gcloud database. Using default user (postgres) i want to create a tablespace but its not allowing me to create, says permission doesn't exist Can we ...
1
vote
1answer
130 views

Can't go back to root from postgres: forces to enter postgres password which it finds invalid

I've installed postgres on Ubuntu and it switched me to postgres user. I've opened psql created a database and then decided to switch back to root. However, it doesn't allow me: sudo su - results ...
0
votes
0answers
73 views

Identify the Current Bottleneck in my PostgreSQL Server

This is my first time running a database server that is under some real (non-synthetic) workload and require your help in identifying the current bottleneck. Question: Is it the CPU, RAM, Disk IO? ...
0
votes
1answer
66 views

Huge Difference On Connecting to Local and Remote MySQL DB in Same Machine

I have a rest-full php 7 web service app in a centos 7 vm and mariadb 10.4 as database. I have to seperate database to another vm beside main vm on same machine, my question is why diffrence of ...
0
votes
1answer
359 views

Adminer or mysql error: no connection could be made because the target machine actively refused it

I have been trying to set up wordpress.org using localbyflywheel, but when I open Adminer I keep getting this error: No connection could be made because the target machine actively refused it, what ...
0
votes
1answer
33 views

Server cost CPU time vs HDD space [closed]

I was thinking about how apps scale and what ends up costing the most CPU time or HDD space. I know this question is a vague question and depends on the type of app but if anyone has experience with ...
1
vote
2answers
305 views

Use ansible initialize postgresql multiple times

Make this task will work first time: - name: Initialize the Database command: /usr/pgsql-9.6/bin/postgresql96-setup initdb If run it second time, will got error: fatal: [192.168.0.1]: FAILED! =&...
1
vote
0answers
67 views

MySQL server has gone away

MySQL is running on Ubuntu 18.04. We have many databases running on this single server and many sites running from those databases. All sites working fine except one site. That site frequently goes ...
0
votes
1answer
122 views

Mongo restore command reduces database size

I have two clusters of mongo database, each having three machines. Say Cluster1 and Cluster2. To reduce cost I have to terminate Cluster2. So I took mongodump of one database from the primary machine ...
0
votes
1answer
147 views

Slow initial connection to database (php / mssql)

Our webserver and database server are on a local network and the webserver uses an IP address to connect to the database. $con = new \PDO('sqlsrv:Server=10.200.2.1\sql2017;Database=dbname, $user, $...
0
votes
0answers
41 views

Mysql database been hacked. What to do now? [duplicate]

My testing database has been hacked. I am pretty sure it's hacked by an easily guessed test use admin credential. After reading How do I deal with a compromised server? I've got an idea of what to ...
0
votes
0answers
10 views

WordPress Database connection error after resizing the instance

My website is on Google Cloud Platform and yesterday it was not working because of the Connection Time Out. I check the Dashboard and in Resources it ask one recommendation for resizing the instance. ...
0
votes
1answer
30 views

Is this application a data vault, data mart or data warehouse? [closed]

I am importing information from various source systems and putting them into local databases for reporting. For example, one of the sources is Google Analytics. Here are some attributes of this ...
1
vote
1answer
209 views

How to create a database read replica on AWS Lightsail

I have an existing MySQL database running on AWS Lightsail, I want to create a read replica for that one, how can I do it?

1
2 3 4 5
32