CentOS 7.0 use yum to install simple configuration of MariaDB and MariaDB
I forgot about the environment configuration of the space that has been idle for a long time. I have to leave it empty today and reset the disk to re-build the environment. First, install the MariaDB database in CentOS 7.0, and record the installation process here, for later viewing.
1. Ins
MariaDB command introduction and MariaDB architecture and Index
Mariadb> show global variables; global variables affect GLOBAL operations on the server.
Mariadb> SHOW [SESSION] VARIABLES; client variable, effective only for the current SESSION
Note: Some of these parameters can be modified at run time and will take eff
://yum.mariadb.org/5.5/centos6-amd64Gpgkey=https://yum.mariadb.org/rpm-gpg-key-mariadbGpgcheck=1
2, remove MySQL
I have tested that mysql5.1,mysql5.5 can be smoothly transferred to mariadb,mysql5.6.x and not tested. Do not be assured that you can use mysqldump for backup. Do not delete MySQL can not be loaded mariadb# yum Remove MySQL Mysql-server3, install MARIADBView copy print?# yum Install
Project migration from MYSQL to MARIADB tutorial, mysql migration mariadb
Prepare the database (MySQL). If MySQL already exists, ignore it.
build MySQL table;
Connect to MySQL;
mysql -u root -p
Create a data table;
mysql> create database demo;mysql> use demo;mysql> create table pet(name varchar(30), owner varchar(30), species varchar(20), sex char(1));
Add data table content;
mysql> insert into pet values('
The following is a look at mariadb multi-source replication (mariadb Multi-master replication) example, I hope to help you.MARIADB multi-source Replication (mariadb Multi-master replication)A multi-master replication feature was added to the mariadb-10.0.Modified syntax:For each replication thread there is a correspond
1, installation mariadbInstallation commandsYum-y Install mariadb Mariadb-serverInstallation Complete mariadb, first start mariadbSystemctl Start mariadbSet boot upSystemctl Enable MARIADBThe following is a simple configuration of mariadbMysql_secure_installationThe first is to set the password, you will be prompted to enter the passwordEnter current password to
Mariadb database installation process, mariadb database Process
As we all know, after Oracle acquired MySQL, there is a potential risk of shutting down the source of MySQL. MariaDB aims to be fully compatible with MySQL, including APIs and command lines, it can easily become a substitute for MySQL. MariaDB name is the
Install MariaDB in RHEL 7 and mariadb in rhel 7
Start with RedHat Enterprise Linux 7, and the self-contained database on the system disk is MariaDB. The installation steps are as follows:
1. Mount the installation disk image:Mount/dev/cdrom/mnt
2. Create a yum Source:Cat>/etc/yum. repos. d/d. repo
[D]
Baseurl = file: // mnt
EOF
3. Import key:Yum -- import/mnt/R
MARIADB multi-source Replication (mariadb Multi-master replication)Multi-master replication is added to the mariadb-10.0.
Modified syntax:there is a corresponding connection_name for each replication thread, and Connection_Name is the value of the default_master_connection variable, if you want to manipulate the corresponding replication thread, This variable ne
first, the basic knowledgeThe importance of data is needless to say, it should be emphasized that the backup is not the purpose, can recover is the purpose, the following mariadb some concepts to explain.1. Classification of storage enginesMariadb5.1 later versions, by default using the InnoDB storage engine that supports transactions, the previous MyISAM storage engine does not support transactions, and the so-called transactional storage engine must
Mariadb introduction, mariadb
Transaction: organizes multiple operations into one whole. They are either executed in full or not rolled back or rollback.
SQL interface: SQL statement analyzer and optimizer
Table: Splits a dataset into multiple
Constraint: constraint, rules to be followed for data inserted into a data table
Primary Key: a combination of one or more fields. Fill in the data in the primary ke
Translation: Value assignment operator (: =) (submitted to the MariaDB official Manual), operator mariadb
This article is a translation of the value assignment operator (: =) in the mariadb official manual.
Original article: https://mariadb.com/kb/en/assignment-operator/Https://mariadb.com/kb/zh-cn/assignment-operator/ I submitted to the
the monitoring machine address. MariaDB [(none)]> grant all on *.* to ‘testdba‘@‘192.168.126.140‘ identified by ‘123456‘;
MariaDB [(none)]> flush privileges; //刷新// 4) Log on to the monitoring server. [[emailprotected] ~]# yum install mariadb-server mariadb -y
[[emailprotected] ~]# mysql -utestdba -p -h 192.168.126.18
Tags: mysql mariadbI. Introduction of MARIADBMARIADB is a relational database program that MySQL was re-developed by the original author after being acquired by Oracle, and because it is the same author, it is very similar to MySQL in operation, and the versions correspond to each other. such as: MariaDB5.5 corresponds to the 5.5 version of MySQL, but the corresponding version of the mariadb from Mysql5.6 to become more than 10, such as: MariaDB10.1 c
MariaDB binary installation, mariadb binary
Download the binary installation package
wget http://mirrors.neusoft.edu.cn/mariadb//mariadb-10.2.12/bintar-linux-x86_64/mariadb-10.2.12-linux-x86_64.tar.gz
Create a mysql user and group
useradd -r mysql -s /sbin/nologin
Decompres
makes it very easy to track and compare replication things and to recover quickly from crashes. In particular, the INNODB engine must be implemented with the help of gtid in order to achieve high-availability functionality.Second, the application scenarioGtid is especially important when using mariadb for high availability, for example, in a high-availability environment, in a master multi-slave mode, when the main library goes down (write latency),
Connect to Mariadb and mariadb remotely
// This article describes how to connect to the Mariadb database on centos7.
// There is no difference with mysql
Package test. java. mysql; import java. SQL. connection; import java. SQL. driverManager; import java. SQL. SQLException; import java. SQL. statement; public class TestMysql {public static void main (String [] a
MariaDB multi-instance and MariaDB instance1. Install MariaDB in yum and start
yum install MariaDB-serversystemctl start mariadb.service
2. Create a directory by case and set the owner Group
Store configuration files and databases by case
mkdir -pv /mysqldb/{3306,3307,3308}/{etc,socket,pid,log,data}
Set directory own
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.