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
MariaDB is the best alternative to MySQL databases. Since Oracle's acquisition of SUN, the open-source community believes that Oracle has never been very popular with MySQL. It is true that MySQL, as an open-source database, has a competitive relationship with Oracle's main business, after the acquisition, its fate will be very subtle, so there is a MariaDB project. Mar
Configure GTID for MySQL and MariaDB master-slave Clusters
I wrote MySQL and MariaDB traditional master-slave cluster configuration, which is very mature. Since Mysql5.6 and MariaDB10.0, a new master-slave GTID solution has been available. However, the two systems have branches in this version. The specific implementation and configuration methods are different.
MariaDB
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.
MARIADB is an Open-source database and 100% is compatible with MySQL, with the goal of replacing the MySQL database.Mariadb's background:
In 2008, MySQL was acquired by Sun Microsystems, which was later acquired by Oracle in 2010. Sun's acquisition was initially hailed by the MySQL community for meeting the needs of the project, but the sentiment did not last long and the subsequent takeover by Oracle was unfortunately expected to be far below expect
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 =
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
How to migrate MySQL 5.5 database to MariaDB 10 on Ubuntu
This article has been tested by ourselves. The system is Ubuntu 14.04 server, and the Mysql database is Mysql 5.5. We are preparing to migrate it to Maria DB 10.1, for details about the migration methods of other versions, go to the official website. Here I will only talk about what I have tested.
As to why Oracle migrated to MariaDB, users who know
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
Tags: binary centos7 mariadbExperiment One: Centos7 binary installation mariadb latest version 10.2.81. Check whether the system is installed mariadbRpm-qa mariadb*2, create the system user MySQL, and specify its home directory for/APP/MYSQLDBGetent passwd MySQL Query If there is a MySQL user
useradd-d/app/mysqldb-r-m-s/sbin/nologin MySQL
#-R Create System user-M Create home directory-D Specify home directo
We run 3 MySQL services on the same server to open the 3306,3307,3308 port separately############################################### # # Installation MARIADB # ###############################################Slightly############################################### # # of Initialization Environment # ###############################################1) Create 3 directories to save 3 data for each instance[[email protected] ~]# mkdir-p/
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
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.