How To Create A Second Database Schema In The Same RDS Instance On Amazon RDS

If you want to create another user with master user and that will create another database schema in running RDS instance . So you may follow the below steps. connect your RDS instance through master password and user ( which is create on RDS creation time) from Bash shell.

# mysql -h <....rds.amazonaws.com> -u linuxpoint -p

now in RDS instance (mysql) shell prompt.

Note: User: awspoint  and DatabaseName: linux_point –  replace this both with your database name and user name and remove “<>” this. 

mysql> CREATE USER '<awspoint>'@'%' IDENTIFIED BY '<password>';
mysql> CREATE DATABASE <linux_point>;
mysql> GRANT ALL PRIVILEGES on <linux_point>.* To <awspoint>@'%';
mysql> GRANT ALL PRIVILEGES ON `<linux_point>`.* TO '<awspoint>'@'%';
mysql> FLUSH PRIVILEGES;

Now you may see your newly created database mysql> SHOW databases;

Now you have to exit this, mysql> \q;

And now you be able to login with new user with new_database

# mysql -h <....rds.amazonaws.com> -u <awspoint> --database <linux_point> -p
mysql>_

And now you be able to restore the dump (from bash shell) in your newly database or you can create tables and all whatever you want with it which will be valid as per requirements.

# mysql -h <....rds.amazonaws.com> -u <awspoint> --database <linux_point> -p < dump.sql
@Thank you

SaveSave

Advertisements

How to Install NGINX   Stable Version v1.12.2  on RHEL 7 For Production Environment

NGINX

NGINX is open source software for web serving, reverse proxying, caching, load balancing, media streaming, and more. It started out as a web server designed for maximum performance and stability. In addition to its HTTP server capabilities, 

NGINX can also function as a proxy server for email (IMAP, POP3, and SMTP) and a reverse proxy and load balancer for HTTP, TCP, and UDP servers.

NGINX can be used as an HTTP/HTTPS server, reverse proxy server, mail proxy server, load balancer, TLS terminator, or caching server. It is quite modular by design. It has native modules and third-party modules created by the community. Written in the C programming language, it’s a very fast and lightweight piece of software.


OnePlus 5T (Midnight Black 6GB RAM + 64GB memory) INR 32,999.00
Continue reading

How to Monitor Docker with Python & DoMonit in Devops

Docker is a powerful tool, however learning how to use it the right way could take a long time especially with the rapidly growing ecosystem of containers which could be confusing, that is why I had the idea to start writing Painless Docker


Amazon Pay balance: Money

Through this book, the reader will learn and master Docker and a great part of its ecosystem and among other things, the reader will learn how to create his own Docker monitoring system, that’s why I created DoMonit as a poc for this part of the book.

The purpose of this post is to introduce DoMonit: an API wrapper for Docker built to simplify monitoring specific Docker metrics using Python.

Monitoring gives you a visibility about your infrastructure. Running production without monitoring is not recommended at all.
The same thing is applied to running Docker in production: Monitoring is needed especially if you have a lot of critical applications running containers.

Running Linux systems in production for more than 10 years, I deployed and tested many infrastructure and production monitoring systems.

Continue reading

HOW TO SETUP A SECURE ELASTICSEACH 5.5.1 SEVER WITH X-PACK- Amazon EC2

ELASTICSEACH 5.5.1 SEVER WITH X-PACK

From last article and another one, we can understand what is Elasticseach  and how to install, how to make Dockerfile and Elasticsearch configuration. In this post we will go through to setup Elasticsearch 5.5.1 server, with X-PACK to secure your Elasticsearch Server.

Assume that you have AWS EC2 Instance with Ubuntu 16.04 LTS or on your Local Environment.


Nike Boy’s Free 5.0 (Gs) Game Royal, Black and Neon Turquoise Sports Shoes – 4 UK/India (36.5EU)(4.5Y US) INR 4,555.00

Elasticsearch Installation

