System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
1answer
45 views

Can OpenVPN routes be stored in a database?

I'm trying to develop a simple custom intranet web-based tool to manage OpenVPN routes so that they can be added and removed without having to edit the config file. Is there any way to make OpenVPN ...
2
votes
1answer
467 views

mongodb keep looping while trying to sync data

I'm converting my my standalone mongodb into a replica set. I've added one more member (and I want to add two more members later, and to shutdown the primary server). My primary mongodb is running ...
1
vote
1answer
104 views

Databbase file structure on disk [closed]

I'm an interested in the fundamentals of databases for a project that I am currently working on. Specifically the physical storage on disk and how rows and indexes are stored in a file. For the most ...
0
votes
1answer
381 views

Percona slave crashes with “unexpected PLT reloc type”

I have 2 data centers each with a master/slave database running Percona server 5.5.23. For some reason, one of the slave databases crashed with this error: 03:00:40 UTC - mysqld got signal 11 ; ...
-1
votes
1answer
31 views

Moving MYSQL database Cache issue?

I moved a mysql (myisam) database using rsync to aother server, I realized after doing this that I forgot to run 'flush tables' before moving the files so not all changes were written to disk I guess. ...
-1
votes
1answer
79 views

Will an average PC run a 10 concurrent write intensive request with 50MB daily database server? [closed]

As I am a average programmer who have never been purchasing any hardware myself, I have to choose a computer for a prototype database server that will be used to serve 10 concurrent request per one ...
0
votes
1answer
183 views

What are the advantages of moving to an Azure database server then installing it directly [closed]

I am currently using a database from an installed instance on my web server in a VM on Azure. I was thinking about moving it to an actual Azure Database so I could load balance the web server. Does ...
0
votes
1answer
344 views

Forced reboot caused /var/lib/mysql to 'disappear'

During the nigh my provider had to force reboot the server (pull the plug), after boot, there was a problem with the MySQL server (I'm using MariaDB). After hours of research I can't find the main ...
0
votes
2answers
2k views

Microsoft SQL Server Standard High Availability without Shared Storage

I'm a software dev with little experience managing SQL so please bear with me! We are developing a piece of software that needs to be highly available, with a significant degree of resilience. This ...
3
votes
2answers
9k views

MongoDB Auth, can be authenticated in the shell but not via the command line

I have an application that connects to a MongoDB database called discussions. I've created a user Mongo shell: > use discussions switched to db discussions > ...
1
vote
1answer
99 views

htdbm and mod_authn_dbm fail when migrating between apache 2.2 servers

I'm migrating an existing website from Apache 2.2.4 on Gentoo 32-bit to Apache 2.2.27 on CentOS 64-bit. This particular site uses DBM for authentication with encrypted passwords. On the old system ...
1
vote
1answer
175 views

Very strange disk-usage for replica in Mongodb

tl;dr: the new 2.6 replica eats up a lot more disk space than the 2.4 members. We're heavy users of MongoDB's GridFS. We're currently on 2.4, and are intending to upgrade to 2.6 by simply adding a ...
0
votes
0answers
121 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
1answer
168 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 ...
4
votes
1answer
502 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
238 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 ...
1
vote
2answers
215 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
votes
1answer
186 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 ...
-6
votes
1answer
113 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 ...
11
votes
3answers
616 views

What types of systems have to “scale up” rather than “scale out”?

I have been wondering for a long time if there are systems that have to "scale up" (onto a more powerful, more expensive server) rather than "scale out" by being split across many smaller servers. ...
0
votes
1answer
454 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
1answer
48 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
4k 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
343 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
80 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
1answer
692 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 ...
-1
votes
2answers
5k 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)
9
votes
1answer
17k 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
57 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 ...
2
votes
1answer
694 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
149 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
76 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 ...
3
votes
2answers
3k 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
243 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
2k 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 ...
-1
votes
1answer
74 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 ...
5
votes
1answer
746 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
1answer
336 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
290 views

Phpmyadmin table disappears, but website reads it perfectly

When I log into phpmyadmin, it only shows the information_schema. I have only one table that has been showing perfectly, but one day it decided not to show up. My website reads all the information in ...
1
vote
1answer
2k 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
96 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
844 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
344 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
784 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
103 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
405 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
241 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 ...
2
votes
1answer
386 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
483 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
325 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 ...