----- Installation of MariaDB data base server ----- MariaDB is the data base server. Will install it: sudó apt install mariadb-server Run MariaDB: sudo /etc/init.d/mariadb start Now we give a root root password to MariaDB. Please, replace new-password with your own: sudo mysqladmin -u root password new-password Make a database with his own user for OpenMeetings:--> sudo mysql the MariaDB root password that you have just chosen, type it... MariaDB [(none)]> CREATE DATABASE open610 DEFAULT CHARACTER SET 'utf8'; (Only one line with space between both) MariaDB [(none)]>

a free software tool written in PHP that is intended to handle the administration of a MySQL or MariaDB database server. You can use phpMyAdmin to perform most administration tasks, including creating authentication modes ## Database phpMyAdmin supports MySQL-compatible databases. • MySQL 5.5 or newer • MariaDB 5.5 or newer ## See also 1.17 Which Database versions does phpMyAdmin support? ## Web browser MYSQL_ROOT_PASSWORD when starting the MySQL container). Please check documentation for MariaDB container [https://hub.docker.com/_/mariadb] or MySQL container [https://hub.docker.com/_/mysql]. ## Customizing configuration

a free software tool written in PHP that is intended to handle the administration of a MySQL or MariaDB database server. You can use phpMyAdmin to perform most administration tasks, including creating authentication modes ## Database phpMyAdmin supports MySQL-compatible databases. • MySQL 5.5 or newer • MariaDB 5.5 or newer ## See also 1.17 Which Database versions does phpMyAdmin support? ## Web browser MYSQL_ROOT_PASSWORD when starting the MySQL container). Please check documentation for MariaDB container [https://hub.docker.com/_/mariadb] or MySQL container [https://hub.docker.com/_/mysql]. ## Customizing configuration

a free software tool written in PHP that is intended to handle the administration of a MySQL or MariaDB database server. You can use phpMyAdmin to perform most administration tasks, including creating authentication modes ## Database phpMyAdmin supports MySQL-compatible databases. • MySQL 5.5 or newer • MariaDB 5.5 or newer ## See also 1.17 Which Database versions does phpMyAdmin support? ## Web browser MYSQL_ROOT_PASSWORD when starting the MySQL container). Please check documentation for MariaDB container [https://hub.docker.com/_/mariadb] or MySQL container [https://hub.docker.com/_/mysql]. ## Customizing configuration

37 Multi-cell ..... 38 Supported Databases ..... 38 MySQL versions 5.6 to 8.0 ..... 38 MariaDB versions 10.0 to 10.3 ..... 38 See also ..... 39 What Is Vitess ..... 39 Features ..... 39 sure to add go to your bashrc: export PATH=$PATH:/usr/local/go/bin Packages from CentOS repos The MariaDB version included with CentOS 7 (5.5) is not supported by Vitess. First install the MySQL 5.7 repository well as 20GB of available disk space. ## I nstall MySQL and etcd Vitess supports MySQL 5.6+ and MariaDB 10.0+. We recommend MySQL 5.7 if your installation method provides a choice: # Ubuntu based sudo

a free software tool written in PHP that is intended to handle the administration of a MySQL or MariaDB database server. You can use phpMyAdmin to perform most administration tasks, including creating authentication modes ## Database phpMyAdmin supports MySQL-compatible databases. • MySQL 5.5 or newer • MariaDB 5.5 or newer ## See also 1.17 Which Database versions does phpMyAdmin support? ## Web browser MYSQL_ROOT_PASSWORD when starting the MySQL container). Please check documentation for MariaDB container [https://hub.docker.com/_/mariadb] or MySQL container [https://hub.docker.com/_/mysql]. ## Customizing configuration

a free software tool written in PHP that is intended to handle the administration of a MySQL or MariaDB database server. You can use phpMyAdmin to perform most administration tasks, including creating authentication modes ## Database phpMyAdmin supports MySQL-compatible databases. • MySQL 5.5 or newer • MariaDB 5.5 or newer ## See also 1.17 Which Database versions does phpMyAdmin support? ## Web browser MYSQL_ROOT_PASSWORD when starting the MySQL container). Please check documentation for MariaDB container [https://hub.docker.com/r/_/mariadb/] or MySQL container [https://hub.docker.com/r/_/mysql/]. ## Customizing configuration

a free software tool written in PHP that is intended to handle the administration of a MySQL or MariaDB database server. You can use phpMyAdmin to perform most administration tasks, including creating authentication modes ## Database phpMyAdmin supports MySQL-compatible databases. • MySQL 5.5 or newer • MariaDB 5.5 or newer ## See also 1.17 Which Database versions does phpMyAdmin support? ## Web browser MYSQL_ROOT_PASSWORD when starting the MySQL container). Please check documentation for MariaDB container [https://hub.docker.com/_/mariadb] or MySQL container [https://hub.docker.com/_/mysql]. ## Customizing configuration

使用 Docker 建立 Mysql 集群 ## 软件环境介绍 操作系统：Ubuntu server 64bit 14.04.1 Docker 版本 1.6.2 数据库：Mariadb 10.10 （Mariadb 是 MySQL 之父在 MySQL 被 Oracle 收购之后创建的分支，性能上优于 MySQL 开源版本） ## 第一步 安装 Docker 对于 Ubuntu，建议直接联网安装 首先要把企业常用软件包的软件源安装上 yum install epel-release 然后再 yum install docker-io ## 第二步 运行 Mariadb 容器 首先要将数据镜像拉下来 docker pull mariadb:latest 注意，如果不加:latest 标签，docker 会把所有的镜像版本都拉下来。 然后我们就可以启动镜像了，参数方面需要注意的有以下几点： MYSQL_USER=medical_waste \ -e MYSQL_PASSWORD=medical_waste \ -e MYSQL_DATABASE=medical_waste \ -e TERM=linux \ -d mariadb ## 第三步 配置一主一从集群 ### 3.1 接下来启动另一个容器作为从数据库，因为镜像不支持在容器内进入 mysql 控制台，所以依然需要把端口暴露出来以供局域网访问，但主数据库容易可以链接进来作为一个可访问的主机

Connect with Different Profiles 51 Chapter 5 - Server Objects 52 About Server Objects 52 MySQL / MariaDB 52 Databases 52 Tables 52 Views 53 Procedures / Functions Tablespaces Events Other Objects chapter 15 - Backup & Restore 264 About Backup & Restore 264 MySQL / PostgreSQL / SQLite / MariaDB (Available only in Non-Essentials Edition) 264 About Built-in Backup & Restore Tool 264 Backup 280 Extract Command 281 Chapter 16 - Server Security 283 About Server Security 283 MySQL / MariaDB User & Role Management 283 User Designer 283 Role Designer 284 Oracle User & Role Management