|
||||||
|
Mariadb galera cluster installation: Operating system: CentOS 7.4 version Cluster number: 3 nodes Host information: 192.168.153.142 node1 selinux=disabled firewalld Shutdown 192.168.153.143 node2 selinux=disabled firewalld Shut down 192.168.153.144 node3 selinux=disabled firewalld Shut down Build steps 1. Hosts resolve each other: all three nodes must execute vim /etc/hosts 192.168.153.142 node1 192.168.153.143 node2 192.168.153.144 node3 2. Install […] MARIADB MASTER SLAVE Install on both master and slave yum install mariadb-server mariadb -y systemctl enable mariadb systemctl start mariadb.service mysql_secure_installation Master Add below lines on the mysql vi /etc/my.cnf [server] # add follows in [server] section : get binary logs log-bin=mysql-bin # define uniq server ID server-id=101 Restart the mariadb service systemctl restart mariadb.service […] Mariadb centos 7.4 vi /etc/yum.repos.d/Mariadb.repo # MariaDB 10.1 CentOS repository list # http://downloads.mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.1/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 yum -y install MariaDB-server MariaDB-client systemctl start mysql.service mysql_secure_installation Enter current password for root (enter for none): Set root password? [Y/n] y New password: Re-enter new password: Remove anonymous users? [Y/n] y Disallow […] There are several types of InnoDB engine tables in MySQL (the following index, no special instructions, refers to the InnoDB engine table index.) 0 = Secondary Index, 2-level index, 1 = Clustered Index, clustered index 2 = Unique Index, Unique Index 3 = Primary Index, Primary Key Index 32 = Full-text Index, Full Index 64 […] You may have a database server which started out small, with all its databases stored on the same disks, that is now experiencing severe storage I/O bottlenecks. With so many heavily accessed databases on the same storage device your queries are timing out while waiting for response from disk. And despite all your efforts in […] SQL databases are very good at storing and retrieving data, and they can do so quickly. However, no matter how well you tune your database servers there will come a time during periods of high traffic that your database server becomes a large bottleneck. By utilizing technologies like Memcache, we can keep results of frequently […] This tutorial will guide you through the deployment process of MariaDB on a Red Hat-based Linux server, such as CentOS. We’ll start by configuring the hardware and then move into the installation and configuration of MariaDB. MariaDB is a fork of the very popular and open source MySQL database, which is now owned by Oracle. […] Detailed MySQL basic commands Format: mysql -h host address -u user name -p User password 1, is connected to the machine on MYSQL. First, open a DOS window, then enter the directory mysql \ bin, then type the command mysql -u root -p, you lose the password prompt after the carriage return may or may […] Mysql Secure Installation for non default socket. SECURING MYSQL SERVER – mysql_secure_installation is a script useful to set root password disallowing root login remotely removing anonymous user accounts after first installation removing test database which can be accessed by any users Above script would work for default socket location i.e /var/lib/mysql/mysql.sock If the server […] MYSQL CENTOS 7 wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm rpm -ivh mysql-community-release-el7-5.noarch.rpm yum update yum install mysql-server systemctl start mysqld [root@clusterserver1 ~]# systemctl start mysqld [root@clusterserver1 ~]# systemctl enable mysqld [root@clusterserver1 ~]# systemctl status mysqld [root@clusterserver1 ~]# mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! […] |
||||||
|
Copyright © 2024 - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
Recent Comments