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 | Sep 10, 2021 | MySQL
CDC IntroductionWhat is Maxwell ?Possible ArchitectureMySQL SettingsSample Maxwell ConfigStart Maxwell ServiceCommand lineDockerDocker using ConfigTables in Maxwell DatabasePositionsSample Json dataConclusion CDC Introduction Before we go over Maxwell what we need to...
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...