by Selvaraj B | Aug 22, 2022 | Databases, General, KnowledgeBase, MySQL
Concurrency is one of the key features of Innodb and an interesting feature to understand to tune database systems. As per definition the concurrency is nothing but execution of multiple instructions in a sequence at the same time, and there are some commonly known...
by mahalakshmi muthaiah | Oct 8, 2021 | General, KnowledgeBase, MySQL
Introduction ENUM is a string object with a value chosen from a list of permitted values defined at the time of column creation. ENUM values are represented as integers internally. Enum datatype is chosen whenever a column has a limited possible data values like...
by genexdb | Sep 10, 2021 | MySQL
CDC Introduction Before we go over Maxwell what we need to understand the necessity of softwares like Maxwell. CDC is labeled for change Data Capture which is mostly needed by organizations for applying data analytics/science on their data to get insights of...
by genexdb | Aug 20, 2021 | MySQL
Introduction In this blog we are going to cover some of the most frequent replication issues that might happen to any actively being used databases. If they are not addressed properly it could really take your standby slaves nodes to an inconsistent and which could...
by genexdb | Jul 5, 2018 | MySQL
Single Server Group Replication Setup Initialize three mysql instances Generate UUID for group name Prepare the config file with group replication and regular replication parameters Start Mysql for all the three instances Primary Member ( port = 24801 )...
by genexdb | Mar 12, 2018 | MySQL
What is MySQL replication ? The definition of replication cannot be stated as better as it has been stated in the mysql doc as below. Replication is a technology through which we can maintain a copy data from one source of MySQL server to one or more destination MySQL...
