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
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
Install and configure MariaDB on RHEL/CentOS
MariaDB is an open-source relational database and a MySQL database branch version developed by the community. MariaDB has replaced MySQL as the default database in RHEL/CentOS 7.
In this tutorial, we will discuss installing and configuring MariaDB on CentOS/RHEL 7 machines.(
CentOSandRHEL7: InstallLinux, Apache, MariaDB, PHP (LAMP) Stack RHELCentOSApacheLAMPMariaDB
IAm new Red Hat Enterprise Linux version 7 user/sysadmin/developer. this version made the big number change for RHEL 7/CentOS 7. how can I install LAMP (Linux, Apache, MariaDB, PHP) stack on a RHEL version 7 or CentOS Linux version 7 using CLI or over ssh based session?
Tutorial details
Note:Operating System: CentOS 5.10 32-bitMariaDB: mariadb-5.5.33aMariaDB database storage directory:/data/mysqlPreparation:1. Configure the IP address, DNS, and gateway to ensure that the remote connection tool can be used to connect to the server. The yum command on the server can be used normally.2. configure the firewall and enable port 3306Vi/etc/sysconfig/ip
the database we just created from MySQL to mariadb.
Note: A fedora-based Linux distribution using CentOS does not need to refer to this tutorial because they automatically replace MySQL when installing MARIADB, without backing up the existing database, you only need to update MySQL to get mariadb.
1. Back up the existing database
Our first important step is to b
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
Tags: str 127.0.0.1 def RES development not MySQL open source supportFirst, MySQL background informationMySQL became popular in the early days of the Internet, pursuing speed, simplicity, open source, and support for almost all operating systems. Fully support multi-user, multi-threading, support massive data storage, using MyISAM, InnoDB two big storage engine complement each other. But with InnoDB and MySQL itself being acquired by Oracle, the founder of MySQL has developed mariadb.MARIADB's b
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
1, start mariadb
Install complete mariadb, start mariadb First, two commands can be
Systemctl Start mariadb
Or
Service MARIADB Start
Setting up Boot
Systemctl Enable MARIADB
Or:
Chkconfig
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
parameters of multiple different files are merged and the configuration file found at the End prevails. the configuration file used by mysql is/etc/mysql/my. cnf instead of/etc/my. cnf.
11. Copy the service script
# Cp support-files/mysql. server/etc/rc. d/init. d/mysqld
Add the mysqld service to the service list
# Chkconfig -- add mysqld
12. Start the service
You can see that mysql is successfully started and port 3306 has been listened.
13. A
database are not strongly consistent, but have a certain delay, many transactions may encounter errors due to delay. Dual-master does not greatly increase the write throughput because all data must be written to each database. Although there can be a small increase due to batch, it is insignificant for errors caused by latency.
It makes sense to configure dual-master, but it is not used to write data at the same time. At the same time, only one database is written. When the master fails, it is
and scalability is not good, so the enterprise generally stored on another disk will be more secure. In order to use the specification later, it is recommended that the data catalog be planned in advance and assigned in a unique location, such as finding a disk to hold MySQL data.
Iv. installation of mariadb-5.5.364.1. Download MARIADB PackageMARIADB official site Download the
CentOS 7 installation of MariaDB 10 and related configuration, centosmariadb
Step 1: Add MariaDB yum Repository
Add the MariaDB yum configuration file MariaDB. repo in the/etc/YUM. repos. d/directory of the CentOS operating system.
Vi/etc/yum. repos. d/MariaDB. repo
Add the
(Operating System: CentOS5.1032-bit MariaDB version: mariadb-5.5.33aMariaDB database storage directory:/data/mysql preparation article: I. Configure IP, DNS, gateway, make sure that the remote connection tool can be used to connect to the server. The yum command on the server can be used normally. 2. configure the fire
is still in alpha state) is Maria 10.0, followed by a decimal point:
Mysql-P 3406-u root-p
Enter password :********
Welcome to the MariaDB monitor. Commands end with; or \ g.
Your MariaDB connection id is 1
Server version: 10.0.2-MariaDB mariadb.org binary distribution
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.