PITR in mysql backup is not working

[kannanvr]

Report

Hi,

spec:
backup:
 enabled: true
 image: perconalab/percona-server-mysql-operator:main-backup8.4
 imagePullPolicy: IfNotPresent
 pitr:
   enabled: true
   binlogServer:
     connectTimeout: 20
     idleTime: 20
     image: percona/percona-server-mysql-operator:0.11.0
     readTimeout: 20
     serverId: 72
     size: 100
     writeTimeout: 20
     storage:
       s3:
         bucket: s3://mysql
         credentialsSecret: cluster1-s3-credentials
         region: us-west-2

Above is my backup section for the mysql. When i try taking the PITR option on mysql, then the binlog container came up but it is throwing the below log

Defaulted container "binlog-server" out of: binlog-server, binlog-server-init (init)
/opt/percona/binlog-server-entrypoint.sh: line 5: /usr/local/bin/binlog_server: No such file or directory

I dont see any percona image with binlog_server. Do you have any working image for PITR

More about the problem

I could not take the PITR from the operator

Steps to reproduce

1. start the mysql operator
2. enable PITR option on backup section
3. binlog pod would come up

Versions

1. Kubernetes: 1.30
2. Operator: docker.io/perconalab/percona-server-mysql-operator:main
3. Database: 8.4

Anything else?

No response

[hors]

Hi @kannanvr we do not support PITR backups in the PS operator. We have added it as an alpha version to test it internally.

[kannanvr]

Ok.. Thanks @hors . Its one of the nice feature on percona mysql...

[hors]

Ok.. Thanks @hors . Its one of the nice feature on percona mysql...

I know, we will add it. It is under development right now.

[kannanvr]

Ok . Sure.. Please let me know if you need any help to test for this feature..

[sree1726]

HI @hors , Do we have PITR functionalitry on MYSQL?

Thanks, Marthalla

[gkech]

Hey @sree1726, not yet, but we are planning to introduce it. Here's the ticket: https://perconadev.atlassian.net/browse/K8SPS-403