Not the answer you need?
Register and ask your own question!

Is there a simple way to install Percona Server 8.0 on Ubuntu 19.04/19.10 ?

StalinkoStalinko Current User Role Contributor
Hello
I have 2 Ubuntu servers with OS versions 19.04 (disco) and 19.10 (eoan).
This instruction (https://www.percona.com/doc/percona-server/LATEST/installation/apt_repo.html) says that only Ubuntu 16.04 and Ubuntu 18.04 are supported.
I tried to install it nevertheless. At Ubuntu 19.10 I failed at 1st step:
wget https://repo.percona.com/apt/percona-release_latest.eoan_all.deb
because this file doesn't exist.
For Ubuntu 19.04 it surprisingly exists, but then the next command:
sudo percona-release setup ps80
Throws an error:
Err:12 http://repo.percona.com/ps-80/apt eoan Release  404  Not Found [IP: 157.245.68.135 80]Get:13 http://repo.percona.com/tools/apt eoan/main Sources [1,025 B]Get:14 http://repo.percona.com/tools/apt eoan/main amd64 Packages [1,121 B]Reading package lists... DoneE: The repository 'http://repo.percona.com/ps-80/apt eoan Release' does not have a Release file.N: Updating from such a repository can't be done securely, and is therefore disabled by default.
Then I decided to try to compile from source, but it looks beyond my unix knowledge, so many strange parameters which I must specify myself.
Are there any simple ways to install PS8.0 at the newest Ubuntu servers?

Best Answer

Answers

  • StalinkoStalinko Current User Role Contributor
    edited April 22
    Thanks @"lorraine.pocklington"
    Nope, I didn't know Ubuntu 19 has short term support. That's so weird :(
    Actually I was able to get a solution. Just downloaded latest packages from https://www.percona.com/downloads/Percona-Server-LATEST/
    They were designed for Ubuntu 18 but installed successfully at 19.10. However I didn't see any speed boost in my case, the speed was even a little bit worse than with MySQL 8.0 so I decided to rollback to MySQL Server. That's most likely because my server serves just 1 user and performs isolated heavy calculations. It seems that those who develop DB servers are aimed mostly at environments with a lot of users making light queries.
  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    Thanks for the response... I updated my reply a little as I misinterpreted what I was told. We DO support Ubuntu but not those specific versions. I wonder if there's anyone has any suggestions... I might try one of our frequent posters see if they want to contribute... :)
  • Federico RazzoliFederico Razzoli Contributor Current User Role Patron
    @Stalinko , you are correct that much more attention is paid to high-concurrency workloads, at the expense of low-concurrency or single connection. Mark Callaghan wrote several interesting posts on this topic:
    That said:
    • Did you use exactly the same configuration?
    • What is exactly slower with Percona Server?


  • StalinkoStalinko Current User Role Contributor
    @Federico Razzoli thanks for the link. After reading this I started to realise I'm moving in back direction... Instead of upgrading my server I should degraded it to 5.6 and get really notable speed boost.
    Regards your questions:
    >Did you use exactly the same configuration?
    Yes. I have my own config. And between tests I only replaced database server software without changing the data and configs.
    >What is exactly slower with Percona Server?
    Well it would require a serious investigation, but I'm short of time. I just ran a bunch of my heavy and semi-heavy scripts and compared the times for different installations. Percona was like 10% slower on all the scripts. So I decided it's just not a good match for my personal case.
  • Federico RazzoliFederico Razzoli Contributor Current User Role Patron
    @Stalinko I don't suggest to downgrade. MySQL 5.6 "end of life" is planned for February next year. This means that bugs of any type will not be fixed after that date.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.