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.

Filter by
Sorted by
Tagged with
0
votes
1answer
19 views

Need to Alter PostgreSQL Startup on CentOS 7?

I am planning a move of Postgres' data directory from one disk to another on a CentOS 7 server. All of the data and configuration files reside in /var/lib/pgsql/12/data/. I have previously migrated ...
1
vote
1answer
18 views

Mysql 8 which linux / Unix Distro would have better performance (2021 topic) [closed]

I want to setup a mysql 8 with MyRocks engine and BUILD from source with my custom parameters. Is there any recommendation on which linux / unix distro would have better performances ? CentOS stream ...
-1
votes
0answers
23 views

it takes half an hour to stop MySQL [closed]

OS: CentOs 8.03 (Aliyun) MySQL: 8.0.25 MySQL is new installed via rpm I set CentOS time zone to Asia/Shanghai. And I add following setting in my.cnf: default-time-zone='+8:00' Sometimes it is fine, ...
0
votes
1answer
37 views

MariaDB 10.5.9 every day from 0:00 to 1:00 each 5 minutes shutdown

Log looks like: 2021-04-29 0:00:01 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown 2021-04-29 0:05:02 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown 2021-...
0
votes
1answer
137 views

postgresql-setup --initdb with custom data directory

I am trying to setup Postgres 12 on Centos 8. Postgres shall be installed in the default directory i.e. /var/lib/pgsql, however I want the data directory to be in /data/pgsql I want to use postgresql-...
0
votes
1answer
34 views

Can I copy installed mysql from ubuntu to centos7 directly without installation?

I'm trying to copy an installed MySQL from Ubuntu to Centos7 because I do not want an installation on Centos7 any more. This looks like it works but I'm not sure if there any potential issues which I ...
0
votes
1answer
33 views

Mysql 8 tables size

We have a problem with an unreasonably large table size on the server, for example: Yesterday, a table with partitions was created, data began to be written to a specific partition. mysql> show ...
0
votes
0answers
16 views

Installing GridDB on a VM hosted on Azure

So I've been trying to work with GridDB on a CentOS VM with no success. I have my VM hosted on Azure and it's CentOS 8. I'm following the steps laid out on this guide. After using wget to download the ...
0
votes
1answer
43 views

sqlcmd is running but database shown no running query

We are facing this weird issue on our Azure setup. The database is SQLServer and client is CentOS. We fire queries using sqlcmd. Sometimes it happens that you see the sqlcmd running, but there is no ...
1
vote
1answer
53 views

Linux Volumes for SQL Server + Docker on Linux [closed]

I am testing out a POC project for SQL on Docker containers on Linux and wanted some background info on how to request the storage on the Linux VM. The plan is to spin up 10 containers with SQL 2019 ...
0
votes
0answers
6 views

Restore specific date from mysql dump file

i have a big mysql dump-file since 2015 i want to restore all data form 2020 and 2021 Note : schema have a lot of tables and every table have it's own data and we didn't want all table we need only 3 ...
0
votes
0answers
10 views

CmdExec on MS-SQL 2019 Linux

I'm trying to add a CmdExec as task in a job, on MS-SQL 2019 on Centos8. However, the task always fails with "running the requested program is not allowed". I have tried specifying both /bin/...
1
vote
1answer
546 views

Ident authentication failed for user “postgres”

I am using PostgreSQL12 on Cent0S8, and I am able to connect to PostgreSQL using the command: sudo -u postgres psql However, when I attempt to connect using: psql -U postgres -h localhost I recieve ...
0
votes
0answers
279 views

Cannot start new MySQL process - Linux

I have created a new MySQL cluster by this: mysqld --initialize-insecure --basedir=/var/lib --datadir=/var/lib/mysql2 --defaults-file=/etc/my2.cnf chown -R mysql:mysql /var/lib/mysql2 chmod 777 /var/...
0
votes
0answers
22 views

Install MySQL from CentOS repository

I googled for the solutions of installing MySQL in CentOS stream, all the pages I got told me to add the repository of MySQL. The problem is, why do I have to add MySQL's repository instead of ...
0
votes
1answer
24 views

How would I sync tables in two separate servers in mysql?

DB: mysql Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1 I have two separate servers running MariaDB 5.5, both in production. Both setups are live, and users might access any ...
0
votes
0answers
21 views

Oracle Database systemd service: ORA-01031: insufficient privileges

