MySQL Auto Failover using Keepalived
Install Terraform on CentOS 7
Puppet Bolt
Puppet Hiera 5 Setup
Setup Puppet Server 6 on CentOS 7
Flyway: Database Versioning
JDBC & MySQL: WARN: Establishing SSL connection without server’s identity verification is not recommended.
Create Python Environment for development
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…
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…
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…
Puppet Hiera 5 Setup
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…
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…
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…
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…
Install pip3 on Ubuntu 18.04 LTS
Ubuntu 18.04 LTS comes with default Python3. In order to install pip3 use the below command. apt-get install python3-pip The above command update the python3 to the latest version, along with many dependencies and build essential tool too. # python3 –version Python 3.6.5 # apt-get install python3-pip # python3 –version…
Install OrientDB 3.0.11 on Ubuntu 18.04 LTS
OrientDB is an open source NoSQL database management system written in Java. It is a multi-model database, supporting graph, document, key/value and object models but the relationships are managed as in graph databases with direct connections between records. It supports schema-less, schema-full and schema-mixed modes. It has a strong security…
SSL Replication
Percona Server generates SSL certificates by default. With SSL replication, we can encrypt the communication between master and slave server. Encrypted Replication On Master server add “REQUIRE SSL” to the replication user, as show below. GRANT REPLICATION SLAVE ON *.* to ‘repl_user’@’%’ IDENTIFIED BY ‘repl_pass’ REQUIRE SSL; CHANGE MASTER MASTER_SSL=1,…
MySQL SSL Connection
With an unencrypted connection between the MySQL client and the server, someone with access to the network could watch all your traffic and inspect the data being sent or received between client and server. MySQL supports encrypted connections between clients and the server. Percona server generates all the SSL certificates…
ScyllaDB Backup
Scylla is an open-source distributed NoSQL data store. It was designed to be compatible with Apache Cassandra while achieving significantly higher throughputs and lower latencies. Scylla is a fault tolerance system, even though it is recommended to regularly backup data to external storage. Backup is per node basis. Therefore take…
Setup Puppet Server 5 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…