Skip to content
Products
Resources
Solutions
Pricing
Contact
Log In
Sign Up
Docs
Getting Started
Configuration
Studio
Accounts & Profiles
Content & Contexts
Emails & Notifications
Global Settings
Hashtags, Labels & Channels
I18n & Localization
Managing Apps
Operators & Admins
Roles & Memberships
Icons
Texts
Remote Storage
MySQL cluster
API keys vs OAuth2
Push notifications
Apps
CODE
How to Add an App
Auth
Docs
Configuration
MySQL cluster
On this page

MySQL cluster

Point UNA 15 at a MySQL master and replicas by editing BX_DATABASE_* in inc/header.inc.php.
Android
iOS
Web
Core
~15.0
Source
Copy Page
Note
Important
define('BX_DATABASE_HOST', $_ENV['UNA_DB_HOST'] ?? '192.168.0.100'); ///< db host
define('BX_DATABASE_SOCK', $_ENV['UNA_DB_SOCK'] ?? ''); ///< db socket
define('BX_DATABASE_PORT', $_ENV['UNA_DB_PORT'] ?? ''); ///< db port
define('BX_DATABASE_USER', $_ENV['UNA_DB_USER'] ?? 'root'); ///< db user
define('BX_DATABASE_PASS', $_ENV['UNA_DB_PWD'] ?? 'pa55wd'); ///< db password
define('BX_DATABASE_NAME', $_ENV['UNA_DB_NAME'] ?? 'una'); ///< db name
define('BX_DATABASE_ENGINE', $_ENV['UNA_DB_ENGINE'] ?? 'MYISAM'); ///< db engine
define('BX_DATABASE_HOST', array('192.168.0.100', '192.168.0.101', '192.168.0.102')); ///< db hosts, first is always rw master
define('BX_DATABASE_SOCK', array('', '', '')); ///< db sockets, first is always rw master
define('BX_DATABASE_PORT', array('', '', '')); ///< db ports, first is always rw master
define('BX_DATABASE_USER', array('root', 'readonly-user', 'readonly-user')); ///< db users, first is always rw master
define('BX_DATABASE_PASS', array('pa55wd', 'pa55wd', 'pa55wd')); ///< db passwords, first is always rw master
define('BX_DATABASE_NAME', array('una', 'una', 'una')); ///< db names, first is always rw master
define('BX_DATABASE_ENGINE', 'MYISAM'); ///< db engine
define('BX_DATABASE_ENGINE', 'INNODB'); ///< db engine
21d
On this page
One hostClusterHow UNA picks a hostEngineEnvironment variables
Auto
define('BX_DATABASE_HOST', $_ENV['UNA_DB_HOST'] ?? '192.168.0.100'); ///< db host
define('BX_DATABASE_SOCK', $_ENV['UNA_DB_SOCK'] ?? ''); ///< db socket
define('BX_DATABASE_PORT', $_ENV['UNA_DB_PORT'] ?? ''); ///< db port
define('BX_DATABASE_USER', $_ENV['UNA_DB_USER'] ?? 'root'); ///< db user
define('BX_DATABASE_PASS', $_ENV['UNA_DB_PWD'] ?? 'pa55wd'); ///< db password
define('BX_DATABASE_NAME', $_ENV['UNA_DB_NAME'] ?? 'una'); ///< db name
define('BX_DATABASE_ENGINE', $_ENV['UNA_DB_ENGINE'] ?? 'MYISAM'); ///< db engine
define('BX_DATABASE_HOST', array('192.168.0.100', '192.168.0.101', '192.168.0.102')); ///< db hosts, first is always rw master
define('BX_DATABASE_SOCK', array('', '', '')); ///< db sockets, first is always rw master
define('BX_DATABASE_PORT', array('', '', '')); ///< db ports, first is always rw master
define('BX_DATABASE_USER', array('root', 'readonly-user', 'readonly-user')); ///< db users, first is always rw master
define('BX_DATABASE_PASS', array('pa55wd', 'pa55wd', 'pa55wd')); ///< db passwords, first is always rw master
define('BX_DATABASE_NAME', array('una', 'una', 'una')); ///< db names, first is always rw master
define('BX_DATABASE_ENGINE', 'MYISAM'); ///< db engine