Skip to main content

Integration

Application Integration​

Connection Drivers

  • PHP: MySQLi, PDO_MySQL

  • Python: mysql-connector-python, PyMySQL

  • Java: MySQL Connector/J

  • Node.js: mysql2, mysql

  • C#/.NET: MySql.Data, Pomelo.EntityFrameworkCore.MySql

Connection Examples

php

// PHP MySQLi
$connection = new mysqli("localhost", "username", "password", "database");
// Python
import mysql.connector
connection = mysql.connector.connect(
    host='localhost',
    user='username',
    password='password',
    database='database'
)
// Java
String url = "jdbc:mysql://localhost:3306/database";
Connection connection = DriverManager.getConnection(url, "username", "password");

Enterprise Integration​

LDAP Integration​

sql

-- Install LDAP authentication plugin
INSTALL PLUGIN authentication_ldap_sasl SONAME 'authentication_ldap_sasl.so';
-- Create LDAP user
CREATE USER 'ldapuser'@'%' IDENTIFIED WITH authentication_ldap_sasl;

Backup Integration​

  • MySQL Enterprise Backup: Hot backup solution

  • mysqldump: Logical backup utility

  • Percona XtraBackup: Open-source hot backup tool

Monitoring Integration​

  • MySQL Enterprise Monitor: Real-time monitoring and alerting

  • Nagios: Open-source monitoring integration

  • Prometheus: Metrics collection and monitoring

  • Grafana: Visualization and dashboards