MySQL: Install
by Mark Nielsen
Copyright 2021, 2022
We are going to focus on MySQL 8.0 and MariaDB and Percona. Will go briefly over MySQL
install, NDB, and Galera Cluster (Percona and MariaDB). Even though the GUI programs
are great, will be focusing on line command.
- Links
- GUI install
- Command Line
- Replication
- NDB
- Galera (Percona and MariaDB)
Links
- https://www.percona.com/doc/percona-xtradb-cluster/LATEST/install/index.html
- https://www.percona.com/doc/percona-xtradb-cluster/5.7/overview.html
- https://www.percona.com/software/mysql-database/percona-xtradb-cluster
- https://severalnines.com/product/clustercontrol/clustercontrol-community-edition
- https://dev.mysql.com/doc/mysql-cluster-excerpt/5.6/en/mysql-cluster-install-debian.html
- https://www.digitalocean.com/community/tutorials/how-to-create-a-multi-node-mysql-cluster-on-ubuntu-18-04
- https://www.mortensi.com/2018/07/high-availability-with-mysql-cluster-setup-from-command-line-ii/
- https://mariadb.com/kb/en/getting-started-with-mariadb-galera-cluster/#installing-mariadb-galera-cluster
GUI install
Although the GUI programs are great, I will be sitcking to line command. I am in favor of
GUI progrms.
MySQL + Replication
Galera
NBD
Command Line
We are going to focus on Ubuntu. This is very simple. We will download the percona version.
Replication
Now we will setup Master and Slave on the same system.
NDB
The article mentioned in the links is a good article. This will be a simple set of steps
just to get it setup without the explanation.
Galera (Percona and MariaDB)
Percona has excellent docs to install it manually. MariaDB also has good docs, but I think
Perconas is simplier.