Exabig - Page 2 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…

.my.cnf: MySQL User and Password

Krishna Prajapati May 6, 2018 - 3:54 pm August 6, 20180

This is only for test environment and lazy people. Every time we have to add MySQL username and password to log in. Using this way we can login without credentials. MySQL Username and Password After the below changes, you will be able to login without credentials. All the commands like…

ScyllaDB Monitoring

Krishna Prajapati April 18, 2018 - 3:54 pm July 14, 20180

ScyllaDB Monitoring Stack can monitor all the Scylla infrastructure easily. Scylla team has beautifully explained, all the steps to setup monitoring. It’s very straight forward and any body can configure it using the below URLs. ScyllaDB URLs http://docs.scylladb.com/operating-scylla/monitoring/monitoring_stack/ http://docs.scylladb.com/operating-scylla/monitoring/monitor_without_docker/ Troubleshooting I’m just sharing up a scenario, where i faced some…

Setup Hadoop 3.1.0 Single Node Cluster on Ubuntu 16.04

Krishna Prajapati March 20, 2018 - 3:32 pm April 18, 20193

The Apache Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage. Rather than rely on hardware…

Setup Cassandra Cluster on CentOS 7

Krishna Prajapati February 28, 2018 - 8:39 am March 6, 20180

Apache Cassandra is a free and open-source distributed NoSQL database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Cassandra offers robust support for clusters spanning multiple datacenters, with asynchronous masterless replication allowing low latency operations for…

Setup Scylla Cluster on CentOS 7

Krishna Prajapati January 31, 2018 - 8:27 pm February 22, 20180

Scylla Is Next Generation NoSQL. Power your mission-critical applications with the best traits of Apache Cassandra at 10x the performance and low tail-latency at all times. Prequisite CentOS 7.2 or later, for the 64-bit x86_64 architecture. ABRT conflict with Scylla coredump configuration. Remove it before installing Scylla: sudo yum remove…

OrientDB DEMODB Database Queries

Krishna Prajapati December 14, 2017 - 2:17 pm November 30, 20180

Connect to OrientDB console krishna@ubuntu:/opt/orientdb/bin$ ./console.sh OrientDB console v.3.0.0m2 (build 31b455cec3cc97d11be0748e31ed1a03ff6a23ac) https://www.orientdb.com Type ‘help’ to display all the supported commands. orientdb> orientdb> Connect to localhost orientdb> CONNECT remote:localhost root admin Disconnecting from the database [null]…OK Connecting to remote Server instance [remote:localhost] with user ‘root’…OK orientdb {server=remote:localhost/}> Connect to localhost with…

Setup OrientDB 3.0.0.m2 on Ubuntu 16.04

Krishna Prajapati December 12, 2017 - 7:32 pm December 14, 20171

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…

Setup OrientDB on CentOS 7

Krishna Prajapati November 29, 2017 - 8:04 am December 8, 20170

Install Neo4j on Ubuntu 16.04

Krishna Prajapati October 6, 2017 - 10:23 pm October 6, 20170

Neo4j is an extremely popular graph database. Rather than having foreign keys and select statements, you use edges and graph traversals to query the data. This method of querying data is extremely powerful in many cases such as social networks. Prerequisite Install java 8 as perquisite for Neo4j. Add Oracle Java…

Install Scylla on Ubuntu 16.04

Krishna Prajapati September 22, 2017 - 5:46 pm September 22, 20170

Scylla Is Next Generation NoSQL. Power your mission-critical applications with the best traits of Apache Cassandra at 10x the performance and low tail-latency at all times. Add Repo Add the Scylla APT repository to your system. $ sudo wget -O /etc/apt/sources.list.d/scylla.list http://repositories.scylladb.com/scylla/repo/63074dd55d7ebbd35bedc10c3d4ad5af/ubuntu/scylladb-1.7-xenial.list Install Use the below command to install Scylla.…

Setup Cassandra Single Node Cluster on Ubuntu 16.04

Krishna Prajapati September 21, 2017 - 4:37 pm September 21, 20170

Setup Keycloak with SSL and MySQL backend

Krishna Prajapati September 18, 2017 - 11:20 am September 18, 20172

Keycloak is an open source identity and access management solution. Open Source Identity and Access Management For Modern Applications and Services. By default Keycloak uses an embedded H2 database. This should be sufficient for development on the local machine, but for production we will replace it with a MySQL standalone…

MongoDB Backup and Restore

Krishna Prajapati August 12, 2017 - 11:23 am August 15, 20170

MongoDB is one of the most popular NoSQL database engines. MongoDB is a free and open-source cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with schemas. MongoDB is a distributed database at its core, so high availability, horizontal scaling, and geographic distribution are built in and easy…

Puppet Hiera Configuration

Krishna Prajapati July 20, 2017 - 7:37 am July 20, 20170

Setup Puppet Server 5 on Ubuntu 16.04

Krishna Prajapati July 13, 2017 - 1:00 am July 16, 20170

Transfer git repository from one provider to another

Krishna Prajapati June 25, 2017 - 8:47 am September 23, 20170

Organisations/People move their infrastructure (git repositories) from one provider to another. Here’s a site to compare the tools, Each tools have their own merits and demerits, it’s the organisations/individuals who select the tools based on their requirements. Let’s Started It’s very simple, in order to transfer/move repositories. You have to…