InnoDB ReplicaSet, that enables you to administer a set of MySQL instances running asynchronous GTID-based replication. MySQL Replica Set is a set of three components: MySQL Shell MySQL Router Set …
Read More »
We should consider installing ProxySQL on client nodes for efficient workload management across the cluster without any changes to the applications that generate queries. This is the recommended high-availability solution for …
Read More »
Welcome to another blog. This time I am here to show you guys how to setup percona XtraDB cluster. Ok, so what is percona XtraDB? XtraDB is a MySQL clustering …
Read More »
Today in this article we will get an idea about how to monitor MySQL replication. It is today’s requirement to setup replication in your environment but is it enough? My …
Read More »
Replication is used to keep two or more databases synchronized by replicating either executed DML/statement or data set changes from a master server to one or multiple slave servers. There …
Read More »GOLDENGATE Oracle to Hdfs ############# Project Information ############### #target pbigdata001 10.34.81.67 bigdata /bigdata_disk/gg/ ########################################################## GGSCI (knebdp01.ceofg.local) 4> view param EXTBD01 EXTRACT EXTBD01 --REGISTER EXTRACT EXTBD01 DATABASE --ADD EXTRACT EXTBD01,INTEGRATED TRANLOG, …
Read More »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial