Tag：mariadb
-
Time：2021-10-17
The previous article introduced several methods to implement PivotTable in Oracle. Today, let’s see how to implement the same functions in MySQL / MariaDB. The sample data used in this article can be downloaded here. Use case expressions and group aggregation The essence of PivotTable report is to group data according to different combinations of […]
-
Time：2020-12-17
Recently, due to the need of testing security products, I want to adjust the starting user of MariaDB as root. After some twists and turns, I finally succeed! Note: starting MySQL as root is a very dangerous behavior, which is equivalent to giving database operation users (database administrators or hackers) a channel to directly operate […]
-
Time：2020-11-22
The server / client installation package for MySQL is provided in CentOS 6 and earlier versions, but CentOS 7 has replaced the default MySQL with MariaDB. MariaDB database management system is a branch of MySQL, which is mainly maintained by the open source community. The purpose of using GPL to license MariaDB is fully compatible […]
-
Time：2020-11-19
MariaDB database management systemIt is an alternative database for MySQL. MariaDB is a logical choice for scalable and reliable SQL servers. MariaDB 10.5 is the current stable series of MariaDB. PS: here it isOfficial installation version and decompression version of the tutorial diagramFor reference only, please refer to the operation steps of this article for […]
-
Time：2019-12-15
Be careful:This tutorial uses clean CentOS 7 for installation. If you have installed other environments or software, involving kernel upgrade, please back up properly, which may cause incompatibility or other problems with the software you have installed. Disclaimer:This tutorial is written with personal experience only and may not be suitable for all system environments. I […]
-
Time：2019-11-20
First, dump data from the primary database to complete data backup from the secondary database Create a hot standby account in the main database, and authorize the replication slave permission: grant replication slave on *.* to “slave”@”192.168.3.206” identified by “admin” flush privileges; Modify the configuration file of the main library and add the following configuration. […]
-
Time：2019-10-17
Rancher ha high availability cluster deployment document I. preparatory work 1. Lancher server node: 1). 8g or 16g or above (you need another 3 G for the test environment)2). The server node will occupy port 809435 in this operation (if these two ports are already occupied, you can customize other ports).3). Version: lancher: v1.6 2. […]
-
Time：2019-9-28
Introduction to the Teaching EnvironmentServer side: Ubuntu 18.04 LTSDatabase: Mariadb 10.1.34 (Mysql)Language version: PHP 7.3Local end: MacOS High Sierra The profile written on the network is / etc / MySQL / my. CNFBut what I’m actually looking for is 50-server.cnf under mariadb.conf.d. (Maybe the difference between Mysql and MariaDB?) $ cd /etc/mysql/mariadb.conf.d Open with nano […]
-
Time：2019-7-12
Scenario Hypothesis Scenario 1: There are two tables which are distributed on different instances. They want to make a statistic through a field association, or they want to merge tables distributed on different instances into one instance to make some queries. Scenario 2: Because of the bottleneck of database capacity or the bottleneck of database […]
-
Time：2019-7-6
As you know, WordPress builds websites very quickly, especially for enterprise websites. Recently, companies have similar needs, so they try to build a WordPress site on the server. Installation of Apache Apache is also called httpd under ContOs yum -y install httpd Configuration Notes: // Create a site directory, where you create a demo site […]
-
Time：2019-5-14
In this article, we will share a common software environment for installing LAMP in the latest Ubuntu 18.04 system image. The software includes Apache 2.4/MariaDB 10.3/PHP 7.2. Here we see that instead of installing MYSQL, we use MariaDB database instead, because according to the feedback from some netizens and the actual application, MariaDB has better […]
-
Time：2019-5-9
MariaDB database management system is a branch of MySQL, which is maintained by the open source community and licensed by GPL. One of the reasons for developing this branch is that Oracle’s acquisition of MySQL has the potential risk of closing MySQL to the source, so the community uses branching to avoid this risk. MariaDB […]
