System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

-2
votes
1answer
38 views

Fix WSUS related DB bloating, Uninstall & Install issues on SBS Server 2008?

Environment: SBS Server 2008 DC/ Domain Server: Windows Server 2008 FE Microsoft Windows Server Update Services 3.0 SP1 - MMC SUSDB.MDF started at 14.x GB and when trying to use the Updates ...
3
votes
1answer
1k views

Large lag on mysql replication (Relay_Log_Pos and Exec_Master_Log_Pos does not increase)

Today my two slave's (one mysql 5.1 and second MariaDB 5.5, master is mysql 5.1) started lagging. Similar situation are quite often with lags rises to even 10000 seconds, because slaves have worse ...
1
vote
1answer
2k views

DB2 Integrity Checks and Exception Tables

I am working on planning a migration of a DB2 8.1 database from a horrible IBM encoding to UTF-8 to support further languages etc. I am encountering an issue that I am stuck on. A few notes on this ...
1
vote
2answers
29 views

cassandra data migration from regular drive to SSD on production server

we want migrate our data from regular drives on production server to new SSD drives. how we can do that without taking down the node no longer than 4 hours(hinted hand-off is 4 hours) our data is in ...
-1
votes
1answer
26 views

Installing postgres on Cent OS

I am having a hard time getting postgres re-installed on Cent OS 7.2.Here is what I tried. Went to YUM repo of postgres Created a temporary folder on my machine for the RPM file Did wget ...
0
votes
1answer
1k 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
9k 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
53 views

ownCloud Unable to Connect to Local Database on Fedora 23 (LEMP stack, selinux permissive)

The Problem I am having a very strange issue where ownCloud seems unable to access my SQL database, using nginx, mariadb, and php-fpm running on Fedora 23. When I attempt to access the page, I get ...
0
votes
2answers
17 views

MariaDB taking ages to restore backup

So I did a mysqldump of a pretty huge db and I'm trying to restore it now using: mysql db_test < db_test.sql but it looks like it's not gonna end by the end of this year. It's been about an hour ...
1
vote
1answer
1k 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
3answers
149 views

Database select error

Database select error its my problem and when I restart my mysql to fix this error this problem solve but after 30 minutes or after hours again this error happen again. I put link here screenshot ...
0
votes
2answers
19 views

cassandra nodetool drain running for days

We are having performance problems with our cluster regarding to timeouts when repairs are running or massive deletes. One of the advice I received was update our casssandra version from 2.0.17 to ...
2
votes
4answers
14k views

How do I dump view schemas for a MySQL database?

I have a MySQL database for which I wish to dump schemas for views. How do I do this? I tried mysqldump with --no-data, but that only dumps table schemas.
1
vote
1answer
3k views

Recover mysql database innodb 'table doesn't exist'

Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd. I've tried the ...
0
votes
1answer
4k views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
0
votes
1answer
3k views

Command to list event monitors in DB2

I see the following commands: drop event monitor set event monitor create event monitor But nothing like list event monitor or get event monitor. Is there a DB2 command to list all current event ...
1
vote
1answer
2k views

Need DB2 OLEDB Driver / ODBC Driver

I am trying to establish a connection between excel and db2. I am able to successfully query and retrieve data from my DB. I am using the below connection string ...
54
votes
4answers
63k views

How do I load a sql.gz file to my database? (importing)

I'm trying to import a gzipped SQL file into mysql directly. Is this the right way? mysql -uroot -ppassword mydb > myfile.sql.gz
1
vote
0answers
16 views

Certificate is not showing up in SQL Server

I need to say first that I am not a DBA and so, my problem is getting SQL Server Configuration Manager to recognize a certificate. I have 3 SQL Instances I work on, 2 are on the same network, the ...
0
votes
1answer
18 views

Best performance- and backup-strategy with running multiple Webapps and databases on dedicated servers

my company is soon going to move our webservice-hosting to a new hoster and therefore i'm currently planing how everything will run in the future. I have to deploy at least: MsSQL-Database Server ...
-1
votes
0answers
10 views

Mysql Dump and exclude a bunch of tables via a wildcard

I've searched and couldn't find a clear answer to go about doing a mysql dump excluding a bunch of tables using a wildcard. I know mysql has the --ignore-table option, but I would have to list out ...
0
votes
1answer
34 views

Does AWS support DBF files or Samba Shares?

We have DBF files running in our local network. It's on an Ubuntu Server running Samba shares. The DBF files are used by our in-house system running on xBase. Now we're moving everything to Amazon ...
0
votes
0answers
7 views

Where should migrations be run on elasticbeanstalk deployment process?

I'm very curious as to how people run a command like db migrate on their eb apps. If you add it as an .ebextensions I fear that when you have multiple instances for one app, there could be conflicts ...
17
votes
3answers
25k views

Third-party SSD solutions in ProLiant Gen8 servers

I was wondering if anyone had any specific experience using Intel DC3700 SSDs (or similar) in the HP (DL380p) Gen8 servers? I'm upgrading a set of database servers that use direct-attached storage. ...
0
votes
2answers
48 views

How to connect postgresql with LDAP user?

I have a server with postgresql-9.4 fresh install and I have another server with LDAP already installed. I want to connect postgresql with LDAP user that already exists. What's the basic ...
-1
votes
2answers
62 views

MS SQL Server 2 identical databases on different servers replication or mirroring to each other possible? [closed]

Hi: I have one free version of SQL Server 2012 express database running on Amazon AWS with 1 CPU and only 1 GB Ram . As you can see the CPU and RAM power are barely enough for my PHP scripts running ...
0
votes
0answers
46 views

