The intention of this post is helping you with your go-live production deadline configuring huge pages for MySQL using Red Hat Enterprise Linux / CentOS.…
View More Configuring Huge Pages for MySQL Server on Red Hat Linux
Category: MySQL
How to get Connected Two Virtual Machines In VirtualBox
If you ever need to run multiple OSes simultaneously, a virtual machine (VM) is one of your best options. It’s cost-effective, provides relatively good performance,…
View More How to get Connected Two Virtual Machines In VirtualBox
How to Generate a Running(Accumulated) Total in SQL
Have you ever needed to calculate a “running total” or “cumulative sum” in SQL? You can do this in SQL without any other programming language…
View More How to Generate a Running(Accumulated) Total in SQL
Upgrade from Amazon Aurora Serverless v1 to v2 with minimal downtime
When Amazon Aurora Serverless v1 came out, it was one of the most exciting new features of 2018. The ability to have a relational database without having…
View More Upgrade from Amazon Aurora Serverless v1 to v2 with minimal downtime
Run multiple instances of MySQL Server on Windows 10
You can download it from here. Now, run the MySQL community installer. In MySQL Installed, you can view the list of installed products. To add…
View More Run multiple instances of MySQL Server on Windows 10
MySQL InnoDB Cluster 8.0 setup
MySQL InnoDB Cluster has proven with the first GA release its potential as the native out-of-the-box HA solution for MySQL. With the second GA release,…
View More MySQL InnoDB Cluster 8.0 setup
MySQL Master/Slave Replication in Windows
This guide will walk you through creating MySQL replication on existing live MySQL servers on Windows. While some downtime is required, we try to keep…
View More MySQL Master/Slave Replication in Windows
DBA Interview Questions
1-Explain the security practices such as LDAP SSL SSO and certificate management LDAP: Lightweight Directory Access Protocol–LDAP is a tool for extracting and editing data…
View More DBA Interview Questions
MySQL login root without password in Linux
to add more users just add more user and password in ~/.my.cnf
View More MySQL login root without password in Linux
Install MySQL Docker
I assume Docker already installed and running. Pull mysql container You can specify version (5.7). If version is not given it will download latest version.…
View More Install MySQL Docker