Database Solutions

Installing and Configuring InnoDB Cluster  Now a days HA(High Availability) and DR(Disaster Recovery) Solutions are mandatory and required for mission critical databases. In  MySQL  world , HA solution are provided using the InnoDB or NDB Clustering Solution.  In this blog , We will discuss about the Installation and Configuration of the I nnoDB Cluster . Installation Standards and Prerequisites Before installing a production deployment of InnoDB cluster, ensure that the server instances you intend to use meet the following requirements. InnoDB cluster uses Group Replication and therefore your server instances must meet the same requirements. AdminAPI provides the dba.checkInstanceConfiguration() method to verify that an instance meets the Group Replication requirements, and the dba.configureLocalInstance() method to configure an instance to meet the requirements Group Replication members can contain tables using a storage engine other than Innodb, for example MyIS...

Install MySQL 8.0 on ubuntu Server  MySQL is an open-source relational database that is free and widely used.In this blog , We will show how to install and Secure MySQL Installation . Follow below steps to install MySQL on ubuntu Server: 1)Adding the MySQL Software Repository The MySQL developers provide a .deb package that handles configuring and installing the official MySQL software repositories. Once the repositories are set up, we’ll be able to use Ubuntu’s standard apt command to install the software. We’ll download this .deb file with curl and then install it with the dpkg command.   First, load the MySQL download page(https://dev.mysql.com/downloads/repo/apt/) in your web browser. Find the Download button in the lower-right corner and click through to the next page. This page will prompt you to log in or sign up for an Oracle web account. We can skip that and instead look for the link that says No thanks, just start my download. Right-click the link and se...

Oracle Database 19C Installation on Windows Server 2016 In Database world, Its important to be on the latest version of the database flavor. Though Oracle have release 21c Database as well but by far Oracle 19C is most stable version.( You also check our similar blog for  Installation of Microsoft SQL Server 2016 ) Please do also check out blog for  Oracle 19c New Features to know about Oracle 19c features.  In this blog, We will be installing Oracle 19C DB on Windows Server. 1) Create required directory for Oracle Home and Oracle Base. Oracle Base: E:\app\oracle Oracle Home: E:\app\oracle\db\19.0.0\dbhome_1 2) Move the binary to E:\app\oracle\product\19.0.0 directory and unzip 3) Check unzipped directory. 4)Right Click on setup and  Run Setup as Administrator: 5)   On Configuration Screen, Select Set up software only 6)   On Database Installation Option page, Select Single instance Database installation for stand alone database server. 7)  O...