I. Environmental preparedness1. First introduce the environment, and our protagonists todayI use the environment is minimized installation of the centos7,mariadb (rumors of MySQL after the acquisition of Oracle, people worried like Java as destroyed in Oracle's hands as a new branch, but still like MySQL),php7.1.0 (version does not matter, are 7 version), nginx1.10 (we installed stable version without blindly pursuit of new), memcached, and Redis can
Database replication in the actual production environment for improving the security of data and database performance is an important means, but no matter how clever, you should start from a simple copy! Today's experiment begins with a simple copy!
Experiment Preparation
Server Type/Name
IP Address
Software version
Platform
Master/node4
192.168.1.114
mariadb-10.0.10
CentOS 6.5 x86_64
The day before yesterday in the Linux 128MB Small memory VPS Server installed Web site environment environment is the default installation of the MySQL database, found that the script is not running when the memory is not enough to install, and even if the installation of the successful memory resources are still relatively large. Replace the MySQL database with MARIADB database and install successfully, occupy resources and run is all normal.
Tags: HTTPS anonymous select using TPS Pass update CENTOS7 blank1. Installation I am using CentOS 7, the default Yum installation, but the default Yum installation version is a bit low, you can choose to upgrade as needed, I choose to upgrade and install first. Update Yum Update Yum package
yum-y Update
Configuring the Yum Source Vi/etc/yum.repos.d/mariadb.repo
Enter the following in the text that opens: [MARIADB]
Name =
After more than an hour, I checked the summary on the Internet and successfully registered the MariaDB Green Edition Service and changed the password. I will share it with you. Please do not spray it. Mysqlmariamariadb1optimize and create Windows Service mysql_install_db.exe -- datadirD: mariadb-10.0.16-win32 -- serviceMySql -- passworddsidea
After more than an hour, I checked the summary on the Internet an
MariaDb database management system learning (I) installation process diagram MariaDB
The MariaDB database management system is a branch of MySQL. it is mainly maintained by the open-source community and licensed by GPL. One of the reasons for developing this branch is that after Oracle acquired MySQL, there is a potential risk of closing the source of MySQL. Th
Centos 6.5 Build PHP Environment (NGINX+MARIADB+PHP7), Centosnginx
PHP is a piece of cake, the first time to write Bolg, there is nothing wrong, but also ask you to greatly point out
1.mariaDb
vim/etc/Yum. Repos.d/mariadb.repo
[mariadb]= mariadb= http://yum.mariadb.org/5.5/centos5-x86gpgkey=https:// YUM.MARIADB.ORG/RP
Example 1
Currently the official latest stable version is MariaDB-5.5.35 download address: https://downloads.mariadb.org/mariadb/5.5.35/
Before compiling, you first have to install the compilation tool and some other dependent packages:
The code is as follows
Copy Code
Yum groupinstall-y "Developmen Tools"Yum install-y cmake openssl-devel zlib-develCd/webappwget https://downloa
Tags: existing linu ant fir created adb log cat keyThe following is an official MARIADB document explaining how MARIADB is installed on a host that already exists on a MySQL instance:https://mariadb.com/kb/en/library/installing-mariadb-alongside-mysql/However, if you install the MARIADB first, then install MySQL, for e
MARIADB IntroductionMARIADB is a MySQL branch maintained by the open source community, developed by Michael Widenius, the founder of MySQL, with a GPL licensed license.MARIADB is designed to be fully compatible with MySQL, including APIs and command lines, making it easy to be a replacement for MySQL.For more information, please refer to the link:http://mariadb.org/(official website)Http://baike.baidu.com/link?url=dFJ-My-I52YFc1mx26K804LPwZrcEWCwB4Iqf
centos7.3 install MARIADB by yum modeInstall by installing a package groupYum GroupInfo mariadb mariadb-clientYum Groupinstall mariadb mariadb-clientStart the service, the first boot time is a bit longSystemctl Start mariadbSystemctl Status mariadbSystemctl Enable MARIADBSec
#!/bin/bash#Date: 2017-04-23#Author: Allen_jol#mariadb_install_v1.0.sh#Version: mariadb-10.1.22mariadb_version= "Mariadb-10.1.22.tar.gz"echo "MARIADB version: $MARIADB _version"Pathway=/usr/local/srcCD $PATHWAYecho "====================prepare======================"echo "originally loaded or comes with MySQL as follows
The most basic cluster mode for Mysql and MariaDB is the master-slave mode, which is also the most widely used cluster mode for many small and medium-sized enterprises. This cluster is easy to deploy and can be used. Let's step by step. The version used for the test is MariaDB10.1 source code installation, installed under the default path usrlocalmysql. $ BUILDautorun. sh $. configure $ make-j4 $ sudo
The most basic cluster mode for Mysql and
This article describes how to compile and install the Nginx + PHP + MariaDB Development Environment on MacOS, including using phpize to install PHP extensions. For more information, see Oracle's urine. Mariadb should replace mysql. So discard mysql
1. Compile nginxDownload nginx, openssl, and pcreWhen compiling openssl, a prompt is displayed.
WARNING! If you wish to build 64-bit library, then you have toi
This article describes how to compile and install the Nginx + PHP + MariaDB development environment on MacOS, including using phpize to install PHP Extensions. For more information, see Oracle's urine. Mariadb should replace mysql. So discard mysql
1. compile nginxDownload nginx, openssl, and pcreWhen compiling openssl, a prompt is displayed.
WARNING! If you wish to build 64-bit library, then you have toi
System Environment: CentOS 7MARIADB version: Mariadb 10.0.14Download Address: http://mirrors.neusoft.edu.cn/mariadb/mariadb-10.0.14/source/mariadb-10.0.14.tar.gzOther Package Address: https://downloads.mariadb.org/
Add a MySQL User
Useradd MySQL
Start Compiling installation mari
Centos7.3 binary Format Installation mariadbbackground:CentOS7 started with the database using the MARIADB database, and Yum installed a relatively low database version, so learned in the CentOS7.3 version of the binary installation MariaDB-10.2.8, in this record installation process for later reference. The binary installation is primarily designed to eliminate the time to compile and install, which is too
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.