This plug-in queries a MySQL Server for host records and optionally.
BSEditor: This plug-in queries a MySQL Server for host records and optionally Reverse records.
SQL queries are executed asynchronously (in a separate thread) and therefore wont slow down other requests not using the plug-in.

To setup a new MySQL Server plug-in instance; first download and install the plug-in. Then in the Simple DNS Plus options dialog / Plug-ins section, select the MySQL Server component and click the Create new instance... button.

In the plug-in instance dialog / Plug-In Settings tab you can specify the database connection string and SQL SELECT statements to be used to fetch records:
At least one of the SELECT statement fields must be filled out, but you can leave some blank if you dont want to use that feature.

There are no specific requirements for database table layout. You just need to be able to execute an SQL query which returns the required data. The query can be based on a table, view, stored procedure, or any other valid SQL expression.

For forward lookups (name to IP) you need to include a ?hostname parameter in the SELECT statement, and the query must return two columns; IP-address and TTL as the first and second columns.

For reverse lookups (IP to name) you need to include a ?ipAddress parameter in the SELECT statement, and the query must return two columns; host-name and TTL as the first and second columns.

For either type of lookups (forward/reverse), you may optionally include a ?clientip parameter which will contain the IP address of the client requesting the data.

The column names of the returned data do not matter - only the column order.

If there are more than one row or more than two columns returned, additional rows and columns are ignored. you can free download MySQL Server Plug-In 1.0 now.