Exabig - Page 4 of 6 - My blogs, technology world MySQL, Devops and so on ...

MySQL Auto Failover using Keepalived

Keepalived is a routing software written in C. It provide simple and robust facilities for loadbalancing and high-availability to Linux system. Loadbalancing framework relies on well-known and widely used Linux Virtual Server (IPVS) kernel module providing Layer4 loadbalancing. Keepalived implements a set of checkers to dynamically and adaptively maintain and manage loadbalanced server pool according…

Install Terraform on CentOS 7

Terraform is an automation software which allows you to manage infrastructure resources from code efficiently. It allows you to manage any cloud environment like aws, gcp, azure etc. You can use Terraform to build, change, and version infrastructure deployed on proprietary cloud providers or your own infrastructure on premises. Terraform is distributed as a binary…

Puppet Bolt

Puppet Bolt: an open source, agentless multi-platform automation tool that reduces your time to automation and makes it easier to get started with DevOps. This is similar to ansible. The Puppet task runner is driven through a command line interface and executes commands via SSH. So, you are not required to install any agent software…

Puppet Hiera 5 Setup

Hiera is Puppet’s built-in key/value data lookup system. By default, it uses simple YAML or JSON files, although you can extend it to work with almost any data source. Hiera is the most flexible way to get configuration data into Puppet. Hiera is immensely powerful, and with great power comes great responsibility. Specifically, you’re responsible…

Setup Puppet Server 6 on CentOS 7

Puppet is a ruby based configuration management tool (IT automation software), licensed under Apache 2.0 designed to help system administrators, automate many repetitive task they regularly perform . It is open-source, flexible, customizable framework for managing the configuratons of computer system. It defines and enforce the state of your infrustructure throughout the software development cycle.…

Flyway: Database Versioning

Flyway is an open-source tool database versioning tool, licensed under Apache License 2.0, that helps you implement automated and version-based database migrations. It allows you to define the required update operations in an SQL script or as Java code. You can then run the migration from a command line client or automatically as part of…

JDBC & MySQL: WARN: Establishing SSL connection without server’s identity verification is not recommended.

While setting up flyway database versioning. I encountered with a warning. Flyway is a database versioning tool. WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using…

Create Python Environment for development

Virtual environment, a self-contained directory tree that contains a Python installation for a particular version of Python, plus a number of additional packages. Ubuntu 18.04 LTS comes with default Python3. In order to install pip3 and virtual environment use the below command. Install Components sudo apt-get install python3 python3-pip python3-venv The above command update the…

Install Python3 and pip3 on CentOS 7

Krishna Prajapati November 29, 2016 - 4:24 pm January 26, 20175

CentOS 7 still have Python 2.7 as the default tool. EPEL repository comes up with Python 3. Thanks to EPEL repo. Here’s the way to setup Python 3 and pip3 on CentOS environment. Install python34 and python-pip package. [root@cms ~]# yum install python34 python-pip Loaded plugins: fastestmirror Loading mirror speeds…

Disable Selinux on CentOS 7

Krishna Prajapati November 29, 2016 - 2:33 pm January 26, 20170

Selinux stands for Secutiry-Enahanced Linux (https://en.wikipedia.org/wiki/Security-Enhanced_Linux). Selinux is a Linux kernel security module that provides a mechanism for supporting access control security policies. A Linux kernel integrating SELinux enforces mandatory access control policies that confine user programs’ and system servers’ access to files and network resources. Some times for testing…

Setup MySQL using Puppet

Krishna Prajapati November 26, 2016 - 12:08 pm January 31, 20170

Webinar date: Friday, November 14, 2014 – 16:15 youtube_url: http://youtu.be/FYpZduT9s4U slideshare_url: http://www.slideshare.net/olindata/webinar-setup-mysql-with-puppet

Manage Firewall with Puppet from OlinData

Krishna Prajapati November 26, 2016 - 12:04 pm January 31, 20170

Webinar date: Tuesday, April 28, 2015 – 16:15 youtube_url: https://www.youtube.com/watch?v=9wwN3mCEu3E slideshare_url: http://www.slideshare.net/olindata/manage-firewall-with-puppet-webinar-presentation

Manage MongoDB with Puppet

Krishna Prajapati November 26, 2016 - 12:01 pm January 31, 20170

Webinar date: Tuesday, June 23, 2015 – 16:15 youtube_url: http://youtu.be/6PnhrC3Vbrw slideshare_url: http://www.slideshare.net/olindata/manage-mongo-with-puppet-webinar-presentation

Manage rsyslog with Puppet

Krishna Prajapati November 26, 2016 - 11:58 am January 31, 20170

Webinar date: Tuesday, July 7, 2015 – 16:15 youtube_url: https://www.youtube.com/watch?v=YGbIfuCavjA slideshare_url: http://www.slideshare.net/olindata/webinar-manage-rsyslog-with-puppet

Manage users, groups, packages in Windows using Puppet

Krishna Prajapati November 26, 2016 - 11:55 am January 31, 20170

Webinar date: Tuesday, September 8, 2015 – 16:15 youtube_url: https://www.youtube.com/watch?v=0beIaxuXv3Y slideshare_url: http://www.slideshare.net/olindata/manage-user-groups-packages-in-windows-using-puppet

Xampp warning netstat command not found

Krishna Prajapati November 25, 2016 - 8:41 am January 26, 20170

While installing XAMMP, i got the below warning. Although, the tool was working perfectly. [root@wace lampp]# ./lampp start Starting XAMPP for Linux 5.6.28-0… XAMPP: Starting Apache…already running. XAMPP: Starting MySQL…/opt/lampp/share/xampp/xampplib: line 22: netstat: command not found ok. XAMPP: Starting ProFTPD…/opt/lampp/share/xampp/xampplib: line 22: netstat: command not found ok. If you look…

PuppetDB

Krishna Prajapati November 23, 2016 - 3:44 pm January 26, 20170

Webinar date: Tuesday, November 24, 2015 – 16:15 youtube_url: https://youtu.be/I5DZ2BhwKo4 slideshare_url: http://www.slideshare.net/olindata/puppetdb-webinar-presentation

Building Report Server

Krishna Prajapati November 23, 2016 - 3:40 pm January 26, 20170

Although, there are many ways to setup a reporting server depending on the requirements. Sharing one of those. Reporting Server provides reports i.e. daily, weekly, monthlty and quarterly reports to the clients. Data flow from many different servers (services) to one system called as Report Server. Client might be using…

Faulty Physical Ram

Krishna Prajapati November 23, 2016 - 3:28 pm January 26, 20171

Some times it’s very difficult to find out exact issue. Specially When it’s related with hardware. Similar scenario, i faced with a client. I have been provided with a new box to setup mysql server. After setup mysql along with other application, mysql frequently goes down without any comment in…