CentOS 7.4 MariaDB Galera Cluster

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 the software package […]

Read more
MARIADB MASTER SLAVE

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 […]

Read more
Mariadb centos 7.4

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 […]

Read more
MySQL Databases to Separate Disks

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 […]

Read more
Installing Memcached to Improve Database Performance

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 […]

Read more
Installing and Configuring MariaDB 10 on CentOS 6

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. […]

Read more
Detailed MySQL basic commands

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 […]

Read more
Mysql Secure Installation for non default socket.

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 is started with […]

Read more
MYSQL mariadb CENTOS 7

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! […]

Read more

Hit Counter provided by dental implants orange county