determine if mysql or percona or mariaDB

Question

How can i tell if a server I'm connecting to is Percona or MySQL or MariaDB? Is there any standard way of doing this? I'm currently using SHOW VERSION to test the server version, but I would also need to display the server name in the app I'm working on.

Answer 1

Keep in mind that "MySQL" is the original, and the others are spinoffs. Here is some code that probably always works:

version_comment REGEXP 'MariaDB' -- > Mariadb
version_comment REGEXP 'Percona' -- > Percona
else MySQL

version_comment can be accessed via SHOW VARIABLES or information_schema.

@@version is not reliable because Percona leaves no clue, although I suspect the '-30.3-' is a clue in 5.5.31-30.3-log.

(I checked 106 servers.)

Update

(checking 264 servers.)

version         REGEXP 'MariaDB' -- > Mariadb
version_comment REGEXP 'Percona' -- > Percona
else MySQL

(And we probably cannot trust for this to be the final word.)