With Aws EC2 instance that have an Ubuntu 16.04 base image.  We need to set up the JAVA environment (JAVA SDK): OpenJDK and OpenJRE.  Next, let’s add Elastic APT repository with Ubuntu ans install elasticsearch itself. Continue reading

How to make Dockerfile for Elasticsearch | How to Install and Configure Elasticsearch with the Docker

ELASTICSEARCH 

Elasticsearch is a popular open-source search and analytics engine for use cases such as log analytics, real-time application monitoring, and click stream analytics.

Elasticsearch  is a search server based on Lucene. Elasticsearch is developed in Java and is released as open source under the terms of the Apache License. Elasticsearch is the most popular enterprise search engine followed by “Apache Solr”, also based on Lucene.

To know more please click here

So here in this article we have to learn that how to write Dockerfile for Elasticsearch v2.4.5  and build Elasticsearch’s Docker image and run a Docker Container.

For the above things we have to follow these steps and assume that you have Linux OS in your system and Docker engine are running.

  1. Make a Docker file with Ubuntu 16.04 Base image
  2. Build Image from Dockerfile
  3. Run Docker Container
  4. To configure your elasticsearch server execute the container and configure as per your requirements

Continue reading

How to Generate pem file to ssh the server without Password in Linux

ssh by pem file to Access Server

It is a standard procedure, now how to make this work without using password, using just a .pem file?

PEM

PEM or Privacy Enhanced Mail is a Base64 encoded DER certificate.  PEM certificates are frequently used for web servers as they can easily be translated into readable data using a simple text editor.  Generally when a PEM encoded file is opened in a text editor, it contains very distinct headers and footers.

PEM is a widely used encoding format for security certificates. Syntax and content is defined by X.509 v3 standards for digital certificates, defined in IETF RFC 5280 specifications. The main file extensions are .pem, .crt, .ca-bundle. Continue reading

Understand Continuous Integration And Deployment With Jenkins –Life Cycle: Before You Regret

Deployment Should be…

  • Simple
  • Stable
  • Fast
  • Reliable & one click

Books

Continuous Integration and deployment with Jenkins – Life cycle:

1.Continuous integration

Continuous integration is the process of merging development works with the branch(code) several times in a day constantly. Most of the work here is done by automated.
Continue reading

Backup Of MySQL Database To Amazon S3 Using BASH Script Is Not Rocket Science! Learn Them Now!

s3backupBackup of MySQL Database to Amazon S3 using BASH Script

This is a easy way to backup your Mysql Database  to Amazon S3 for a regular interval backup – this is all to be done on your server.

First need to have the checklist  i.e must important for the any task you want to do in a proper way.

  • S3cmd  command line configure on server
  • A bucket over S3 to store dump file
  • Make Bash Script  i.e Contains MySQL Credential ( Hostname, Username, DB Name ), Location on your server where you want to store dump (PATH), Log Path.
  • Give chmod  +x on mysqlbackup Script (mysql.sh)
  • Test it and check S3 bucket
  • Schedule with cron as per your requirement

Continue reading

All You Need To Know About Configuration Management Tools For DevOps Engineer

devops-toolsConfiguration Management Tools for DevOps

DevOps   is a combination of software development and operations — and as its name suggests, it’s a melding of these two disciplines in order to emphasize communication, collaboration, and cohesion between the traditionally separate developer and IT operations teams.

In the past, To maintaining IT infrastructure, deploying applications, and provisioning environments we have to involved in many manual efforts, iterative tasks. But in today’s DevOps platform, true automation of these tasks has arrived. The most benefits of automated configuration management range from time savings to elimination of human error.

Apple iPhone 6 (Gold, 32GB) INR 25,699.00
Continue reading

What is DevOps?

2000px-devops-svg_What is Devops?

DevOps” as a term was first coined in 2009 by Patrick Debois, who became one of its chief proponents. Simply put, DevOps is a combination of software development and operations — and as its name suggests, it’s a melding of these two disciplines in order to emphasize communication, collaboration, and cohesion between the traditionally separate developer and IT operations teams.

JBL E45BT On-Ear Wireless Headphones (Blue) INR 6,499.00

Continue reading