System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

1
vote
0answers
7 views

Certificate is not showing up in SQL Server

I need to say first that I am not a DBA and so, my problem is getting SQL Server Configuration Manager to recognize a certificate. I have 3 SQL Instances I work on, 2 are on the same network, the ...
0
votes
1answer
12 views

Best performance- and backup-strategy with running multiple Webapps and databases on dedicated servers

my company is soon going to move our webservice-hosting to a new hoster and therefore i'm currently planing how everything will run in the future. I have to deploy at least: MsSQL-Database Server ...
-1
votes
0answers
9 views

Mysql Dump and exclude a bunch of tables via a wildcard

I've searched and couldn't find a clear answer to go about doing a mysql dump excluding a bunch of tables using a wildcard. I know mysql has the --ignore-table option, but I would have to list out ...
0
votes
0answers
4 views

Where should migrations be run on elasticbeanstalk deployment process?

I'm very curious as to how people run a command like db migrate on their eb apps. If you add it as an .ebextensions I fear that when you have multiple instances for one app, there could be conflicts ...
0
votes
1answer
30 views

Does AWS support DBF files or Samba Shares?

We have DBF files running in our local network. It's on an Ubuntu Server running Samba shares. The DBF files are used by our in-house system running on xBase. Now we're moving everything to Amazon ...
-1
votes
0answers
19 views

Beginner explanation on MySQL cluster? [on hold]

I am a beginner on MySQL and so far I have a web application with only one MySQL server running. I want to add more MySQL servers and started to read about MySQL clustering, but have a problem with ...
-2
votes
0answers
12 views

SQL Server, Virtual server and database access for a beginner [closed]

I know nothing about servers. I got the access credentials to a windows virtual private server that has a sql server. Also the password for the sa account on sql server. I need to access some ...
0
votes
2answers
36 views

How to connect postgresql with LDAP user?

I have a server with postgresql-9.4 fresh install and I have another server with LDAP already installed. I want to connect postgresql with LDAP user that already exists. What's the basic ...
0
votes
0answers
34 views

Backing Up Multiple SQL Databases to Network Share at the Same Time

Junior SysAdmin/accidental DBA here so apologies in advance for the noob question. The previous DBA here had a SQL Backup Maintenance Plan that he would copy across 20+ database servers and have all ...
-1
votes
2answers
42 views

MS SQL Server 2 identical databases on different servers replication or mirroring to each other possible? [closed]

Hi: I have one free version of SQL Server 2012 express database running on Amazon AWS with 1 CPU and only 1 GB Ram . As you can see the CPU and RAM power are barely enough for my PHP scripts running ...
0
votes
1answer
17 views

Does transferring a database to a new SQL Server instance lose statistics and execution plans?

I am transferring a database to a new SQL Server and was wondering, will it lose it's execution plans and statistics that its collected over the years for the benefit of performance and have to start ...
0
votes
0answers
4 views

cassandra nodetool drain running for days

We are having performance problems with our cluster regarding to timeouts when repairs are running or massive deletes. One of the advice I received was update our casssandra version from 2.0.17 to ...
-1
votes
1answer
23 views

Shared nothing database systems with SAN

Cloud data warehousing being so popular recently, I am wondering if there is an inherent contradiction in the manner in which they are architected: Terradata, Greenplum etc. require 'Shared Nothing' ...
0
votes
0answers
14 views

“error establishing a database connection” On my wordpress website - with indexes problems?

I keep getting this: "error establishing a database connection" and this is not ending. This is /var/log/apache2/error.log: [Thu Mar 31 11:38:45.865505 2016] [autoindex:error] [pid 22782] ...
0
votes
0answers
24 views

MongoDB setup for Rocket.Chat error message

I'm following this tutorial for a Rocket.Chat setup on an Ubuntu 14.04 LTS installation. After installation of Mongod, it says to setup a replica set and gives the instructions to insert the following ...
1
vote
2answers
38 views

Script to combine data from one file to another [closed]

I have a file containing folders name/value pairs: peter:/home/peter/ max:/home/max-lucas/ judith:/home/judith/documents/ I have another file containing files name/value pairs, with the same ...
-6
votes
1answer
29 views

Database File In Drop Box Shared Folder

