Add support for percona xtradb cluster

[morwel]

When trying to install mysqlclient on a RHEL 9 system with percona-xtradb-cluster-devel installed, the build fails

[root@35fe8676c390 tmp]# venv/bin/pip install mysqlclient
Collecting mysqlclient
  Downloading mysqlclient-2.2.4.tar.gz (90 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 90.4/90.4 kB 2.0 MB/s eta 0:00:00
  Installing build dependencies ... done
  Getting requirements to build wheel ... error
  error: subprocess-exited-with-error

  × Getting requirements to build wheel did not run successfully.
  │ exit code: 1
  ╰─> [27 lines of output]
      Trying pkg-config --exists mysqlclient
      Command 'pkg-config --exists mysqlclient' returned non-zero exit status 1.
      Trying pkg-config --exists mariadb
      Command 'pkg-config --exists mariadb' returned non-zero exit status 1.
      Trying pkg-config --exists libmariadb
      Command 'pkg-config --exists libmariadb' returned non-zero exit status 1.
      Traceback (most recent call last):
        File "/home/runner/tmp/venv/lib64/python3.11/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 353, in <module>
          main()
        File "/home/runner/tmp/venv/lib64/python3.11/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 335, in main
          json_out['return_val'] = hook(**hook_input['kwargs'])
                                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
        File "/home/runner/tmp/venv/lib64/python3.11/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 118, in get_requires_for_build_wheel
          return hook(config_settings)
                 ^^^^^^^^^^^^^^^^^^^^^
        File "/tmp/pip-build-env-qg_6fi3w/overlay/lib/python3.11/site-packages/setuptools/build_meta.py", line 325, in get_requires_for_build_wheel
          return self._get_build_requires(config_settings, requirements=['wheel'])
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
        File "/tmp/pip-build-env-qg_6fi3w/overlay/lib/python3.11/site-packages/setuptools/build_meta.py", line 295, in _get_build_requires
          self.run_setup()
        File "/tmp/pip-build-env-qg_6fi3w/overlay/lib/python3.11/site-packages/setuptools/build_meta.py", line 311, in run_setup
          exec(code, locals())
        File "<string>", line 155, in <module>
        File "<string>", line 49, in get_config_posix
        File "<string>", line 28, in find_package_name
      Exception: Can not find valid pkg-config name.
      Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
error: subprocess-exited-with-error

× Getting requirements to build wheel did not run successfully.
│ exit code: 1
╰─> See above for output.

note: This error originates from a subprocess, and is likely not a problem with pip.

This is because the package is called perconaserverclient (and not mysqlclient, mariadb or libmariadb). Calling pkg-config with it works

[root@35fe8676c390 tmp]# pkg-config --cflags --libs perconaserverclient
-I/usr/include/mysql -m64 -L/usr/lib64/mysql -lperconaserverclient

and installing mysqlclient with custom options also

[root@35fe8676c390 tmp]# MYSQLCLIENT_CFLAGS="-I/usr/include/mysql -m64" MYSQLCLIENT_LDFLAGS="-L/usr/lib64/mysql -lperconaserverclient" venv/bin/pip install mysqlclient
Collecting mysqlclient
  Using cached mysqlclient-2.2.4.tar.gz (90 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Installing backend dependencies ... done
  Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: mysqlclient
  Building wheel for mysqlclient (pyproject.toml) ... done
  Created wheel for mysqlclient: filename=mysqlclient-2.2.4-cp311-cp311-linux_x86_64.whl size=2453445 sha256=bf6ae5373ace66006573c86170803c87cdb5585bb05fff5ec764094312cd7295
  Stored in directory: /root/.cache/pip/wheels/1e/2f/4c/0bd8be7e2f3255f9436ce68bb1c2563661e8b7bbd49dcff0e0
Successfully built mysqlclient
Installing collected packages: mysqlclient
Successfully installed mysqlclient-2.2.4

Is it possible to add perconaserverclient to the list of supported packages?

[methane]

When trying to install mysqlclient on a RHEL 9 system with percona-xtradb-cluster-devel installed, the build fails

Why do you use RHEL? RHEL users pay for support from Red Hat. You should ask support to Red Hat instead of here.

I don't use RHEL and Percona. So it is impossible to reproduce.
But if Percona uses MySQL protocol, you can use MySQL client library by installing python3-devel mysql-devel pkgconfig.

[morwel]

Depending on your use case you can use RHEL without a paid subscription or paid support.
But Percona is a third-party program, so Red Hat support could not help you anyway. And the problem is with the percona package and isn't limited to RHEL.

Percona MySQL Server is a patched version of MySQL, so I would assume it is compatible with MySQL. But so linking against the lib of the percona package should also work. The problem is, that the .pc file in the package is called personaserverclient.pc and not mysqlclient.pc like usually. So when searching for the package (in find_package_name in setup.py) nothing is found and the error occurs.

[morwel]

This works now thanks to #718