System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

2
votes
0answers
118 views

nodejs postgresql database connection string

Is there a way where I can specify(include) both the master and slave server in nodejs db (postgresql) connecetion string in a replicated envirnment? My aim is 'if master is down then the read/write ...
2
votes
0answers
51 views

Alternatives to oracle flashback database/table functionality

Does anyone know of an open source tool or similar that covers the same functionality as the Oracle EE built-in flashback database and flashback table features? I'm considering going from Oracle EE ...
2
votes
0answers
49 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
1k 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 ...
2
votes
0answers
117 views

lost tables in drupal site database

i have drupal site on my local server build using pressflow i had problems with the xammp 1.7.4 server so i delete it except the mysql and htdocs folders i installed the server again but the drupal ...
2
votes
0answers
91 views

How to do Merge Replication?

I tried to do synchronization of database between servers to synchronize a database using merge replication. Simply I've added publication in server A and subscription in Server B by declaring ...
1
vote
0answers
39 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
67 views

connect database with sequel pro

I have install lamp centos on linode, I can use ssh login on terminal app, How to use sequel pro connect to my host database? in sequel pro I input below content but it not work Name: project MySQL ...
1
vote
0answers
69 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
345 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
361 views

Zabbix no free space on disk

I have zabbix 2.2.1 and 252 monitors the hosts. Currently, the database is in local and size database is 65GB is running housekeeper who clears history entries older than 30 days. Entries are deleted, ...
1
vote
0answers
61 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
222 views

Changing Cassandra Tokens on 1.2.1 From 4 to 256

We initially started our cluster using one datacenter, one rack, and the Simple replication strategy. We have keyspaces with several hundred gigabytes of data. When we changed the tokens in the ...
1
vote
0answers
67 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
527 views

Connections being intermittently left open on JBoss for requests from clients

The issue I'm having is that occasionally a connection for a clientside request + the assosiated DB connection (using Oracle 10g RAC) get left open on JBoss EAP 4.3.0 CP10. Also a JBM JMS queue ...
1
vote
0answers
20 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
172 views

Neo4j Web Server Hangs: Logging Issue?

I have a small database that was working fine just a day ago, but now, when I try to start it, the console claims that it succeeds in opening, but the web server hangs. lsof -i | grep 7474 states ...
1
vote
0answers
425 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
315 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
127 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
29 views

Server error with large posts

On a large drupal site, the database server is on a separate server connected directly to the web server. The web server uses apache and memcached. The problem is that whenever the post is a large, ...
1
vote
0answers
370 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
344 views

Installation of Access Database Engine 32-bit Fails

I am trying to install Access Database Engine 2007 32-bit. The splash screen comes up, you click "Next", then it fails with the error: Installation ended prematurely because of an error You click ...
1
vote
0answers
526 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
101 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
90 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
252 views

Error when using mysql to create or change users

I went to change passwword on my mysql user to make sure it was correct for wordpress and when i did it i got Failed to save user : SQL flush privileges failed : Table 'mysql.servers' doesn't exist so ...
1
vote
0answers
752 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
96 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
1k 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
828 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
17 views

Deploying grails application to iplanet webserver

I asked this question in stackoverflow and was advised to ask here. I have project that connects to a few Oracle 11g databases. So I have 3 different logins. This does fine when I run it locally from ...
0
votes
0answers
16 views

Accessing an MS access db from multiple WAN locations

I'm after some ideas on how best to provide a solution that one of my customers requires. They have a legacy system which they use as a type of Customer Relationship Manager. Its essentially an MS ...
0
votes
0answers
18 views

Duplicate DB and files

I'm creating a group of websites using the CMS Concrete5 has models to be presented to my clients. My idea is that they can choose each one they want and deploy a new subdomain with a model ready to ...
0
votes
0answers
24 views

Percona connectivity issue, user cannot connect?

I am trying to authenticate a user in percona but I am seeing the error message below each time I try... 2014-09-29 12:43:37 5028 [Warning] The plugin '0' used to authenticate user 'user@' is not ...
0
votes
0answers
36 views

jboss 7 connection to database vip fail

Jboss 7 is connecting to HA database with VIP. When master db fails, the HA kicks in and slave db takes over as master. Querying directly the new master db works fine. However, at Jboss level, the ...
0
votes
0answers
13 views

WLS: Identifying the managed server where a DB session originates from

We are using WLS servers, on which we configure data sources (DS) and managed servers. For failover reasons, our main application is depolyed on two separate managed servers (lets call them app_1 and ...
0
votes
0answers
30 views

Write Failed Request Tracing logs to a database

I'm using Failed tracing logs on my IIS 7 which are a very good source of debugging information. Theses logs are written on the hard drive but I would like IIS to write them directly to a database, ...
0
votes
0answers
26 views

Freeswitch Database Hangup Causes

I am looking at our Freeswitch database for the VoIP service my company provides and trying to investigate an issue with a particular router. I see from a CDR (Call Detail Record) in the Freeswitch ...
0
votes
0answers
60 views

SQL DATABASE USING VPN

I have a very simple classic asp site on a Windows 2008 Server with an IIS 7.5 that connects to an Sql database on a Sql 2008 r2. the site works perfectly when accessing it both locally from the ...
0
votes
0answers
157 views

Removing Orphaned user from MS SQL Server 2008 database fails

I am dealing with an issue where a User is not able to logon with the database Username & Password all of a sudden. In the past I have reported orphaned users by running these 2 commands: USE ...
0
votes
0answers
91 views

indexing a ~3gb database into elasticsearch: how?

I have a new database of 2 million records (around 3gb when dumped json) produced every several days. I want to quickly put it into ElasticSearch. That's what I do right now: Create a new index and ...
0
votes
0answers
18 views

It's possible to have a Distributed Bogofilter database?

We've Bogofilter running on our AntiSpam system and I would like to distribute it's database through the two MX gateways that we have. I know it's possible using SpamAssassin with a shared MySQL ...
0
votes
0answers
70 views

Why postgres 9.3 table keeps losing the primary key and indexes?

In pg 9.3 database, table engine_configs keeps losing primary key (id) and indexes. Here is the table: For the table shown above, we just added the primary key again and it is showing integer in ...
0
votes
0answers
379 views

MySQL Workbench Could not connect to Source DBMS

I have a server which has a MSSQL database and i trying to data migrate from MSSQL to MySQL, in the first stop after i choose database --> data migrate --> i choose data system (Microsoft SQL server) ...
0
votes
0answers
177 views

authenticating and authorizing linux users kept in mysql database using pam and nss

I am not able to authenticate and authorize users present in my mysql database. If someone can point out where I am wrong it would be very helpful.Following are the steps that I followed. Firstly I ...
0
votes
0answers
22 views

Cluster Manager Ignoring Config File

I have just setup my first cluster manually (not using the auto install) and it all works great. I have 1 SQL node, 2 data nodes and 1 management node (all on separate machines). I intend to port ...
0
votes
0answers
22 views

What mysql configuration offers the highest write performance

Which multiple mysql server configuration offers the highest write performance? We are looking at changing a web application which is heavy write and want to know what configuration is going to give ...
0
votes
0answers
194 views

AIX JFS2 I/O performance problems

I have a fresh installation of AIX 7.1. I noticed that JFS2 file system with logging enabled (log=/dev/hd8) is dramatically slower than one with log=NULL. Simple zip archive extraction takes 5 minutes ...
0
votes
0answers
98 views

Riak Backup restore process is very slow for large database

I have 5 node cluster of riak database. I have take backup of this database & trying to restore it with riak-admin. But it take too much much already 7days has passed & still restoration ...