Can a software database file be saved and kept in a shared folder like drop box and be accessed and used (whether simultaneously or not) from more than one computers? A quickbooks database file is an ...
0
votes
1answer
27 views

from security perspective one instance with Multiple Databases or multiple instance for multiple clients

We have 20 clients which currently every client has his own database on his own server(in his own environment) all the databases have the same structure(schema) and all of them has MS Sql Server 2008 ...
0
votes
0answers
22 views

SYNC MYSQL database instantly from one Digital ocean server to another

I have a site (data entry site ) on a Digital Ocean server and its database ( MYSQL ) is being updated with new records every second. I am hosting the public site on another Digital ocean server ...
0
votes
1answer
38 views

mongodb - authentication failure on phpmongodb with username

I have a problem to authenticating to mongodb. The system is ubuntu 14.04 LTS. I can connect locally: $ mongo mytestdb -u mongotest -p MYPASSWORD MongoDB shell version: 3.2.3 connecting to: mytestdb ...
0
votes
0answers
22 views

MONGO - mongod - no connection to database [duplicate]

i have an testserver running under ubuntu 14.04 with public ip address. On this i have plesk 12.5 and mongodb 3.2. For administration of mongo i installed phpmongodb. Then created an database, an ...
3
votes
0answers
26 views

How to handle point in time restore without binlogs/How to split database

