System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

-6
votes
1answer
57 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
515 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
133 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
78 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
883 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
122 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
73 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
366 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
398 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
181 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
5k 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
52 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
266 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
79 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
48 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
1k 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
144 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
509 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
26 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
62 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
24 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
295 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
132 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
637 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
72 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
399 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
149 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
399 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
41 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
210 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
184 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
151 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
154 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
191 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 ...
3
votes
5answers
236 views

MySQL DB Backups: Lockless, Per-Table Restore, MyISAM/InnoDB

The Problem I'd like to implement a MySQL backup strategy on a dedicated server. It has multiple databases on, combined total is about 150GB. Most of this is weighted toward one of the databases. ...
0
votes
1answer
128 views

Cannot open './/ib_buffer_pool' for reading: No such file or directory

I've realised that my Percona DB which has several InnoDB tables doesn't actually have InnoDB buffer pool running as it wasn't specified in the my.cnf. I had a buffer pool size specified of 256MB, ...
-4
votes
2answers
96 views

Is RAM size related to SQL performance? [closed]

I have some simple code that generates 3 millions insert queries. I have two VPSes, one with 512MB RAM and one with 2GB RAM. On the 512MB RAM VPS, I can insert about 50,000 rows in 5 minutes. On the ...
1
vote
0answers
428 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
2answers
84 views

Scaling web application across multiple services

We're developing our web application and have been working on reducing our load times. When we began developing the application, we signed up with a well known hosting provider offering "dedicated ...
-1
votes
1answer
94 views

How to find a database location on server using phpmyadmin?

I am pretty new to managing servers, right now I have trouble to find the location of our database. I see the DB in phpmyadmin, is there a way to find the real location using phpmyadmin ? Running ...
1
vote
2answers
150 views

How to force sqlite3 table to take next available id for auto increment in firefox sqlite3 manager?

We delete some records in a sqlite3 table (re-id record manually) and compact the db. However when adding a new record in firefox sqlite3 manager, the auto incremented id is not the next available id ...
0
votes
1answer
116 views

Site security - how to filter incoming traffic to a specific port

Just ran a security test on ScanMyServer.com, the results showed a medium risk vulnerability: Database Reachable from the Internet Summary: The remote host is running a database server that is ...
0
votes
1answer
268 views

MSSQL: Restore a DB to the latest file in a backup set

I have a MSSQL 2008R2 DB in SIMPLE recovery mode that is periodically backed up with BACKUP DATABASE MyDB to DISK = 'Z:\MyDB.cbak' WITH COMPRESSION This runs periodically, creating multiple ...
0
votes
2answers
144 views

How to benchmark maxCache 3.0 with SSDs? [duplicate]

We're a software development company and previously outsourced the HW side of business but now we're looking into building our own private cloud. We recently purchased a few servers, one of which is ...
1
vote
4answers
474 views

Random IP's constantly trying to connect to SQL Server

We are building a cloud-based application that relies on a login database as well as many individual client databases. Using rackspace we have setup a server (windows server 2012) with SQL Management ...
1
vote
1answer
15 views

Serverlocked Ip because of passing special characters to database

Hi My server blocked my ip and sent me the reason below, Kindly check the logs and above path with your developer and take necessary action to avoid this in future. Logs: ------ [Tue Jan ...
-1
votes
1answer
47 views

Scalable Cloud solution for High Availability [closed]

Scenario: I am about to launch a cloud software in a couple months. This will be a SaaS solution for multiple clients. The software deals with Healthcare o Encryption at rest is a requirement. It is ...
0
votes
2answers
599 views

MySQL - Slow query - wp_options table. Website unable to handle traffic

After spending several days researching, I have placed a website on a c1.medium instance, Amazon Linux, and the MySQL database on a db.m1.instance. The RDS is running MySQL version 5.6.13. I have ...