October 2018
M T W T F S S
« Sep    
1234567
891011121314
15161718192021
22232425262728
293031  

Categories

WordPress Quotes

The future belongs to those who believe in the beauty of their dreams.
Eleanor Roosevelt

Recent Comments

October 2018
M T W T F S S
« Sep    
1234567
891011121314
15161718192021
22232425262728
293031  

Short Cuts

2012 SERVER (64)
2016 windows (9)
AIX (13)
Amazon (34)
Ansibile (18)
Apache (133)
Asterisk (2)
cassandra (2)
Centos (209)
Centos RHEL 7 (258)
chef (3)
cloud (2)
cluster (3)
Coherence (1)
DB2 (5)
DISK (25)
DNS (9)
Docker (28)
Eassy (11)
ELKS (1)
EXCHANGE (3)
Fedora (6)
ftp (5)
GIT (3)
GOD (2)
Grub (1)
Hacking (10)
Hadoop (6)
horoscope (23)
Hyper-V (10)
IIS (15)
IPTABLES (15)
JAVA (7)
JBOSS (32)
jenkins (1)
Kubernetes (2)
Ldap (5)
Linux (189)
Linux Commands (167)
Load balancer (5)
mariadb (14)
Mongodb (4)
MQ Server (22)
MYSQL (84)
Nagios (5)
NaturalOil (13)
Nginx (30)
Ngix (1)
openldap (1)
Openstack (6)
Oracle (34)
Perl (3)
Postfix (19)
Postgresql (1)
PowerShell (2)
Python (3)
qmail (36)
Redis (12)
RHCE (28)
SCALEIO (1)
Security on Centos (29)
SFTP (1)
Shell (64)
Solaris (58)
Sql Server 2012 (4)
squid (3)
SSH (10)
SSL (14)
Storage (1)
swap (3)
TIPS on Linux (28)
tomcat (59)
Uncategorized (29)
Veritas (2)
vfabric (1)
VMware (28)
Weblogic (38)
Websphere (71)
Windows (19)
Windows Software (2)
wordpress (1)
ZIMBRA (17)

WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

Who's Online

31 visitors online now
7 guests, 24 bots, 0 members

Hit Counter provided by dental implants orange county

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

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

[…]

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

MySQL InnoDB engine B + tree index simple finishing instructions

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

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

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

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

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

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

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!

[…]