Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [centos]

CentOS is a Linux operating system. Questions with this tag should be about administering a database management platform on the CentOS operating system.

CentOS (abbreviated from Community Enterprise Operating System) is a Linux distribution that attempts to provide a free, enterprise-class, community-supported computing platform which aims to be functionally compatible with its upstream source, Red Hat Enterprise Linux (RHEL).

147 questions
27
votes
8 answers

MariaDB Can't init tc log

I've tried every solution on the Internet but my MariaDb server continue to fail, continue to betray me, continue to destroy my tiny DevOps world. My attempts to smooth the situation included all sorts of satisfaction: changing permissions, configs,…
Sam Ivichuk
  • 335
  • 1
  • 3
  • 7
18
votes
3 answers

How to upgrade PostgreSQL from version 8.4 to 9.4?

I want to upgrade my PostgreSQL from version 8.4 to 9.4. The documentation is not very clear to me. Will I lose my old databases if I do the upgrade? How can I backup my old databases if I am to lose them after the upgrade? How can I upgrade my…
Alex Jolig
  • 549
  • 1
  • 5
  • 12
12
votes
4 answers

Setting root password in fresh mysql 5.7 installation

I am trying to install mysql in a serving having CentOS Linux release 7.2.1511. Take a look to the process installation: # sudo yum install mysql-server Output: Dependencies…
manix
  • 355
  • 1
  • 3
  • 11
9
votes
3 answers

How to quickly startup/shutdown Oracle 11?

I am wondering what is the quickest way to properly startup/shutdown a Oracle DB daemon (Oracle 11.2, installed on a test machine). I need it for C/C++ programs that use the OCI/Pro*C API. I want this because I am used to the startup speed of…
maxschlepzig
  • 515
  • 3
  • 6
  • 15
7
votes
2 answers

Changing data directory for postgres on CentOS

I've got a postgres 9.2.18 installation on CentOS which used the standard installation path. Now I realised that on this particular partition, there isn't sufficient hard-disk space for some bigger queries. The default data_directory is…
Mayak
  • 181
  • 1
  • 1
  • 3
7
votes
3 answers

Improving RAM and CPU utilization by PostgreSQL 9.6

I've been running a function on the database that is going into each table, ALTER COLUMN on all columns of a certain data type, and CAST to remove trailing zeros. About 115 tables varying from a few thousand records to a few hundred thousand…
cjones
  • 303
  • 1
  • 3
  • 9
6
votes
0 answers

Understanding MongoDB Log warning

In my MongoDB log, I am seeing these lines of messages: 2016-04-05T00:03:42.904+0000 I COMMAND [ftdc] serverStatus was very slow: { after basic: 200, after asserts: 240, after backgroundFlushing: 380, after connections: 510, after dur: 650, after…
M T
  • 61
  • 3
6
votes
4 answers

encryption at rest for mysql

A MySQL database needs to contain highly sensitive data that cannot be left unencrypted at rest. But yet the database needs to remain searchable by an app. What are the options for encryption at rest with MySQL? I have looked into CryptDB but it…
CodeMed
  • 467
  • 4
  • 9
  • 15
5
votes
3 answers

mysql "can't create test file" error on Centos

When starting mysql on Centos servers with a custom data directory you might get an error similar to the following: 2014-10-15 10:23:56 17081 [Warning] Can't create test file /database/mysql/localhost.lower-test
Haluk
  • 599
  • 3
  • 10
  • 22
5
votes
2 answers

Mysql enable remote connection in centos,my.cnf does not have bind-address to comment out

I'm trying to make my MySQL Server running on CentOS to allow remote database connections. I'm reading this article that says I should comment out bind-address but bind address is not available in the my.conf, this line is available at…
user46420
5
votes
1 answer

Receiving "General error: 1030 Got error 168 from storage engine"

I am not sure if this is the right Stack Exchange to post to or not (StackOverflow figured it belonged elsewhere, so maybe it will do better here?) but I keep receiving this MySQL error when I try to install Magento2 on a VPS (Centos6, MySQL…
Rasclatt
  • 155
  • 1
  • 1
  • 6
4
votes
2 answers

PostgreSQL service start failed on CentOS 7

Installed PostgreSQL using: sudo yum install postgresql-server postgresql-contrib PostgreSQL version: 9.2.18 When start service: sudo service postgresql start Got error: Redirecting to /bin/systemctl start postgresql.service Job for…
cloud_cloud
  • 295
  • 2
  • 6
  • 12
3
votes
2 answers

Unable to get any type of connection using MySQL on LAN

My question is rather simple, I have a Windows 7 machine that is hosting an Apache server and a MySQL server using the XAMPP control panel. Both of these have been installed as a service on the machine. I am trying to connect to the MySQL server…
Darksaint2014
  • 31
  • 1
3
votes
2 answers

MySQL dies when trying to access a specific database

For some reason, whatever I do I cannot access one of my databases (through command line or through something like phpmyadmin). However, the application that depends on this database is not having any issues and is working perfectly. I've tried a…
user1952811
3
votes
1 answer

Error while accessing remote MongoDB

Trying to access remote MongoDB. Got the following error: C:\Users\ranjj_000>mongo :28017 MongoDB shell version: 2.6.0 connecting to: 111.93.128.60:28017/test 2014-04-22T12:19:45.084+0530 Socket recv() errno:10054 An existing…
ranjjose
  • 133
  • 1
  • 5
1
2 3
…
9 10