Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database]

System that handles large amounts of data in an organised fashion

2
votes
0answers
22 views

MongoDB Very slow queries since yesterday

Since yesterday I am having huge trouble with my MongoDB. I have a 100GB collection with over 50M documents. Making a find on them and a .count() was never an issue until yesterday. Somehow, since ...
0
votes
0answers
10 views

ODBC Client is extremely slow over network [on hold]

I'm Working On a project where ODBC Driver is Provided by a third party software where our data feed generated real-time When I configure ODBC to work with local Database (SQL Server and SQL Server ...
0
votes
0answers
15 views

Azure Database for MariaDB and log_bin_trust_function_creators

I am trying to create a function on Azure Database for MariaDB like below: CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN CONCAT('Hello, ',s,'!'); but I am getting the ...
0
votes
0answers
17 views

mysql permission and domain pointing

I use debian, apache and wordpress, new fresh installation, i have problem with DB permissions and domain pointing to wordpress installation. so, privmat.net is ordinary index.html file and ospok....
0
votes
0answers
17 views

How to restore MariaDB Databases from files

After the whole server went FUBAR I managed to retrieve website files (php,html and such) and the DBs. Now I have these files: aria_log.00000001 aria_log_control ib_buffer_pool ib_logfile0 ...
0
votes
2answers
69 views

How do I get SQL Server Management Studio to find a .bak file to restore?

I am trying to turn a .bak file into a database. I can't find the "Restore Database" button when I left-click "databases" when connected. This is what I should see. However, this is what I see. I ...
1
vote
1answer
24 views

Migrating from DynamoDB to RDS

I'm considering the different options available for migrating a DynamoDB Database to RDS. The data structure makes much more sense in a relational format. There are 8 tables with around 1 million ...
1
vote
0answers
37 views

ERR_PROTECTED ERROR: nsfsem2.c/ln In IBM Domino

My customer has been getting a series of errors at the Domino console, "ERR_PROTECTED". The Domino version is 8.5.3FP6 HF1020. The error is causing Domino to think that the database files are read-...
0
votes
1answer
35 views

AWS Database Migration Service requires a role not mentioned in documentation

I am trying to perform a database migration using AWS Database Migration Service (DMS) from a self-managed database on EC2 to AWS RDS. I get this message when I try to run the task to perform the ...
0
votes
2answers
110 views

local mysql was hacked with ransomware hack. How to check if database data was downloaded?

I had a test mysql database running on Vagrant dev box. Turns out the network wasn't that secure. All of the databases were deleted (and replaced with a DB ransomware note) and in the logs I can see ...
0
votes
0answers
14 views

Amazon's Database Migration Service (DMS) - Exact meaning of “Partially supported datatypes”

I have several columns in my db that are float8, I'm looking to do a direct postgres10 to postgres10 migration between two RDS instances. Upon doing the Assessment for the task, it states there are ...
0
votes
1answer
40 views

Where are Azure SQL Database Backups Stored

I've got 5-6 Azure SQL Databases running. They run in the Basic and Standard pricing tiers. From what I've read backups run by default which allow for the Point in Time restore options to work. ...
3
votes
2answers
138 views

Nosql autoscaling of compute

