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

ScyllaDB Monitoring

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…

Continue reading

Setup Cassandra Cluster on CentOS 7

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…

Continue reading

Setup Scylla Cluster on CentOS 7

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…

Continue reading

OrientDB DEMODB Database Queries

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…

Continue reading

Setup OrientDB on CentOS 7

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

Install Scylla on Ubuntu 16.04

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

Continue reading