Krishnakrishnaporje.hashnode.dev·21 hours agoMySQL DB Replication On CentOS & RHELPrerequisites: Ensure both master and slave servers have the same version of MySQL installed. Allocate disk space on both servers at least three times the size of the database. Ensure that the same configuration files (my.cnf) are present on both the...Discuss·1 likedb replication
Shiv IyerProshiviyer.hashnode.dev·Jan 20, 2024Mastering MySQL Performance: Advanced Counters and Linux Metrics with Expert ScriptsAdvanced performance counters in MySQL, coupled with Linux metrics, provide a comprehensive view necessary for effective performance troubleshooting. Incorporating advanced scripts enhances this process, allowing for more automated, detailed analysis...DiscussMySQL
Sanjana Khansanjana940904.hashnode.dev·Jan 13, 2024Understanding MySQL Data TypesMySQL supports a variety of data types that allow you to define the type of data that can be stored in each column of a table. These data types help enforce data integrity, optimize storage, and support efficient data retrieval. INTEGER There are sev...Discuss·48 readsMySQL
Cafer Karacaferkara.hashnode.dev·Jan 4, 2024MySQL Database SystemMySQL is an open-source relational database management system (RDBMS) that is widely used for building and managing databases. Here are some key features and aspects of MySQL: Open Source: MySQL is an open-source database system, which means that it...DiscussMySQL
Rad Web Hostingrwh.hashnode.dev·May 16, 2023How to Install MySQL 8 on a VPS ServerDatabase Management Systems (DBMSs) are applications designed to store and organize data in an organized fashion, usually as part of an e-commerce or data warehousing application. One such DBMS is MySQL, an open-source and highly scalable free DBMS t...Discuss·11 likesMySQLGreat post 👍 3
Carl Flornotes.carlflor.com·Feb 4, 2023Recursive queries in MySQL 8 using CTEsCommon Table Expressions (CTEs) Common Table Expressions (CTEs) are a powerful feature in SQL that allows you to define a temporary result set within the context of a single SELECT, INSERT, UPDATE, or DELETE statement. CTEs can simplify complex queri...Discuss·83 readsMySQL
Taegu Kangktg0210.hashnode.dev·Aug 25, 2022install MySQL client version 8 on amazon linux 2outline Installation of MySQL 8 client not Server on Amazon linux 2. add repo yum install https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm gpg-key download rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 insta...DiscussAmazon Linux 2