Most of the nosql autoscaling faces issue due to the fact the data have to be migrated during peak load. What if data is stored in a shared storage like CLVM which has less overhead(compared to NFS or ...
3
votes
2answers
62 views

Restrict access to S3 bucket folders to specific website users? (not using IAM Users)

I have a website where users need to log in. They can upload and delete their own pictures BUT these pictures are supposed to be private so images are not set to public that anyone can view. I know ...
0
votes
1answer
24 views

Get-Command Changing Drive

I wrote a powershell script that includes a check for the invoke-sqlcmd cmdlet. Script runs fine under Windows Server 2016. On 2012 R2, the script fails with: Add-Content : Cannot use interface... ...
2
votes
2answers
291 views

Unknown Database when trying to connect to an AWS RDS instance

I created a MySQL RDS instance, however, when I try to connect without writing the database name, it connects but does not allow me to create any tables. When I do write the name, the connection fails ...
-1
votes
1answer
185 views

How to create a SQL Server Database from DBML [closed]

I have corrupted an entire database and I have no access to it or backups. Is there a way to recreate the structure of it using a .dbml from visual studio project? Thank you in advance.
1
vote
1answer
109 views

accidentally delete mysql files in /var/lib/mysql

I made a big mistake!, I have a vps(centos7) server and for deleting temp files have a command: sudo find /tmp -type f -atime +10-delete this command is good but this time by mistake i forgot to ...
0
votes
0answers
74 views

Error ORA-03113: end-of-file on communication channel

I installed a BD 12c, and every day at a certain time the BD stops working and when I want to start it again, it throws me the following error: Error ORA-03113: end-of-file on communication channel To ...
1
vote
1answer
37 views

Unable to create rds instance using cloud formation?

Iam trying to create an rds mysql instance using cloud formation.But when iam creating the stack iam getting rollback.Under events the error for creating rds instance is "Encountered unsupported ...
0
votes
0answers
15 views

Do memories from different manufacturers impact performance? Is there a way to measure it?

Memory in one of my systems: % lshw -C memory|grep vendor | grep -v NO | grep -v 'American Megatrends' | grep -v 'Intel' vendor: Samsung vendor: Samsung vendor: Micron ...
1
vote
0answers
100 views

MariaDB Cluster is having timeout issue between nodes

I'm having some hard time diagnosing MariaDB Cluster issue that I would like to have some advices. We're running a 3-nodes MariaDB Cluster, each node is on a dedicated ESXi server, and connected by ...
2
votes
1answer
54 views

Query database in Cloud Platform / PaaS {AWS, Azure, GCP} from outside the platform/PaaS?

Is it generally possible to query a database housed in PaaS "A" from a request originating in a different PaaS "B" (or does it depend on the PaaS)? Asked in another way: Can an app that is hosted in ...
1
vote
1answer
88 views

Scale out Azure SQL Database

I have a SQL Database in Azure. An S0 instance with 10 DTUs. This is enough 95% of the time. However, when the App Service plan scales out (can go up to 20x in rare cases), I need 200/400 DTUs. Since ...
0
votes
1answer
16 views

Postgres on Ubuntu Server 16.04 - automatically backups

I have Ubuntu Server 16.04 and PostgreSql database. How to organize automatically backups? Is this better idea to move my database to AWS RDS instead having database on my server?
0
votes
0answers
10 views

389 server - trim replication changelog does not seem to wrok

DB size is currently ~25 GB. I tried to do what they suggested: https://access.redhat.com/documentation/en-us/red_hat_directory_server/10/html/administration_guide/trimming_the_replication_changelog ...
1
vote
1answer
241 views

systemd not shutting down MariaDB properly?

We are running a LAMP stack on CentOS 7. We have SCL enabled but only PHP and Apache are using it. We were not able to get MariaDB to successfully cutover on a test machine so we never attempted a ...
0
votes
0answers
229 views

Does a Galera equivalent for Postgres exist?

I've been working with Galera for a number of months and like the failover along with the redundancy. I've got a Postgres DB that is in testing and will probably move to production. Is there a Galera ...
0
votes
1answer
37 views

Azure SQL to On-Premise SQL Server Data Transfer

I need to securely transfer data from a SQL Server in Microsoft Azure to a SQL Server on-premises. I have been researching different methods but I have not found the right way. Following is the list ...
0
votes
0answers
12 views

How can I further improve Oracle 12.1 performance on RDS m4.large instance?

I'm having performance issues with my current Oracle setup. Queries are taking half a second and I can't figure out how to speed it up further. I've upgraded my RDS instance from a t2.medium to m4....
1
vote
1answer
3k views

What does “GC (Allocation Failure)” mean in my ElasticSearch 5.6 logs?

I see these constantly in my Elasticsearch 5.6.3 logs. Is this a signal that I should scale up and add more RAM? Or is this just normal operations for ElasticSearch? [GC (Allocation Failure) [...
0
votes
0answers
32 views

SQL SERVER 2014 copy a multi file group database to a single file group db for transferring to azure

I have been trying to transfer a 1TB sql server db to azure sql db for performance assessment. I tried using Data Migration Assistant many times but it hangs and exits every time during data transfer. ...
0
votes
0answers
48 views

Sql server on ubuntu doesn't respnod

I have installed sql server 14.0.3030 express with .netcore 1.1 on ubuntu 16.04 and everything was fine till last night suddenly i encountered with this err message from my dot net core web app ...
0
votes
1answer
57 views

Looking for a way to pause or quiesce a database on google cloud platform

Is there a way to pause or quiesce a database on google cloud platform to reduce costs yet maintain the data? If not, do any of the cloud database providers offer such a feature?
0
votes
1answer
258 views

How to Change Replica Set Protocol Version in MongoDB.

I'm trying to change Replica Set Protocol to pv1. I have 5 replica set servers Mongo 3.6. I'm using the documentation from here https://docs.mongodb.com/manual/reference/replica-set-protocol-versions/ ...
0
votes
0answers
67 views

SQL Server 2016 replication monitor from the slave ( subscriber ) without admin access to the publisher

Question: Is it possible to check the replication status of SQL Server 2016 from the slave ( subscriber ) without admin access to the publisher? We have an SQL Server 2016 which is a slave ( ...
1
vote
2answers
186 views

How to install a MySQL plugin with Ansible?

So far we've been using the Geerlingguy Ansible role for all of our database deployments, but now I'm expanding our usage of it for a new project, and it doesn't seem installing plugins is a supported ...
0
votes
1answer
38 views

database connection error & Database was not shutdown normally

I need some solution for my wordpress site database error. I have face this DB error last one month. I don't know what is the reason for this Database connection error. Please review my error.log ...
0
votes
1answer
32 views

Difference between mysql.user table and mysql -u -h

Usually I run mysql using something like this: mysql -h hostname -u user -p (and then type password here) but I wanted to know how is this related to the mysql.user table. When I log in into mysql, ...
0
votes
0answers
250 views

Connecting to MongoDB Atlas throws Exception 'No suitable servers found'

Connecting to the mongodb atlas and trying to write a simple document gives the following error. What am I doing wrong? $manager = new MongoDB\Driver\Manager("mongodb://admin:admin@test-shard-00-00-...
0
votes
1answer
896 views

AWS EB and RDS: Invalid storage size for engine name mysql and storage type gp2

I'm trying to deploy my (python/django) application to AWS Elastic Beanstalk, but I am getting the error. Deployments have been working fine for the last few months, so I'm confused what could be the ...
0
votes
2answers
178 views

pg_dump fails as a cron job in one script but not another

I have two cron jobs on my AWS server (triggered via crontab -e) to invoke pg_dump on specific databases. The two scripts are identical with the exception of the target database they're backing up ($...
0
votes
0answers
24 views

How much RAM should a my DB Server have for a typical WordPress Installation? [duplicate]

my first question here. I am managing a high traffic wordpress website (mypianonotes.com) which gets upto 300 Real time users. Now, this is absolutely fine and is easily managed. The front end of ...
0
votes
1answer
41 views

Ejabberd mysql prefix on database tables

How can I use prefixes on database table names in Ejabberd? I have the mysql.sql file with the schema and I would to use the prefix "ejabberd_" on all the tables. I can't seem to find anything on the ...
0
votes
1answer
62 views

OpenSSH/Dropbear using MYSQL Database - Linux [ubuntu]

Is it possible to use MYSQL to store user accounts and use it to authenticate with your SSH (OpenSSH/Dropbear) and is it possible to use remote mysql database? Basically, I want to use MYSQL as user ...
0
votes
0answers
188 views

Ubuntu Server Performance Issues with CockroachDB

I have a cockroachdb node I am playing with. My box has Ubuntu 16.4, 64 GB of RAM, 4 physical cores (Quad Core Intel Xeon 3.3 GHZ). Inserts to this DB are very slow. On a 100000 sample set, average ...
0
votes
1answer
174 views

Galera or master/slave MariaDB

What would be the recommended choice for database replication with failover? I know this is a broad question but I'm curious what the general experiences are when it comes to real life setups. As far ...
1
vote
1answer
64 views

Real World Architecture [closed]

I am kind of confused about the way real-world web applications are architectured and I would be happy for some clarification . I know that there are many methods and different approaches but an ...
0
votes
0answers
51 views

wordpress Got packet bigger than 'max_allowed_packet' bytes when dumping table `wp_options`

For over 6 months now, by automatic daily database backups are failing every time. My wordpress database is around 100MB but the backups are only 700KB. Every single backup fails after backing up ...
-1
votes
1answer
31 views

How to create (or use the existing) database on an SQL 2017 deployed via Azure VM?

Please note the question is about the SQL 2017 that comes inside an Azure VM, not the Azure Databases. Basically, I deployed an Azure VM with SQL 2017 Enterprise installed on it already, by MS. Now, ...