System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

3
votes
0answers
27 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 ...
2
votes
0answers
60 views

Barracuda SSL VPN Managing Users

Not really sure if this is the right site to be posting on, but I have a question about my Barracuda SSL VPN. I know there is a built-in user database on the VPN. Is there some way (in my asp.net ...
2
votes
0answers
2k views

Firebird 2.5 Database Corrupt

We have an issue where a database hangs the server when: a backup is performed (Hangs on a specific table) selecting * or count(1) from a specific table or viewing data that is related to the table (...
1
vote
0answers
29 views

Access database using Public External IP - Bandwidth

In an amazon EC2 instance, we pay for each GB of data transfer in/out. Which means, when are sent to server, it's data transfer in. When a user access some website hosted there, data is being ...
1
vote
0answers
22 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 ...
1
vote
0answers
73 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
0answers
18 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
vote
0answers
44 views

Sybase heavy Disk I/O issue

I have a Sybase 15 server that is constantly reading from the hard disk. I noticed that the sqlsrvr.exe is the culprit which is the main database engine. This is a pretty utilized server that is ...
1
vote
0answers
61 views

Securing communication over LAN in VPS provider

I'm curious about best practice when connecting from app to DB in a cloud provider. A quick rundown of our setup. We have 4 servers all on the same provider, in the same region running as VPS. ...
1
vote
0answers
28 views

Setting up SQL server on EC2?

I would like to set up a SQL server in AWS on an EC2 server. I originally wanted to use an RDS instance however we require the bulk admin privilege for some of our operations which is not allowed in ...
1
vote
0answers
63 views

SQL Server seems to be taking 40GB of RAM but keeps reading disk… Why?

So I have allocated 40GB of RAM for SQL Server. I can see that after I first run a query on database, that 40GB memory limit will be quickly filled during first run, however when I will do exactly ...
1
vote
0answers
202 views

Huge oplog size after full sync on one secondary causing performance issues - MongoDB

I'm a MongoDB newbie. I have a replica set with 3 members (1 primary and 2 secondaries) on CentOS 6 and Mongo 2.6.8. One of the secondaries crashed because of high consumption of memory and I couldn'...
1
vote
0answers
70 views

Commvault, how to generate a report by time scheduled?

I'm using commvault at the moment to manage backups, but i need to creata a report of some kind that can show me the days of the week , and what server is backing up at that moment. A bit like this: ...
1
vote
0answers
169 views

MSSQL Server 2008R2 Replication stall, no latency, no errors, missing data on subscriber

This morning after performing a routine database deployment of two new tables I noticed that transactional replication had stopped for more than 3 hours. When replication resumed it picked up 3+ hours ...
1
vote
0answers
101 views

Unexplained excessive database response times - very powerful hardware, tiny database

I've a strange problem that's repeatedly troubled me across 3 different servers now. The problem Please see the graph from NewRelic showing the huge amount of time spent in the database. The ...
1
vote
0answers
817 views

MongoDB Performance Troubleshooting

I have a small MongoDB replica set (2.4.6) and it seems about once a week, the primary gets bogged and the load average spikes up. This app doesn't see a huge amount of traffic. It resides in EC2 ...
1
vote
0answers
94 views

Tell proftp to allow connections only to the users that have permissions in PostgreSQL

I'm trying to set up an ftp server for the first time (under Debian Squeeze) and after searching through Google, I decided to use proftp. NOTE: I have a PostgreSQL server running in the same machine ...
1
vote
0answers
97 views

Legacy BSD PTYs instead of /dev/pts?

I'm trying to use an old database that only accepts connections from legacy BSD style pseudo-terminals /dev/ttyp's or /dev/tty's. It does not recognise /dev/pts/9 style PTYs. Connections via SSH. I ...
1
vote
0answers
23 views

My transactional overnight batch has spiked in duration

I have an overnight batch run which is transactional...picking up data doing some small calculations and putting it somewhere else and it was finishing around 3am every day for the last 2 months. Now ...
1
vote
0answers
734 views

SSD Performance under Oracle

I have serious performance issues with oracle running over ssd. I have two OCZ Vertex 3 MAX IOPS drives (firmware 2.15). It runs on a INTEL C600 SATA Chipset. Windows 2008 R2. So the issue is ...
1
vote
0answers
711 views

Corrupt mysql system tables

I am having issues with the columns_priv table in the mysql system database. I cannot add new users currently. I have tried repairing it using mysqlcheck --auto-repair --all-databases --password but ...
1
vote
0answers
149 views

Is memcache impacting my performence negatively?

I am using pressflow 6 and NewRelic seems to suggest that memcache is infact hurting performance as shown below : My settings.php file : # Varnish reverse proxy on localhost $conf['reverse_proxy'] ...
1
vote
0answers
547 views

Server quit without updating PID file on multiple mysql installation in linux

Iam trying to install one version of mysql in a LINUX machine. The system contain already another version of mysql installation. I prefer manual installation. Copy the extracted tarball into a ...
1
vote
0answers
593 views

mysql fails to start

My Django web app was working fine, writing data to a mysql database. However, sometime in the past 36 hours or so, it stopped working. I typed "mysql" into the command line (i'm using ubuntu on ...
1
vote
0answers
118 views

Really slow execution

I own a wordpress installation, and Updated to 3.4.1. After the upgrade, I got a very strange slowdown to my wordpress. After all, I used the define('SAVEQUERIES', true); in my wp-config.php with ...
1
vote
0answers
196 views

SQuirreL Client: Opening up a table in a separate tab

I've switched to SQuirrel Client to view an Oracle database with a variety of tables. At any given time, I need to look at the contents of several related tables at the same time. The problem is ...
1
vote
0answers
1k views

MySQL Replication: Slave I/O thread constantly dying and starting back up

I have MySQL running on Debian 5 (Lenny) between two MySQL databases. The data is being transferring between the two machines, but one of them is logging the fact that it's slave I/O thread is ...
1
vote
0answers
116 views

Effective backup and archive strategy for database and linked files

I am using Postgres to store a variety of application data for a webapp. Part of the application involves storing and retrieving user uploaded files. I am storing the files in the filesystem with ...
1
vote
0answers
2k views

PostgreSQL: Could not connect to server even though it's running!

I wonder if you could possibly help me. I have installed PostgreSQL and I have tried running various checks to ensure it is running and I know it is. Here are the results of searching for the ...
1
vote
0answers
1k views

listener could not find available handler for requested type of server

I have ora-12520. I run Oracle 11g on Red Hat 4 64 bit. Actually I have RAC but one node is down and I work only with up one (connection string point directly to listener of running node). I run test ...
0
votes
0answers
6 views

Starting an Oracle database in upgrade mode?

I have an Oracle database instance running on a Windows 2012 server. I need to start it up in upgrade mode to run some configuration changes. However, I cannot find the right command to get it going. ...
0
votes
0answers
17 views

External email from specific database going to junk folder

I have migrated from Exchange 2010 to Exchange 2013, after which things are okay. I have four server plus two databases as below: Servers: CAS01, CAS02, MBX01, MBX02 Database: DB1 mounted on MBX01 ...
0
votes
0answers
81 views

Fatal error: mysql.user table is damaged. Please run mysql_upgrade

I resized an Azure VM and now the MySQL DB running in Windows inside the VM is dead. I am seeing the below fatal error on startup. I tried to run mysql_upgrade as it suggests but that just errors ...
0
votes
0answers
7 views

what are max_connections in amazon RDS?

I have seen a field called connections under current activity tab. My database instance has a max_connection of 52 . What does it exactly mean?
0
votes
0answers
22 views

Use Mysql as backend to Bind

I've bind installed on my server. I want to manage dns records and zone files through a web interface instead of directly editing the zone files on the file system. Developing a web app that ...
0
votes
0answers
30 views

small client-server app & db install location

We're running Server 2008 R2 on dual 2.8 GHz processors with 32 GB memory and a partitioned 1 TB, 3-disc RAID. Seems plenty robust for our purposes. Our primary application, however, has been lagging ...
0
votes
0answers
17 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
0answers
53 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 ...
0
votes
0answers
20 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
74 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 ...
0
votes
0answers
46 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
0answers
96 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: https://www.andreagrandi.it/2015/02/21/how-to-create-a-...
0
votes
0answers
28 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 ...
0
votes
0answers
42 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
19 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 ...
0
votes
0answers
45 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 ...
0
votes
0answers
8 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 ...
0
votes
0answers
23 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 ...
0
votes
0answers
26 views

DNS: check client IP in database, reply different if ip exists in a DB

I'm trying to setup a DNS server that looks for the client IP in a DB, and returns a static IP as result if the client is in fact in the DB. There might be thousands or a couple million of records ...