System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

-5
votes
0answers
41 views

Mysql dump failed? [closed]

My sysadmin made a backup of the DB from another server and imported it into a new one. If I login to phpmyadmin in the new server I see a table in the left column, but if I click into it, it says ...
-7
votes
1answer
44 views

Website own PHPMyAdmin

How to stop a client to access my databases if he uploads his own PHPMyAdmin in his website. We have a IIS server where user uploads there website through FTP and suddenly one user upload his project ...
0
votes
0answers
4 views

hide system databases sql server management studio [migrated]

I have installed sql server express 2008 and also sql server management studio. I've successfully configured remote connectivity and created a database user and password. my problem is that in the ...
0
votes
1answer
20 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 ...
1
vote
2answers
29 views

Does a server use bandwidth when connecting to itself?

I have a dedicated server (CentOS 7) with Storm on Demand. I have a rails application running on the server served by nginx and unicorn. I'm using MariaDB on the same server. The rails app handles ...
0
votes
1answer
25 views

prevent replace sql database files with old one

i have a database that i use in my application. the operation i want to prevent is if i stop sql server and take the database files to another location then start the sql server and make some ...
0
votes
1answer
18 views

Is mongorestore ditrectly to a path with the --dbpath faster than restoring to a running mongod instance?

What and how much is it faster: #mongod not running mongorestore --dbpath /var/lib/mongodb --db test /some_dump or #mongod running mongorestore --db test /some_dump ? I could not quickly find ...
-2
votes
2answers
28 views

How to work on 2 MySQL databases at the same time using PHPMyAdmin through Plesk? [closed]

I am trying to open 2 instances of PHPMyAdmin by clicking on the "manage database" link in Plesk. But the challenge is I seem to be only allowed to work on 1 database at a time as when I try and open ...
0
votes
0answers
23 views

Recommended servers for small databases [duplicate]

I work in a research institute in India. We have old Windows server 2003 SP-2 Standard Version. Of course we need to switch to a newer one. What are the recommendations for complete new setup ...
0
votes
1answer
16 views

Riak setup and LB?

Quick question about setting up riak cluster. Do I need load balancer in front of the cluster ? The cluster will have 3 nodes with N =3, so successful write must have the data in 3 nodes. Any ...
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
1answer
39 views

Securing Webserver and Database

I need to secure an internal web server and sql db, that is going to be made public(www) At this stage im only looking to provide a reasonable amount of security($$) until it gets bigger at which ...
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
1answer
31 views

Execute Trigger as Login

Is it possible to impersonate a login when running a trigger? I able able to run execute as 'username' but not execute as login='username' I can usee execute as as such with EXECUTE AS login='smr' ...
0
votes
1answer
49 views

OpenShift allow permanent external access to PostgreSQL [closed]

I have an OpenShift gear with Nginx and PostgreSQL, and need to allow a Java applet (served from Nginx) direct access to the PG database. I've already tried to edit ...
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 ...
-1
votes
2answers
893 views

DATABASE ERROR: CONNECTION FAILED! - when accessing round cube webmail after installing latest Mac Updates for OS X server

My server is a Mac Pro (2.4 Dual Xeon) with OS X 10.9.5 and running OS X Server version 3.2.1 - I installed the latest OS X updates for both Mavericks and Server on 9/20/2014 - round cube webmail ...
0
votes
0answers
38 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
14 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
31 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
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
31 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
107 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
52 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
8 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
115 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
23 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
63 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
57 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
229 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
215 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
166 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
37 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
73 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
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
1answer
32 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
281 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
96 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
78 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
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
votes
1answer
81 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
19 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
52 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
506 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
125 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
72 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
47 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
693 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 ...