by Santhinesh Nagendran | May 5, 2023 | General, KnowledgeBase, MySQL
What is Primary Key ?Issues due to tables without primary keyHow do we end up creating tables without primary key by mistake ?Performance issues caused by tables missing primary key ?How can we find the tables without primary key ?How can we restrict creation of...
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 genexdb | Nov 9, 2021 | Databases, General, KnowledgeBase, PostgreSQL
PostgreSQL is another most important open source database besides MySQL in RDBMS world. In this blog we have tried to cover a 3 node PostgreSQL replication setup in Centos 7. Majority of the steps would just remain the same for Ubuntu as well except for the yum based...
by genexdb | 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 | Oct 8, 2021 | General, KnowledgeBase, linux
What is cron? Today in this blog we will try to cover some of the basics of cron and cronjobs. Cron is a demon (background process) or is said to be a system executable file that runs tracks we scheduled on our system at a particular time. If the cron demon service is...
by genexdb | Jul 1, 2021 | General
Replication is the ability of any database or data streaming software that allows it to maintain multiple copies of data or the server itself. The data flows from the Source (often referred as primary or master or writer etc) node to one or more targets (often...