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…

Continue reading

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…

Continue reading

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…

Continue reading

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…

Continue reading

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…

Continue reading

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,…

Continue reading

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…

Continue reading

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…

Continue reading

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…

Continue reading

Install LAMP on CentOS 7

A LAMP (Linux, Apache, MySQL, PHP) stack is free, and open-source web stack. It is used for hosting web content in a Linux environment.Many consider this as the platform of choice for high performance web apps. In this article, i will illustrate the LAMP setup process. CentOS7 Upgrade centos to…

Continue reading