Monitoring Master-Slave Replication in MySQL 8

Monitoring Master-Slave Replication in MySQL 8

MySQL 8 introduced a number of enhancements to improve both replication performance and the monitoring thereof. Improvements included more efficient replication of small updates on big JSON documents, the addition of Performance Schema tables for slave performance...

Monitoring Master-Slave Replication in MySQL 8

Understanding Script Block Logging (Part 1)

Beginning with PowerShell 5, the PowerShell engine starts to log executed commands and scripts. By default, only commands considered potentially harmful are logged. When you enable verbose logging, though, all executed code from all users on a given machine are...

Monitoring Master-Slave Replication in MySQL 8

Reading Event Logs Smart (Part 1)

When you query an event log with PowerShell, by default you get back a text message with the logged information. For example, if you’d like to know who logged on to your machine, you could use code like this (Administrator privileges required): Get-EventLog -LogName...

Setting up Basic Master-Slave Replication in MySQL 8

Setting up Basic Master-Slave Replication in MySQL 8

Since April 19th, when MySQL 8.0 became Generally Available (GA), the MySQL community has been abuzz with excitement over all of the new features and improvements. Many of new features were improvements to performance or monitoring, while others were specifically...

Monitoring Master-Slave Replication in MySQL 8

Turning Display Off Immediately

If you are about to launch a lengthy automation script, why not turn off the display right away instead of waiting for the screen saver timeout to kick in? Turns off your Display Immediate Here is a simple function that turns off your display immediately. Just move...

SHA Hash with C++Builder and Delphi

SHA Hash with C++Builder and Delphi

Fascination with Cryptographic Hash Functions I've always been fascinated by encryption & compression, but my favorite is probably the cryptographic hash function. A hash function is a one-way algorithm that takes an input of any size and always produces the same...

Monitoring Master-Slave Replication in MySQL 8

Improve MariaDB Performance using Query Profiling

Query profiling is a useful technique for analyzing the overall performance of a database. Considering that a single mid-to-large sized application can execute numerous queries each and every second, query profiling is an important part of database tuning, both as a...

Monitoring Master-Slave Replication in MySQL 8

Error Logging in MySQL 8

Although only available as a Release Candidate, MySQL 8 is already proving itself to be a huge leap forward in many regards. Error logging is no exception. The MySQL development team just announced that they have redesigned the error logging subsystem to use a new...

Monitoring Master-Slave Replication in MySQL 8

Purging Kerberos Tickets for All Accounts

In the previous tip we covered klist.exe and how it can be used to purge all Kerberos tickets for the current user so that new permissions will take effect immediately. Combining PowerShell with klist.exe for More Flexibility While PowerShell can run external apps...

Monitoring Master-Slave Replication in MySQL 8

Purging Kerberos Tickets for the Current User

No need to reboot a system just to apply new permission settings. Instead, purge your Kerberos tickets so that you will get a new ticket based on the current permissions. PowerShell Command to Purge Kerberos Tickets In PowerShell, use this command to purge all cached...

Monitoring Master-Slave Replication in MySQL 8

Using Chocolatey with PowerShell

Chocolatey is a free package manager for Windows that can be used to download and install software. Installing Chocolatey via PowerShell Before you can use Chocolatey from PowerShell, you need to download and install it. If you don’t have administrator privileges, use...

Monitoring Master-Slave Replication in MySQL 8

Virtual Machine Snapshots versus Database Backups

Virtual Machine Snapshots Virtual machines provide exciting possibilities concerning backup, recovery, and cloning of databases. Convenient mechanisms are available for obtaining consistent snapshots of data volumes in virtual machines. Correctly implemented and...

Monitoring Master-Slave Replication in MySQL 8

Positioning the PowerShell Console Cursor

Enabling VT Escape Sequences in PowerShell 5.1 Starting in PowerShell 5.1, the PowerShell console supports VT escape sequences that can be used to position and format console text. Note that this works in the console only, not the PowerShell ISE. Note also that you...

Monitoring Master-Slave Replication in MySQL 8

Sort IPv4 and IPv6 Addresses Correctly

When you try and sort IPv4 addresses via Sort-Object, this fails: PS> '10.1.2.3', '2.3.4.5', '1.2.3.4' | Sort-Object 1.2.3.4 10.1.2.3 2.3.4.5 Alphanumeric Sorting by Default This is no surprise because the data is of type “string”, so Sort-Object uses alphanumeric...

The RDBMS is Dead

The RDBMS is Dead

If you suspected the title of this blog is click-bait, then you would be correct.  But bear with me anyway on a little retrospection of the relational database market, where it has been, and where I think it is going to end. What is an RDBMS? Anyone reading this...

Monitoring Master-Slave Replication in MySQL 8

Sort IPv4 Addresses Correctly

Reviewing the Test-OnlineFast Function In the previous tip we published a super-fast function called Test-OnlineFast, and this function was able to ping an entire IP segment in record time: PS> $iprange = 1..200 | ForEach-Object { "192.168.189.$_" } PS>...

Final Super-Fast Ping Command

Final Super-Fast Ping Command

Revisiting the Test-Online Fast Function In the previous tip series, we developed a new function called Test-OnlineFast that can ping multiple computers in record time. For some reason, the final version of this function did not include the pipeline support we...

1 7 8 9 10 11 16