System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
0answers
13 views

Data management and security for Django alongside C++ server using websockets [on hold]

The application currently uses a C++ server which communicates with the client through websockets, and uses django for user and data management. The issue is that the client can send messages to ...
0
votes
1answer
22 views

Windows Application that extracts pdf files from database [on hold]

I am trying to make a Windows desktop application that connects with a database and then extracts certain pdf files from it and make it available to users. As this is my first time creating a windows ...
0
votes
0answers
7 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 ...
-1
votes
0answers
17 views

Architecture for low-latency RESTful server on Amazon EC2 with Node.js and a database [migrated]

This is a question for DBAs with a lot of practical experience with large scale deployments. We are trying to build an app with very low latency. (We really want to create the best user experience, ...
0
votes
1answer
17 views

Providing database connection via web server

I am creating a database (in PostgreSQL, but this question is hopefully independent of the underlying DBMS) that will be hosted remotely. Most access will be provided through a web-based front end ...
3
votes
1answer
134 views

Latency & speed considerations between 2 servers on Amazon EC2

I'm setting up a system that consists of: 2-4 database servers 2-4 webservers (running Node.js) The webservers use the database servers heavily. Aside from connecting to the private IPs of the ...
0
votes
0answers
25 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 ...
2
votes
0answers
16 views

MySQL Stored Procedure Requiring SUPER [migrated]

I'm trying to figure out a "safe" way of allowing a non-SUPER user to execute a specific command requiring SUPER privileges, i.e. SET SESSION binlog_format = 'MIXED'. I don't want to grant the user ...
-1
votes
0answers
9 views

How to manage “up to date” data and data “in use” [closed]

On my CMS, we can update/modify data. I want to implement a "deploy" function ,which can be used by only moderators, to save this data and enable access to it through my webservice. Only data ...
0
votes
2answers
53 views

What is the best/most secure way to download/send/keep offline backups?

I have a small app that uses MySQL. I'm on a small Ubuntu box using Apache on Digital Ocean. In case anything ever goes wrong, I would like to have something that periodically sends me or downloads in ...
1
vote
0answers
33 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
votes
1answer
21 views

Telnet to localhost 3306 looses connection to host after few seconds

When I try to telnet into my localhost port 3306 which belongs to mysql, it shows me the hello packet, then looses connection after a few seconds. My skip networking is set to OFF, I have started and ...
0
votes
0answers
12 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 ...
-6
votes
1answer
33 views

Database Backup using DOS commands or any other useful commands [closed]

I am planning to backup my database files from network drive to one other. Here is my requirement: All database should be backed up excluding certain file names starting with msdb, model etc. this ...
5
votes
2answers
355 views

Are there any systems that have been forced to “scale up” rather than “scale out”? [on hold]

I have been wondering for a long time if there have been any systems that have been forced to "scale up" (onto one very large, even more costly server) rather than "scale out" onto many smaller ...
0
votes
1answer
40 views

What are the pros and cons of using S3 as a data access server? [closed]

I need to manage some configuration files. The files can be stored on AWS S3 and retrieved via the URL. The alternative is to use an application server and store the JSON content to a database and ...
0
votes
0answers
22 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
1answer
42 views

Different technologies for syncing with server

Well, I'm currently teaching DB in a course in University. Students had already gone through advanced programming (this includes torturing them through a whole semester with massive projects, they ...
0
votes
1answer
85 views

After editing my.cnf MySQL fails to restart

I want to edit the /etc/my.cnf file. I've tried to use this as the file content: [mysqld] set-variable = max_allowed_packet=24M set-variable = max_connections=300 log-slow-queries safe-show-database ...
-1
votes
1answer
43 views

Cannot access my database, it says database inaccessible

I am hositng my application on a server but runs my Sql server in windows mode as application is still bieng developed. But suddenly when today I opened my Sql Management Studio, it is not allowing me ...
0
votes
1answer
57 views

Taking database from possibly cracked server

I have a server which is behaving erratically. While I investigate if it's been hacked, I'm also thinking about my backup options: As many posts have said the only way to truly know you're clean is ...
0
votes
0answers
24 views

SAP HANA & CASSANDRA Data Integration

is there a way or method to integrate cassandra and sap hana for real-time data replication from sap hana to cassandra ? Is there any ready tools available to use ? Thanks.
0
votes
0answers
58 views

MySQL won't start after reboot. Exiting with signal 11

last night I was doing a server maintenance that required DB reboot. No changes in a config were made. Current setup is as follows: master (server1) - master (server2) and slave (server0) MySQL ...
-2
votes
2answers
523 views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using Password:YES) [closed]

root@test-2:/usr/local# mysql -u root -H 192.168.x.xxx -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
0
votes
0answers
117 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
69 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 ...
1
vote
1answer
467 views