I'm having troubles starting an oracle database with systemd. The start and stop script was created in /home/oracle/scripts/ oracledbstart.sh: #!/bin/bash export ORACLE_HOME=/opt/oracle/product/11.2.0....
0
votes
0answers
15 views

How do I enable pgadmin4 (PostgreSQL12) to read and write files in directories of other Linux Users on RHEL8/CentOS8 [duplicate]

While trying to export a query result set from PGAdmin4 on PostgreSQL12 to a CSV I am encountering the following error: ERROR: could not open file "/home/linuxusername/Downloads/data.csv" ...
0
votes
0answers
84 views

CentOS 8 Unable to connect to PostgreSQL 12 Server

When I attempt to connect to postgres in from my linux command line, I receive the following error: [lloyd@localhost ~]$ sudo -u postgres psql could not change directory to "/home/lloyd": ...
0
votes
1answer
113 views

Encounter installation problems on postgres 12

i install postgres-12,but report this error,i have execute sudo systemctl restart postgresql-12 ,and follow this install postgres12 on centos 7, and when i step into Step 5: Enable remote access,and ...
-1
votes
1answer
448 views

mysqld crashing almost every hour - mysqld invoked oom-killer - [duplicate]

I am running wordpress on a centOS digital ocean droplet my mysql keeps crashing almost every hour -- with an out of memory error manually restarting mysqld brings it back up via sudo service mysqld ...
0
votes
1answer
181 views

db2cli license file not being used

I'm using the db2 driver for CLI and ODBC to configure an ODBC connection to DB2 on IBM i/OS from CentOS. I'm trying the following command: db2cli execsql -connstring "protocol=TCPIP;database=...
0
votes
0answers
27 views

User Postgres execute unknown command which take high resource and cpu [duplicate]

I just install postgres in my host but some time I get CPU and memory very high usage I checked with following topcommand result PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ ...
1
vote
1answer
37 views

Adjusting the my.cnf file for DB servers after an instance resize

I am trying to optimize the DB server of one of our production environments (MySQL DB, centos7), and I've noticed that there is a very high memory consumption of the DB. After further investigation I ...
0
votes
0answers
1k views

Remote Access in Centos 8 and MySQL 8

I cannot access MySQL 8.0 on a Centos 8 server remotely with an error: ERROR 2026 (HY000): SSL connection error: unknown error number I can see port 3306 when doing a port scan remotely using nmap ...
0
votes
1answer
28 views

Strange PostgreSQL behaviour on service start

Centos 8.3, postgresql 12 (i tried even 10, same thing). I have set the permission of the data directory to postgres:postgres. If I start the service from systemctl, it gives me the error message &...
0
votes
2answers
465 views

Unable to import DMP file that is made in 11g2 to Oracle 18c

My OS=CENTOS 7 Oracle=18c XE I am trying to import a DMP file that is exported from XE 11g2 and now trying to import it in 18c XE. Here are the errors: [root@linux gsw]# impdp user/pass ...
0
votes
1answer
56 views

Not able to access Oracle manager online. Port 5500 is closed [closed]

I am using Oracle 18c XE on CentOS 7. The database installed successfully but not able to bring it online to my hostname. what I did is: Added port 5500 in firewall: firewall-cmd --permanent --add-...
0
votes
1answer
32 views

Connection issue to Mysql from Apache server

I am operating on Centos7 and Mysql 5.6.46. I needed to move the default datadir location to an encrypted partition and I changed my default /etc/my.cnf file accordingly: # For advice on how to ...
0
votes
0answers
30 views

RSA Certificate Error Starting MySQL 5.7 on CentOS 6

We've been getting some trouble installing MySQL 5.7 on a CentOS 6 box. Information about the environment is available below: CentOS Version: [root@ip-10-0-0-73 ~]# cat /etc/centos-release CentOS ...
0
votes
0answers
131 views

Maximum concurrent users on linux server

I have a dedicated server with these info: 128G RAM 6 cores/12 threads CPU, 3.4GHz 512 SSD storage WHM/Cpanel latest Apache/MySQL Centos 7.x I have a single website on this server which have heavy ...
1
vote
1answer
287 views

Postgres initialization of pg_basebackup

Hi Im running on a centos 7 machine, Im in the process of migrating an old postgres database to the new server, it has like 10TB of data so Im trying it with pg_basebackup. The new server has an ...
0
votes
1answer
39 views

MariaDB: Connecting from LAN on Centos

