DatabasesHow to Backup SAP HANA Database using Command LineBy RahulJanuary 7, 2014SAP HANA is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud. It is…
PostgreSQL20 Useful Tips for PostgreSQL BeginnersBy RahulDecember 30, 2013PostgreSQL is an advanced database management system used for storing structured or non-structured data. It supports both SQL (relational) and…
MySQLHow to Install MySQL 5.7 on CentOS 7 & Fedora 36/35By RahulOctober 14, 2013MySQL community has released MySQL 5.7 Release. Its available on MySQL official website. For this article We are using CentOS…
MySQLHow to Reset ( Re-Sync ) MySQL Master-Slave ReplicationBy RahulSeptember 12, 2013Some times MySQL replication creates problems and slave could not sync properly from the master database server. It may cause…
MariaDBHow to Allow Remote MySQL ConnectionsBy RahulAugust 20, 2013Managing a MySQL database doesn’t always mean accessing it from the same server where it’s hosted. In many situations, especially…
MySQLHow to Backup and Restore MySQL Stored Procedures & TriggersBy RahulJuly 28, 2013The database is the most crucial part of any application, and as a developer, ensuring the safety of your database…
DatabasesHow to Install Apache CouchDB on CentOS/RHEL 7/6By RahulJuly 23, 2013CouchDB is an open source project and NoSQL, document oriented database server. It stored data with JSON documents. It also…
MariaDBHow to Set Up MySQL Master-Master ReplicationBy RahulJuly 23, 2013MySQL Master-Slave replication is to set up slave server to update immediately as soon as changes done in Master server.…
MySQLShell Script to Backup MySQL DatabaseBy RahulJuly 20, 2013In this tutorial, you will find a simple bash script for backing up a MySQL database. The script takes a…
MariaDBHow to Set Up MySQL Master-Slave ReplicationBy RahulJuly 20, 2013MySQL replication is a process where a master server replicates its data to one or more slave servers. This can…