System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
1answer
179 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
219 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
224 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
300 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
161 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
99 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
536 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
116 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
108 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
200 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
149 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 ...
1
vote
1answer
426 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
169 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
577 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
votes
1answer
50 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
681 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 ...
0
votes
1answer
192 views

WordPress - MySQL server has gone away

I have a WordPress install on a dedicated server with decent memory (upwards of 8GB). The WordPress install includes many plugins - 50 active plugins. Most important to note is the WPML plugin to ...
0
votes
1answer
45 views

debian stable raid autogrow filesystem database

I need to setup a debian stable system meeting the following needs: Hard disks should be mirroring : Raid 1 Filesystem(s) should autogrow if possible (just in case we replace one hdd with a bigger ...
2
votes
2answers
167 views

SSH access for hundreds of thousands of users

I need to setup a solution similar to GitHub, where users can SSH to their git repository. This should scale for hundreds of thousands of users, so my idea is to use a distributed filesystem for the ...
0
votes
1answer
267 views

Is an ms-sql/excel connection two way?

When I connect to an external data source on my MS-SQL server using Excel, is it solely an import, or can I edit the data residing on the MS-SQL server right from Excel? I have a user (the DBA, funny ...
0
votes
1answer
539 views

Is weblogic 10.3.6 data source connection pool maximum capacity per domain or server?

My WLS server is connecting to an Oracle DB that has a maximum concurrent connection limit of 3. I have created a data source in WebLogic and set the "Maximum Capacity" value to 3. Is this value ...
0
votes
3answers
170 views

Amazon Linux EC2 Webserver / MYSQL Upgrade – Traffic causing error establishing a database connection

To give you a little background, I currently have a website that allows users to upload photos. The website was initially on a GoDaddy shared server, but recent surges in traffic have forced me to ...
1
vote
0answers
72 views

Tell proftp to allow connections only to the users that have permissions in PostgreSQL

I'm trying to set up an ftp server for the first time (under Debian Squeeze) and after searching through Google, I decided to use proftp. NOTE: I have a PostgreSQL server running in the same machine ...
1
vote
2answers
155 views

mysql fails every day at the same time and when many requests occurs

I am some problems with my mysql database. I configured a server with the database and other services (apache, php) and put run multiple applications. There are two problems. The first: Every day ...
1
vote
2answers
145 views

Indepedent pairs of RAID 1 is superior to RAID 10

I am rather new to databases. I was reading up on RAID Storage and it seems that the consensus is that RAID 10 is RAID 10 is best is terms of performance and redundancy However at the end ...
-1
votes
1answer
43 views

CISCO router GUI management

Is there any simple solution to connect to routers database with GUI? I mean is it even possible to find an application which could do the configuration without the need to push commands? Thank you ...
5
votes
4answers
428 views

Is MySQL required on both the database server and the webserver? why?

Is MySQL required on both the MySQL database server and the web server that it is connecting to? If it is required on both the web server and database server, please explain why this is. Moreover, if ...
1
vote
1answer
133 views

Choosing the right database/storage engine for iptables ulogd

I'm looking for some help choosing a database backend for a iptables ulogd setup. We are going to swap out our current proprietary firewall solution with iptables and one of the requirements is to ...
1
vote
1answer
327 views

How do I change the config_file location of a postgresql database for “service postgresql start”?

I had a PostgreSQL 9.1 db that I just upgraded to 9.3 using /usr/lib/postgresql/9.3/bin/pg_upgrade -b /usr/lib/postgresql/9.1/bin -B /usr/lib/postgresql/9.3/bin -d /var/lib/postgresql/9.1/main/ -D ...
2
votes
1answer
69 views

Alternatives to oracle flashback database/table functionality

Does anyone know of an open source tool or similar that covers the same functionality as the Oracle EE built-in flashback database and flashback table features? I'm considering going from Oracle EE ...
0
votes
1answer
174 views

Which db managment software can copy from one sqlite3 table to another for fields which are common in both?

We are looking for db management software which can copy from one sqlite3 table to another for fields which are common to both tables. For example, if table A has column name and address. Table B has ...
0
votes
1answer
21 views

OpenBase server database connection troubleshoot?

I am troubleshooting a workstation/server instance in which an application hangs while interacting with our Windows 2003 Server OpenBase-hosted database. In short, the application will go into "Not ...
0
votes
1answer
689 views

Migrate to AWS from Linode

Migration to another server is not easy when we have a large database. We want to move our database in Linode to amazon RDS database, i tried to pg_dump and pg_restore and it succeeds but it consume a ...
1
vote
1answer
101 views

Does converting a disk from basic to dynamic require a reboot?

I'm finding conflicting info on converting a disk from basic to dynamic and have a few questions. Will it require a reboot? The server with the disk in question is hosting SQL Server 2008 R2, and ...
1
vote
2answers
585 views

Can remote queries cause locks?

We have a SQL Server 2005 (SERVER-A) server that holds the database for an application that has been locking a lot lately. We suspect that the problem are transaction locks, so we decided to capture ...
2
votes
2answers
6k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
0
votes
1answer
115 views

How can I change the Postgres data_directory folder location?

I use Ubuntu 12.04, postgresql 9,1 postgis 1.5. I want to change database location. I use instruction http://www.whiteboardcoder.com/2012/04/change-postgres-datadirectory-folder.html The only ...
2
votes
1answer
130 views

Protect a public-facing PostgreSQL server against abuse

I have a Postgres database containing public information that I'd like to expose to the internet, for anyone to use. What steps can I take to prevent: Excessively expensive queries that could hog ...
-5
votes
1answer
56 views

Ticketing server database security [closed]

I want to setup a ticketing system which will show the seats available instantly. However, for security, I do not want to open my database in internet. I want to setup a server which has public IP and ...
0
votes
1answer
2k views

sql error “Service Broker needs to access the master key in the Database ”xxx" Master Key has to exist

I am pretty new to SQL and administration of databases and still learning. We receive one SQL error for quiete a long time, which has as far as we know no effect on our application. So we put that to ...
0
votes
2answers
90 views

Possible to take a backup of SQL Server 2012 DB and restore on 2008?

I want to take a backup of SQL 2012 and restore on 2008, is that possible ? I have this options which I can't change on DB. Thank you
0
votes
1answer
209 views

Several Server Errors (No database connect, can't create TCP/IP socket etc

My server stops taking requests on my website today. It works for some time, but then the server just stops working and throws several errors: 500 Internal Server Error Warning: mysql_connect(): ...
0
votes
2answers
63 views

Ubuntu 10.04 database connection problems

I'm having some problems with a legacy program I'm starting back up. We had an image of this server, and the setup is Ubuntu 10.04, 5gb partition for mysql database, and 100gb filesystem. My issue ...
0
votes
1answer
68 views

MySQL Replication fix after server shutdown/start

Server1 is Master Server2 is Slave Both are in our AWS testing env and we stop them once done with our work. When start again, Master rotates/creates new binary log file but slave keep looking for ...
0
votes
1answer
294 views

MySQL Creating a Database CentOS (6 - 64bit) Error 1064 (42000)

When ever I type in : GRANT ALL PRIVILEGES minecraft.* TO 'minecraftu'@'%' IDENTIFIED BY '********'; It gives me an error of : ERROR 1064 (42000): You have an error in your SQL syntax; check the ...
-2
votes
1answer
58 views

Adding and Removing MySQL Databases via CentOS 6 - 64 bit

I have a VPS, and am having troubles with MySQL. I think I have created a database, but got lost. I need to know how to: Add a database, with the username, name of the database, and password. ...
0
votes
1answer
266 views

Rails application keeps timing out when attempting to connect to Postgresql DB

I'm hosting a postgresql database on a small windows azure Ubuntu 13.04 VM with a default postgresql.conf. I have a Rails application running on a medium windows azure Ubuntu 13.04 VM. When accessing ...
0
votes
1answer
713 views

Users database empty after Samba3 to Samba4 migration on different servers

I have to migrate a Samba 3 to a new Samba 4 server. My problem is that the database on the samba 3 server seems a bit empty. The secrets.dtb file is only 20K whereas the “pbedit -L |wc -l”command ...
-2
votes
1answer
81 views

Is There any way to change Active Directory Users Database Source?

I need Active Directory Use My Own Custom Database (or shell or ...) for Authentication Users. Is there any extention or something like this to change User Passwords Database of active directory? I ...
0
votes
2answers
501 views

Connect to MySQL EC2 Instance outside of VPC

I have a VPC setup with a few EC2 instances inside. I'm attempting to connect to a MySQL database on an EC2 instance outside the VPC, with no luck. I have the security groups on the VPC EC2 ...