how to connect to mongodb server via ssh tunnel

It was easy for me to connect to my remote mysql server on AWS using a sequelpro, however I'm struggling with doing the same thing with mongodb. I tried setting up an ssh tunnel via command line ...
1
vote
1answer
41 views

Distributing load from Django App

I am currently approaching stages to move my first large-scale application out of development. I have talked with some CTOs who know what they're talking about, and I have been advised to do the ...
1
vote
1answer
59 views

How does fail2ban 0.9 database storage actually works?

Fail2ban 0.9 introduce database storage to save bans on restart. But I can't find out the actual mechanism of it work. There is dbpurgeage parameter which controls lifetime of old bans, defaults to ...
0
votes
1answer
57 views

How to determine VMware ESX server requirements for n VMs?

I am going to buy a high-end server for my department's daily usage. On this server, I am planning to launch 2 DB servers, 2 Application Servers and around 10 ordinary development PCs on the VMware ...
0
votes
1answer
26 views

OSAS v4 Open Systems Accounting Software [closed]

My company recently purchased another company and along with it, came an old SCO Openserver (v5) running OSAS v4. We use TinyTerm as recommended to access this but no one knows how to use it. I've ...
2
votes
2answers
146 views

OpenSSH and PAM authentication using a public key

I'm looking for a way to authenticate users using a public key which is stored in a db (MongoDB). Similar questions usually resulted with a suggestion to installed a patched version of OpenSSH ...
-1
votes
1answer
57 views

AWS route 53 database hostname best practice [closed]

So I have 3 components all connecting to same db. Should I use: comp1.domain.io comp1db.domain.io comp2.domain.io comp2db.domain.io comp3.domain.io comp3db.domain.io Or: comp1.domain.io ...
0
votes
1answer
134 views

Why are changing Zabbix's triggers status to unknown?

In zabbix I have an item which i create some triggers for that on below conditions: {Server Template:mysql.slowqueries.last(0,1800)}>{Server Template:mysql.slowqueries.last(0)} {Server ...
0
votes
0answers
16 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 ...
-1
votes
1answer
39 views

Storing unencrypted web app / WordPress passwords - explain to a client

I have a problem with a client who is complaining about a WordPress installation having an unencrypted MySQL database password in the wp-config.php file. I've tried explaining this to him by stating ...
0
votes
0answers
19 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 ...
5
votes
1answer
118 views

Is there a Informix command to repair database?

We have a Sun Solaris system running Avaya CMS software. The software uses an Informix database. We have a single drive in the server. The drive began to go bad, corrupting files. We sourced a new ...
2
votes
0answers
60 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 ...
1
vote
1answer
71 views

How export database from mssql by using command line

I am using windows7 os and i have a database on MSSQL server 2005 i am using following codes to import database sqlcmd -S [server instance name] -d [database name] -i [filename you want to import] ...
1
vote
0answers
58 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 ...
0
votes
1answer
150 views

Pgpool configuration with Liferay cluster

I'm using a Liferay cluster connected to pgpool2 and when I run heavy user activity against the web servers I see a lot of exceptions regarding liferay unable to establish a connection to the DB. ...
0
votes
2answers
71 views

Alternative to FTP

I'm now teaching data bases and all my students get access to a virtual machine running ubuntu. They use FTP as the main way of connecting to the server and uploading their PHP files. Last time I was ...
1
vote
0answers
123 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
1answer
20 views

Error in cross server sqlcmd execution due to firewall issue

I have an application server with an IP of 10.107.0.100 and one database server on which SQL Server 2012 is installed, with an IP of 10.107.0.101. Remote connections are made to this server, and the ...
0
votes
0answers
71 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 ...
-1
votes
1answer
129 views

webserver on linode and database on digital ocean

Currently hosting drupal websites on linode using apache + php5 fpm+ fastcgi. Among websites one is drupal commerce(max_execution_time,memory_limit are taken care) and all others are low hitting ...
0
votes
1answer
60 views

Oracle Database suddenly fills storage device in about 20 minutes

My Oracle instance up on Amazon's RDS filled a 20GB storage in the space of about 20 minutes. I checked all the applications that use this DB and nothing looks out of the ordinary - I can't figure out ...
4
votes
1answer
56 views

Regarding High Availability for MSSQL Server

Already used in MySQL : Real Time Replication (synchronization) between primary and secondary server is done using master and slave commands. So What is the equivalent feature for MsSQL. Which ...
2
votes
2answers
111 views

Database server (MySQL) on SSD - trim command

I can't seem to find much expert information about using a database servers on SSD with regards to trim. I know I can enable RAID and LVM discard, and use an fstrim / cron job or the discard mount ...