Open Source Database

 Taking Physical Backups for MySQL In that scenario, you have probably used mysqldump or Percona XtraBackup to accomplish the task – the mysqldump client is a backup app written by Igor Romanenko, it is mostly used to dump a database or a set of databases for backup procedures or transferring into another database server. Percona XtraBackup on the other hand is based on InnoDB’s crash-recovery functionality. Physical Backups:- As already mentioned above, physical backups backup data at a system level. In general, physical backups can be taken by following these steps: Shut down the MySQL server – make sure to perform a clean shutdown (also known as a slow shutdown) – such a shutdown operation performs additional InnoDB flushing operations before completing. Simply specify the parameter innodb_fast_shutdown=0 in your my.cnf file or run the query SET GLOBAL innodb_fast_shutdown=0; – the value of innodb_fast_shutdown determines whether the backup operation is slow or fast: 0 performs ...

 How To installation and configuration mongodb in centos 8.5 Step.1.  First We need to add repo   vi /etc/yum.repos.d/mongodb-org-7.0.repo [mongodb-org-7.0] name=MongoDB Repository baseurl=https://repo.mongodb.org/yum/redhat/8/mongodb-org/7.0/x86_64/ gpgcheck=1 enabled=1 gpgkey=https://pgp.mongodb.com/server-7.0.asc step.2. Run given below command:-  yum install -y mongodb-org step.3.Install selinux policey  yum install git make checkpolicy policycoreutils selinux-policy-devel step.4 Finally we have install mongodb successfully and going to restart mongodb service and also enable service. step.5.Finally login to mongodb using below command:- [root@MYSQL-IDC-03 ~]# mongosh

Percona Toolkit:How to alter 1TB data table using Percona Toolkit  In mysql 8.0.37 pt-online-schema-change alters a table’s structure without blocking reads or writes. Specify the database and table in the DSN. Do not use this tool before reading its documentation and checking your backups carefully. Step.1.We need required install and configure  Percona Toolkit. step.2.If you have install sucessfully  Percona Toolkit than pls run   pt-summary command on terminal. step.3.After that we are going to login mysql and create table and insert record. Note:-If you create table without primary key than you can't alter table. suppose that i am creating table without primary key than generate error llok like this step.4.Now we are going to again login mysql and add primary key. step.5.Now finally we are going to run command on terminal. pt-online-schema-change --user='username'--password='password' --execute  --alter "add column emp_salary INT" D=pankaj,t=emp step.5...

 How To Install and configure Percona Server 8.0.36 for MySQL on centos 8.5.2. Step.1 Go to Percona Server official website and download rpm package. https://www.percona.com/downloads step.2.We have download successfully rpm package and untar file rpm package. tar -xvf  Percona-Server-8.0.36-28-r47601f19-el8-x86_64-bundle.tar step.3.Install rpm package  and also check rpm list rpm -ivh percona-server-client-8.0.36-28.1.el8.x86_64.rpm percona-server-server-8.0.36-28.1.el8.x86_64.rpm percona-server-shared-8.0.36-28.1.el8.x86_64.rpm percona-server-shared-compat-8.0.36-28.1.el8.x86_64.rpm percona-icu-data-files-8.0.36-28.1.el8.x86_64.rpm step.4. checked mysql service status and start mysql service. step.5.Grep temporary password and run mysql_secure_installation command. step.6.Now we have successfully install and reset root user password. step.7.check version.

Mysql Commercial Mysqlbackup:How to take Differential or Incremental Backup and resotre using mysqlbackup utility in mysql 8.0.37 enterprise edition Incremental vs Differential Backup:- The main difference between incremental and differential backups is how they save space and time by storing only changed files. However, the effectiveness of incremental backups is very different from differential backups. Before we dive into the differences between Incremental and Differential backups let’s review Full Backups.  Are you still using Full Backups? In its simplest form, a full backup is the starting point for both Incremental and Differential backup strategies. A full backup, of course, backs up all the data on a partition or disk by copying all disk sectors with data to the backup image file.  A full backup is time-consuming and requires a lot of space, it’s usually used as part of a backup plan with long intervals, like once a week or a month. During this time, if anything goes...

 Percona-XtraBackup:How To Install And Configuration Percona-XtraBackup /Restore And Taking backup for mysql Instance 8.0.0. Percona XtraBackup: A free, open-source tool that creates physical backups of InnoDB, XtraDB, and MyISAM tables. It supports incremental backups, compression, and encryption. XtraBackup is an open-source hot backup utility for MySQL-based database provided by percona. According their official documents, XtraBackup is the world's only open-source, free MySQL hot backup software that perform non-blocking backups for InnoDB and XtraDB database. Step.1.We are going to percona website and download rpm package for mysql 8.0.0. https://www.percona.com/downloads Note:-Suppose that if you are using mysql 5.7 than so pls use percona Xtrabackup 2.x.x and you are using mysql 8.x.x than pls using percona Xtrabackup 8.x.x. Step.2.Now we are finally download the percona Xtrabackup  tar file. step.3.Now we are going to percona Xtrabackup untar file, Given below command:...