I thought about this 3 days already and asked in IRC but I wanna consult your expertise too. Basically it is about a High Traffic Site that uses Drupal (don't get me started, I have no choice in this ...
0
votes
1answer
27 views

Opening ports on a remote DB server

I'm running a RHEL7 box, running MySQL-5.7.11 and I'm simply trying to allow remote connections... I followed the documentation here on opening a port and have done so successfully. When I run ...
0
votes
0answers
57 views

Docker postgres database errors

I started using Docker PostgreSQL 9.5. Im using Docker and docker-composer to start my 2 containers: I followed the following link for reference: ...
0
votes
2answers
67 views

Name [ ] is not bound in this Context. Unable to find [jdbc] Tomcat Issues

I just created a fresh Oracle Linux 7 VM with Tomcat 7 and Java 8_40. I've created several servers with Apache and Tomcat before, but never connecting to databases before. SELinux and firewalld are ...
0
votes
0answers
27 views

Database Server froze - High IO - how do I find out whats the reason? (Pics)

got a db server(KVM) running mariadb 10.1, runs fine since months, only servers 2 databases (drupal). Last night it went tits up. Here 2 screenshots from zabbix I checked the logs, they show ...
1
vote
1answer
46 views

Do I need to restart SUSE when upgrade glibc?

I plan to upgrade glibc version (HAVE to install by rpm command) on 30 SUSE machines, all the machine are using for running test on Jenkins. Could someone tell me the reboot is needed in this case?
0
votes
1answer
71 views

Exchange 2013 - 0kb EDB File after ISCSI Drop

I am unsure if anyone will be able to help me out. I have a 0kb EDB file after an ISCSI failure. I cannot run "eseutil" on the file as I get the error: Extensible Storage Engine Utilities ...
1
vote
0answers
50 views

Correct Azure VM firewall settings for Azure SQL Database v12

One of the recommendations when a client runs on an Azure VM and needs to connect with your Azure SQL Database v12 is to: Ensure that the port ranges of 11000-11999 and 14000-14999 on your Azure ...
1
vote
1answer
30 views

MySQL Error Code: 1017 permission denied

I have downloaded the German version of the Northwind sample database. I moved the folder to /var/lib/mysql and set the rights to drwxr-x---. Here is an output of /var/lib/mysql drwxr-x--- 2 mysql ...
-1
votes
1answer
59 views

Use Google Drive for live DB backup? [closed]

I am currently trying to define my backup strategy for my AWS EC2 server. I already use Google Drive to backup my apache root folder. This also automatically doubles as a deployment strategy since the ...
2
votes
1answer
27 views

Back up a database nightly

Question: Is it possible to automate the process of coping a full database every night into the development database on the same server? Software: Windows Server, SQL, SQL Server Management Studio, ...
0
votes
0answers
31 views

MariaDB query cache not being used with prepared statements

We are seeing a problem with our MariaDB setup where our queries executed as prepared statements are not being cached, however, queries executed locally through mysql command (i.e. text protocol) do ...
0
votes
0answers
9 views

Telling how big an oracle DB dump will be when imported

I have an oracle DB dump file that is 30GB and i would like to build a filesystem to support its size once imported - is there a tool/method i can use to tell how big it will be post import ? Thanks ...
0
votes
0answers
18 views

Linking fail2ban with a RDBMS

I would like to maintain a highly dynamic RDBMS table that will be insert/update/deleted from from multiple hosts (a kind of global blacklist for all my servers). The table would have a couple basic ...
-2
votes
1answer
43 views

best configuration for database server [duplicate]

Okay I have a VPS (DO 512 MB) and AWS RDS free tier . I wanna get the maximum performance , please help me cause I'm a little confused . I run a nginx server on the VPS and it can handle 1K ...
0
votes
0answers
21 views

Get the most out of VPS and AWS [duplicate]

I have a static website running on shared hosting and doing good (not slow) And having a bandwidth of about 3Gb / month and I'm adding 2 other dynamic website with database and php scripting(I assume ...
0
votes
1answer
52 views

How can I securely access a Rackspace Cloud Database in AWS?

Rackspace limits access for Cloud Databases to their ServiceNet. How can I securely and efficiently connect to a database instance there from AWS (over the public internet)?
1
vote
1answer
87 views

Unable to restore postgresql data dump for Django app hosted on Azure VM

I am trying to restore a postgres data dump for a Django app of mine. The data dump was extracted from Heroku, and pg_restore is being run on an Azure VM with Linux on it. There are around 40 tables ...
0
votes
1answer
34 views

How to change MySQL user permission temporarily (Per Connection)

I do not know if it is possible at all or not. What I want is that, when a certain connection is established, the user not be able to modify data with that connection. This is the scenario: ...
3
votes
1answer
29 views

Connect server A to database on server B and forward remote database port on server A

Edited: I'm quite new to all this admin stuff though! So: Whats the best way to connect a port on server A to the database on server B. The reason i want to do this: I want to connect server A to a ...
0
votes
0answers
41 views

Wordpress showing article title, but content is showing blank

I recovered from a disaster situation on the server, database is not affected. My wordpress files were old, from previous version (maybe 4.3). When I recovered those file and setup nginx with it, I ...
1
vote
0answers
15 views

CouchDB Authentication and Security

i used this link to install CouchDB on virtual machine http://depth-first.com/articles/2010/01/28/pubcouch-install-couchdb-on-ubuntu-karmic-from-source/ everything goes fine, after that i tried to ...
-1
votes
1answer
55 views

All MySQL databases appear to have disappeared

I'm running CentOS 6.7 with MySQL 5.1.73 and it appears as if all of the MySQL databases have disappeared within the past hour. MySQL starts up without any issues, however when running show ...
0
votes
0answers
7 views

How do I resynchronize a Bacula catalog?

I tried performing a Bacula upgrade, but found there were issues with our architecture. Our team tried powering through the upgrade testing backups, but eventually decided to do a downgrade and ...
1
vote
1answer
70 views

What is the best practice for deploying dev database to live system?

My developers in a project want to have the dev db on dev server synced with live db on live servers, which I think is a bad idea. Despite that, what is the best way to deploy a codebase+db to live? ...
0
votes
1answer
68 views

VSFTPD setup on Centos new virtual user cant connect

I have a vsftpd server configured on centos. Old users that are listed in logins.txt can login via wb browser. Problem is that when I create a new user I can't login 530 bad login error. Steps taken ...
0
votes
0answers
17 views

Merge and transactional SQL replication…database empty (SQL 2005)

Firstly, let me just say that I'm a novice at SQL in general and this might be an easy fix for someone reading, but I've been unable to find anything that would explain or help my issue online. If ...
1
vote
1answer
36 views

Our app lags “randomly” due to Disk I/O issues?

We have made an app that requires hundreds of images downloaded for each user every day. Our basic server setup is as follows: Loadbalancer -> Nginx -> Databaseserver However, our app "randomly" ...
-1
votes
4answers
190 views

How to mysqldump last 10 rows for EVERY TABLE in a database?

I have seen a lot of articles about "how to mysqldump last 'n' rows from a table in a database". For example: mysqldump --user=superman --password=batman --host=gothamcity.rds.com --where="1=1 ...