System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
0answers
51 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
1answer
29 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
1answer
36 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 ...
0
votes
0answers
42 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
62 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 ...
2
votes
1answer
203 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
59 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
14 views

SQL Installation Error In Memory, Can i just add a database to an existing SQL Instance

We have an SBS running 4x SQL 2008R2 instances. i need another for the antispam product but the install fails with an error about possible corrupt memory. I've done some digging and re-installing all ...
0
votes
1answer
174 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
26 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
69 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
81 views

Should I move to an Azure database? [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
260 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
728 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 ...
1
vote
2answers
2k 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
65 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 ...
0
votes
1answer
103 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
81 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
190 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
1answer
70 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
374 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
140 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
2answers
187 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
103 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
130 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
29 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
75 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 ...
10
votes
3answers
546 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
192 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
117 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
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
1k 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
155 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
75 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
463 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
3k 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
479 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
202 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 ...
2
votes
1answer
7k 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
55 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
393 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
102 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
58 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
2k 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
167 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
790 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
66 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
403 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
161 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
172 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 ...