On

Click follow the public account and use the fragmented time to learn

MySQL is a relational database management system developed by MySQL AB of Sweden and is part of the Oracle family. MySQL is one of the most popular relational database management systems, and MySQL is one of the best RDBMS (Relational Database Management System) applications when it comes to WEB applications.

Here is mainly about mysql deployment on k8s, mysql deployment on k8s advantages are mainly the following points:

Official Documentation:

https://docs.oracle.com/en-us/iaas/mysql-database/doc/getting-started.html

An introduction to the MySQL principle can also refer to this article:

https://www.cnblogs.com/liugp/p/16500048.html

Modify mysql/values.yaml

Add mysql/templates/pv.yaml

Add mysql/templates/storage-class.yaml

NOTES

View pod status

【Tips】From the library (slave) is read-only. It is a simple read and write test, and there is a pod hanging, whether it can be pulled up normally and so on. This test verification is relatively simple. I’m not going to walk through here.

Prometheus：https://prometheus.k8s.local/targets?search=mysql

The acquisition data can be viewed by command

Grafana：https://grafana.k8s.local/
Account: admin, password obtained by the following command

Import grafana template, cluster resource monitoring: 7362

Official module download address:

https://grafana.com/grafana/dashboards/

Here is only the realization of mysql master-slave, did not achieve high availability, the official currently has no mysql ok k8s high availability of the implementation program, although there are also high availability of the implementation scheme on the Internet, but our company did not really go to the ground to use, so do not evaluate the high availability of the program on the Internet, interested partners can try, in fact, mysql in the field of big data is generally only as a metadata store, the main hanging, the impact is not very large.

At present, we are also studying the high-availability implementation of mysql on k8s, if there is a mysql on k8s high availability in the later stage, it will be used in the production environment, and then share it again. MySQL on k8s environment deployment is here first, friends with questions welcome to leave me a message ~

Recommend:

The most comprehensive Java interview question bank