MySQL

​

Genel bakış

​

Gereksinimler

• Access to Event Streams for outbound message events (Plan limitations and overages apply)
• Access to Custom Events for inbound event syncing (Plan limitations and overages apply)
• Updated Account Plan (not available on free apps)

​

MySQL

• MySQL Community 5.7 veya daha yenisi, ya da MariaDB’nin son sürümleri
• Yapılandırılmış davranışsal veriler içeren Olay tabloları
• OneSignal’den MySQL örneğinize Ağ bağlantısı
• TLS v1.2 veya daha yüksek desteklenir

​

Kurulum

-- Create census user with ability to sign in with a password
CREATE USER CENSUS IDENTIFIED BY '<strong, unique password>';

-- Grant read-only access to your event schema
GRANT SELECT ON <your_schema>.* TO CENSUS;

​

Event data mapping

​

Örnek Olay Tablosu Şeması

CREATE TABLE user_events (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    event_name VARCHAR(100) NOT NULL,
    user_id VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    event_data JSON,
    session_id VARCHAR(255),
    device_type VARCHAR(50)
);

​

Tablo Modu

​

SQL Sorgu Modu

-- Example: Recent high-value events
SELECT
    event_name,
    user_id,
    created_at as timestamp,
    event_data as payload
FROM user_events
WHERE created_at >= DATE_SUB(NOW(), INTERVAL 7 DAY)
    AND JSON_EXTRACT(event_data, '$.value') > 100
ORDER BY created_at DESC;

​

Gelişmiş Ağ Yapılandırması

​

SSS

​

Hangi MySQL sürümleri desteklenir?

​

Özel bir ağdaki MySQL’e bağlanabilir miyim?