create "latest" symlink in ProxySQL YUM repo to point to the latest CentOS release

[mcrauwel]

To be able to fully support default Amazon Linux AMI's the yum repo would need to support the $releasever = latest value. This is the default in all Amazon Linux AMI's

See https://aws.amazon.com/amazon-linux-ami/faqs/#lock

Package updates are always pushed into the repositories and are available to any versions of the Amazon Linux AMI where yum is configured to point to "latest". You can see which repositories your instance is pointing to by looking at the "releasever" variable in /etc/yum.conf – by default, the Amazon Linux AMI has releasever=latest set.

[ohsono]

I can reproduce this issue. I have the same version of Amazon AMI image. Please add it on the latest folder as well.

[ohsono]

I found a workaround. "repo.proxysql" doesn't have the /latest/ folder. But the percona repo does have it. http://repo.percona.com/release/latest/RPMS/x86_64/

to disable proxysql repo

##If you already have proxysql.repo and enabled=1, change to enabled=0
$ more /etc/yum.repos.d/proxysql.repo | grep enabled
enabled=1

download/install percona repo

$ sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
$ sudo yum list | grep proxysql

install proxysql

$ sudo yum install proxysql

[pondix]

Hi @ohsono - this is not a workaround since Percona repo's do not contain the latest ProxySQL packages.

[pondix]

@mcrauwel I've created "latest" please check if it works and let us know

[mcrauwel]

@pondix this works out of the box for Amazon Linux AMI. However the AMI2 is starting to be more used afaik and there it doesn't work yet. I would suggest to add a block of docs to the repo.proxysql.com info like this:

Amazon Linux Servers :

vi /etc/yum.repos.d/proxysql.repo
[proxysql_repo]
name= ProxySQL YUM repository
baseurl=http://repo.proxysql.com/ProxySQL/proxysql-1.4.x/centos/latest
gpgcheck=1
gpgkey=http://repo.proxysql.com/ProxySQL/repo_pub_key


Install :
yum install proxysql OR yum install proxysql-version