-
MySQL Storage Engines
•
Storage Engines MySQL supports a variety of table types to cater to different needs: To manage these diverse table types, MySQL uses different components known as storage engines. These engines are responsible for handling SQL operations for the tables. The storage engines include: MySQL employs a Pluggable Storage Engine architecture, which allows for the…
-
dbatools
•
DBATools is a collection PowerShell command over 700 command that can help DBA to achieve common task in a more automated manner in this section will demonstrate how to install dbatools , and how to use it deferent type of task that include 1- taking backup2- taking script of the job3-migirationand so on install…
-
Sql server database backup in details
•
What Is a Transaction Log? Transaction log is a list of records for all Microsoft SQL database changes. It is an essential component of the SQL Server database. If there is a system failure, you will be able to use the T-log to bring your database back to a consistent state before the point…
-
Sql Server how to Manage transaction logs
•
Managing transaction logs Transaction managing in simple mode : here we will test log managing in both simple mode and full mode . i have created two database one full one simple mode added table on it then i will run trsnaction but i will not commit the transaction you can see the qurey…
-
how to enable auditing in PostgreSQL
•
Tracking any changes made at the database level is crucial for holding accountable any users with access to PostgreSQL. During my experience as a database administrator, I encountered two situations where applications reported data loss. Upon investigation, we discovered that a table had been truncated. Unfortunately, we couldn’t confirm the source of the issue…
-
Health check using pgmetrics
•
One of the key tasks for any PostgreSQL DBA is conducting daily health checks to ensure the database remains healthy. Performing these checks is critical as it helps identify potential issues and resolve them before they impact production. PostgreSQL provides several views to monitor various metrics such as wait states, CPU usage, I/O, and…
-
PostgreSql logical replication
•
logical replication deterrent than stream replication , where the master will send wall log , there we send the actual command such (insert into t1 values (1,”’value” )) physical replication in physical replication , the replica is force to copy the whole database schema tables and so on from master server .physical replication in…
-
PostgreSql how to sperate data directory for data dir
•
When installing PostgreSQL, it defaults to creating its data directory in /var/lib/postgresql. For better performance, reliability, and management, it is often recommended to relocate the PostgreSQL data directory to a dedicated disk or separate mount point. This can help with I/O performance, backup management, and isolation of database operations from the rest of the…
-
Mysql replication troublshooting
•
${toc} to achieve the best result in troubleshooting it is highly recommended to install percona toolkit it contains tool that will help resolve replication error Coordinator stopped because there were error(s) in the worker(s). when we use the command show replica status\G we found The error message you received indicates that there was a…
-
MONITORING MYSQL
•
Getting MySQL Report from pt-mysql-summary This tool will generate report what is configuration for MySQL instance , how many replica MySQL has Or if the MySQL itself is replica , how many uses are connected What are the users doing How many databases How bug us innodb buffer pool size What is the version…