1. Environment preparation Host name IP mysql1 10.0.0.10 mysql2 10.0.0.11 mysql3 10.0.0.12 mysql4 10.0.0.13 system ubuntu22.04 1.1 Change host name mysql1 hostnamectl set-hostname mysql1 mysql2 hostnamectl set-hostname mysql2 mysql3 hostnamectl set-hostname mysql3 mysql4 hostnamectl set-hostname mysql4 1.2 Configure hosts resolution all nodes cat >> /etc/hosts << EOF 10.0.0.10 mysql1 10.0.0.11 mysql2 10.0.0.12 mysql3 10.0.0.13 mysql4 […]
Tag: mariadb
Android/Hongmeng mobile phones use termux to install mariaDB, Centos is equipped with jdk, and Tomcat is used to create a personal mobile server.
Article directory Preface 1. Preparation work 2. Prepare the installation package 3. Install termux 4. Install Centos using termux (too much nonsense, let’s start the real installation) 5. Upload and decompress tomcat and jdk (it is recommended to operate on a computer) 6. Centos configures jdk and Tomcat environment (start Centos first) 7. Install mariaDB […]
Install MariaDB on RockyLinux
Article directory 1 Introduction 2 references 3 Start installation 3.1 Run the official script and add the source of MariaDB 3.2 Install MariaDB Server 3.3 Start MariaDB 4 SSH login to MariaDB 4.1 Log in using the root account on ssh 4.2 Create a new administrator account and authorize it 5 Release port 3306 5.1 […]
Mixing SQL with NoSQL using MariaDB and MongoDB
Suppose you have an application developed on Node.js (or any other platform). This application connects to a MongoDB database (NoSQL) that stores ratings of books (number of stars given and reviews). Let’s also say you have another application developed in Java (or Python, C#, TypeScript…etc.). This application connects to a MariaDB database (SQL, relational) and […]
How to optimize queries and tables in MySQL and MariaDB – improve query efficiency
Foreword MySQL and MariaDB are popular choices for database management systems. Both use the SQL query language to enter and query data. Although SQL queries are simple commands to learn, not all queries and database functions are equally efficient. As the amount of information you store grows, if your database supports a website, this becomes […]
Installation and use of mariadb in Linux
1, the relationship between mariadb and MySQL: ? Both MySQL and MariaDB are open source database technologies. MySQL is the most widely adopted open source database. It is the primary relational database for many applications and commercial products. MariaDB is a modified version of MySQL. After MySQL was acquired by Oracle Corporation, the original MySQL […]
MariaDB+SpringBoot error Caused by: java.sql.SQLException: GSS-API authentication exception
Recently, when I was building a springboot + mybatis + mariadb project, I encountered a problem like the title. After searching around, I couldn’t find a suitable solution, so I recorded my solution, hoping to help the latecomers. Let’s talk about the conclusion first, just reinstall MariaDB! ! ! ! 1. Environment and configuration information […]
Ansible deploys MariaDB galera cluster (multi-master)
Article directory Ansible deploys MariaDB galera cluster (multi-master) introduce Node planning Basic environment preparation Write script file Execute script file View cluster status test Ansible deploys MariaDB galera cluster (multi-master) Introduction MariaDB Galera cluster is a multi-master MySQL cluster solution based on synchronous replication. The nodes used have no single point of failure, high availability, […]
Galaxy Kylin installs mysql database (mariadb)-Galaxy Kylin installs JDK-Galaxy Kylin installs nginx (with installation package)
Galaxy Kylin Offline Complete Installation Tutorial (hands-on tutorial) 1. Install the mysql database (mariadb) on the Galaxy Kylin server system 2. Install the mysql database (mariadb) on the Galaxy Kylin desktop system 3. Install JDK on Galaxy Kylin server system 4. Install JDK on Galaxy Kylin desktop system 5. Install nginx on the Galaxy Kylin […]
Tongxin UOS installs mysql database (mariadb) – Tongxin UOS installs JDK – Tongxin UOS installs nginx (with installation package)
Union UOS offline complete installation tutorial (hands-on tutorial) Various offline complete installation tutorials of Galaxy Kylin: https://blog.csdn.net/ACCPluzhiqi/article/details/131988147 1. Install mysql (mariadb) on Tongxin UOS desktop system 2. Install JDK on UOS desktop system 3. Install nginx on UOS desktop system Union UOS server operating system has not been seen to be used by any unit, […]