mariadb

Hi I'm new to this forum. Just turned from cPanel to Plesk and I'm loving it. Anyway, I managed to Install Onyx on CentOS7 with no problem and the forum really helped. I was trying to secure my installation so I did not know Plesk changed root to admin so I updated admin user's password and my...

Hi Everyone, I've seen on various best practices websites that people are recommending mariadb10 now over 5 (which is pre-installed on Plesk. Is there any real benefits and how easy is it to upgrade?

Hi all, I tried to run "mysql_secure_installation" command on my server where Onyx is running but I always get login error because the Onyx default db user is admin and not root: I also tried to run: "mysql_secure_installation -uadmin" but with no success. Can anyone help me on this and tell...

Hi all, We have a dedicated Centos 7.3 server which came with Plesk Onyx 17.5.3 and MariaDB. We followed this guide: Database Server to change the DB to Percona. The only step that wasn't carried out was the re-installation of Plesk, which seems to have been an optional step. Everything...

Tip to everyone: Plesk itself uses mysql. Dont fool around if you're not sure what you're doing! You might mess up your installation. EDIT 7 june 2017: Do not follow up with code posted below here! If I find out the proper way I will post it! just messed up my server! ...which is the reason...

Hello experts, I checked the search function of the forum and google. So far I couldn't resolve my issue. I would would like to switch to mariaDB and planned to do so after updating to Plesk 17.5 which I run on Ubuntu 16.04 LTS. I followed this Instruction Database Server Including step...

Hello all, i have a problem with maria db. System: Centos 7 64 After DDOS attack, maria db does not start. I reboot server and i got this error: I tried "service mariadb restart" May 10 18:05:39 hostname mariadb-prepare-db-dir[5195]: rm: cannot remove...

I would like to know how to optimize the configuration in order to increase performance especially with regard to database requests. The server at my disposal is as follows: Server OVH Enterprise SP-32 Linux Plesk 12.5 (Cent OS 7) Intel(R) Xeon(R) CPU E3-1231 v3 @ 3.40GHz – Core: 8 32 GB RAM...

Hi, I'm trying to change the MariaDB data directory from /var/lib/mysql to /my_folder/mysql. Everything is good I can log into mysql in command line but plesk give me a hard time with Zend Errors. I've change my /etc/my.cnf and my /etc/psa/psa.conf to match with the new mysql location but...

I'm quite new to Plesk and I have few questions. Is possible to safely remove plesk-mysql-server with RPM packager and install it with yum right after? I have replaced MariaDB with Percona and yum check returns following: plesk-mysql-server-17.5.3-cos7.build1705170317.16.x86_64 has missing...

When you update MariaDB to 10.1.21? https://mariadb.org/10-1-mio-qps/

Hello, After experiencing issues connecting to MariaDB via the command line using the admin password, I had to use mysqld_safe to reset the password. The admin panel can now no longer connect to the database. Instead we experience the following issue: ERROR: PleskDBException: Unable to...

Could someone check my my.cnf please? What's wrong with it? Here is my default(original my.cnf that works) I'm trying to optimize DB for my VPS KVM OpenStack SLA 99.99 % 4 vCores 2,4 GHz 24 GB RAM 100 GB High Availability (Ceph) Thanks //IP:8443 returns

Hi I'm having an issue after i upgrade the Maria DB database, the sites i can see are still working but i can't access to plesk admin. Screenshot:

I have a VPS server with 1and1, using Plesk 12.50 on CentOs 7. Before I had Plesk in another server, at the time of the migration I had some trouble to get mysql working, but after search, some of the things I followed fixed that issue, so all websites were working ok, except the login to Plesk...

Hello Plesk community, I'm trying to upgrade to Plesk Onyx. Currently I'm using Plesk v12.5.30_build1205150826.19 os_CentOS 7. Unfortunately, I'm not able to upgrade because of MariaDB: Thanks in advance for you help! sdmx80

Hello, We use Plesk 12.5.30 on Centos 7 with an application with lot's of user connected on. Sometimes Mariadb is not responding and I have in Php log : The server "MySQL server has gone away" on a simple request in a little table. We must restart mariadb service, but all session are broken. We...

Well, my system seems to be very confused... On one hand he says I'm on Version: 12.5.30 Update Nr. 27, which he calls up to date... While on the other Hand, there is a big red attention box on top of my dashboard which says that "the update" failed, including links to the 2 last attempts, who...

Hello: I use a Plesk 12.5.30 Testing SSL vulnerability I see that I have Poodle and Beast vulnerability. For Poodle fix, I followed step by step the KB http://kb.odin.com/en/123160 But at the point of MySQL fix It shows the following syntax error: MariaDB [psa]> mysql> insert into misc...

Hello, I am trying to install MariaDB 10.1 using Plesk's Instructions and MariaDB repos however it just keeps failing for me, Install logs: root@host:~# env DEBIAN_FRONTEND=noninteractive apt-get -o OrderList::Score::Immediate=1000 install mariadb-server mysql-common libmariadbclient18 Reading...