I have a working MariaDB 10.2 running on my CentOS 6 server. I can connect to the DB from another machine on the LAN. Out of curiosity, I wanted to revisit how this was made possible. Everything I ...
0
votes
0answers
20 views

after running Galera Replication for MariaDB , performance (TPS) does huge diffrence [duplicate]

I have two VM machines (with exact hardware-software configuration on two ESXI Servers in same rack and same subnet too) that is running with nginx + PHP-FPM + and MariaDB 10.4. in each ESXI server I ...
1
vote
1answer
396 views

How to dedicate server to MySQL for max performance?

I am using MariaDB 10.5, I see this in MySQLTuner report Dedicate this server to your database for highest performance. How do I do this? My server is on Centos 8.
0
votes
1answer
116 views

MySQL database not loading table data

My centOS 7 server had an unexpected shutdown. For some reason one of the mysql database shows that all tables are empty, but if I browse the files in /var/lib/mysq/database I can see the files(.frm ...
0
votes
2answers
122 views

MariaDB 5.5 InnoDB keeps opening files up to 200k until system hangs

MariaDB 5.5 is installed on CentOS and serves a database in the total volume of around 40GBs (as measured per database files on a disk) and 506 tables. This database is being queried by php-fpm, and ...
-2
votes
1answer
151 views

Deleted oradata folder under oracle home by accident

While setting up a new server, I accidentally deleted the oradata folder in the working Database server. I have no backup of the working database, I googled and found flashback option to recover, but ...
0
votes
2answers
6k views

Unable to install Oracle XE 18c on Centos 8

I am trying to install Oracle 18 on Centos 8 64 Bit. I have been able to install the prerequiste component, that in itself requires pre-requisites, but the Oracle install itself fails. Any ...
0
votes
0answers
978 views

Error Code: 1129 Host 'xxx.xxx.xx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

For the past few days, I am getting this error every morning when I tried to connect to the MySQL database using the MySQL workbench and also through some applications. So, every day I log onto the ...
1
vote
2answers
4k views

How to get a new pid file of Mysql and restart Mysql Successfully?

Due to lost of pid file of my server, I can't stop mysql using normal commands like service mysql stop which will show ERROR! MySQL server PID file could not be found! So I try to stop all mysql ...
1
vote
1answer
683 views

Change mariadb's log directory

MariaDB was installed using yum on Centos7 using repository http://yum.mariadb.org/10.3/centos7-amd64. MariaDB's log files are sent to directory /var/lib/mysql. How can I change the location to ...
0
votes
0answers
431 views

Restoring MySQL database data from ibdata1 and ib_logfile

I am trying to restore a MySQL database. I have the following: ibdata1 ib_logfile0 ib_logfile1 .frm files restored as I have a backup of the structure. Is it possible to restore the data for the ...
0
votes
0answers
36 views

CentOS7 Virtual Machine postgres10 not initializing

I had postgres9.6 installed and working the other day but the version wasn't compatible. I used YUM REMOVE to remove that one and then followed the instructions here https://www.postgresql.org/...
1
vote
0answers
338 views

PostgreSQL 9.6 on linux server gives a different collation than windows installation

I am running into an issue with a script that makes a backup towards the SQL. What happens is that with our script we make a dump of SQL we can read out to restore the PostgreSQL database. Our client ...
0
votes
1answer
182 views

Postgres 9.6 - Taking differenctial backup

I have a few CentOS boxes running Postgres 9.6. I am planning a central server which can make local copies of all DBs on the other servers. These servers are accessible via SSH on Internet. What is ...
0
votes
1answer
63 views

MariaDB replication from master to slave

After doing some research around this topic, I should be attempting this task soon. However, I have two questions going around my head - could do with an experienced professional answering them. I am ...
0
votes
1answer
42 views

OS killed some of databse demons

I have 2 HP servers with CntOS 6 as OS and DB2 10.5 as Database. there 2 servers are HADR. standby server suddenly rebooted and when i checked log it said that OS had killed 4 db2 demons. IBM....
3
votes
1answer
2k views

Postgres 10 replica service error on startup

I have migrated a database promoting the read-replica in a server with more capacity, this process worked smoothly. But I'm trying to create a read-replica now from this promoted server to have a ...
0
votes
1answer
4k views

Postgresql sql import Permission denied! [closed]

Can't import db from sql file [user@localhost ~]$ sudo -u postgres psql [sudo] password for user: could not change directory to "/home/user" Password: psql (9.2.24) Type "help" for help. postgres=#...