Backing Up Multiple SQL Databases to Network Share at the Same Time

Junior SysAdmin/accidental DBA here so apologies in advance for the noob question. The previous DBA here had a SQL Backup Maintenance Plan that he would copy across 20+ database servers and have all ...
2
votes
1answer
39 views

Managing data created with an API in multiple environments

I have a staging and production environment for my application and store Stripe::Customer ids in my database. Occasionally, I want to copy production data to my staging database, but the ...
0
votes
1answer
17 views

Does transferring a database to a new SQL Server instance lose statistics and execution plans?

I am transferring a database to a new SQL Server and was wondering, will it lose it's execution plans and statistics that its collected over the years for the benefit of performance and have to start ...
15
votes
2answers
29k views

Best Mysql cache settings for 8gb RAM dedicated mysql server using only Innodb (5gb database)

I'm a pretty big noob when it comes to setting up mysql for performance. And honestly I'm not worried about the fine tuning to squeeze every last bit of performance out of mysql, but I do know that ...
1
vote
1answer
3k views

Third-party SSD solutions in ProLiant Gen9 servers

has anyone experience with using consumer SSDs like the Samsung 850 Pro in an HP ProLiant Gen9 server with a Smart Array P440ar controller? Judging by various reports about older versions (Gen6 to ...
-1
votes
1answer
25 views

Shared nothing database systems with SAN

Cloud data warehousing being so popular recently, I am wondering if there is an inherent contradiction in the manner in which they are architected: Terradata, Greenplum etc. require 'Shared Nothing' ...
8
votes
2answers
10k views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
0answers
19 views

“error establishing a database connection” On my wordpress website - with indexes problems?

I keep getting this: "error establishing a database connection" and this is not ending. This is /var/log/apache2/error.log: [Thu Mar 31 11:38:45.865505 2016] [autoindex:error] [pid 22782] ...
0
votes
0answers
38 views

MongoDB setup for Rocket.Chat error message

I'm following this tutorial for a Rocket.Chat setup on an Ubuntu 14.04 LTS installation. After installation of Mongod, it says to setup a replica set and gives the instructions to insert the following ...
1
vote
1answer
41 views

ZFS Backup vs. ZFS Data Folders for Services [closed]

So I recently set up my own little server here at home. I got my main system set up on an SSD and a ZFS pool of larger HDDs for data storage. Now the question I was asking myself was if for services ...
0
votes
1answer
41 views

mongodb - authentication failure on phpmongodb with username

I have a problem to authenticating to mongodb. The system is ubuntu 14.04 LTS. I can connect locally: $ mongo mytestdb -u mongotest -p MYPASSWORD MongoDB shell version: 3.2.3 connecting to: mytestdb ...
12
votes
3answers
14k views

How does one list warnings from the 'mysqlimport' utility?

To start off, this is not about loading data from within mysql itself, but using the command-line tool "mysqlimport". I am using it to load a CSV directly into a table and need to see the warnings ...
1
vote
0answers
92 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
41 views

Script to combine data from one file to another [closed]

I have a file containing folders name/value pairs: peter:/home/peter/ max:/home/max-lucas/ judith:/home/judith/documents/ I have another file containing files name/value pairs, with the same ...
0
votes
1answer
344 views

Clean up AD References to now deleted mailbox Exchange 2013

We recently separated one of our mailbox databases into three databases to better manage its growing size. The migrations all went well, and the old database has been dismounted for some time. Today, ...
-6
votes
1answer
31 views

Database File In Drop Box Shared Folder

Can a software database file be saved and kept in a shared folder like drop box and be accessed and used (whether simultaneously or not) from more than one computers? A quickbooks database file is an ...
0
votes
1answer
30 views

from security perspective one instance with Multiple Databases or multiple instance for multiple clients

We have 20 clients which currently every client has his own database on his own server(in his own environment) all the databases have the same structure(schema) and all of them has MS Sql Server 2008 ...
9
votes
1answer
18k 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 ...
0
votes
2answers
91 views

Name [ ] is not bound in this Context. Unable to find [jdbc] Tomcat Issues

I just created a fresh Oracle Linux 7 VM with Tomcat 7 and Java 8_40. I've created several servers with Apache and Tomcat before, but never connecting to databases before. SELinux and firewalld are ...
0
votes
0answers
29 views

SYNC MYSQL database instantly from one Digital ocean server to another

I have a site (data entry site ) on a Digital Ocean server and its database ( MYSQL ) is being updated with new records every second. I am hosting the public site on another Digital ocean server ...
1
vote
1answer
2k views

ASP.NET Website Administration Tool: Unable to connect to SQL Server database

I am trying to get authentication and authorization working with my ASP MVC project. I've run the aspnet_regsql.exe tool without any problem and see the aspnetdb database on my server (using the ...
0
votes
2answers
144 views

hosting site on one web server and accessing a database on another

I'm fairly sure this is the right place for this question, but if not please move it to the the right site. I have a number of sites on a 1and1 package (yeah, I know...) and I also have a subdomian ...
0
votes
0answers
22 views

MONGO - mongod - no connection to database [duplicate]

i have an testserver running under ubuntu 14.04 with public ip address. On this i have plesk 12.5 and mongodb 3.2. For administration of mongo i installed phpmongodb. Then created an database, an ...
3
votes
0answers
26 views

How to handle point in time restore without binlogs/How to split database

I thought about this 3 days already and asked in IRC but I wanna consult your expertise too. Basically it is about a High Traffic Site that uses Drupal (don't get me started, I have no choice in this ...