Clota Blog

Category: MySQL L1

  • Read a big file using PowerShell

    # Command-Format: Get-Content ‘your-file-path’ -Tail <number-of-line>Get-Content ‘.\mylargefile.txt’ -Tail 5000 # Get-Content D:\MyBigFeedFile.txt | Select-Object -skip 123798766555672 -first 6

    Read More

    Abhishek Yadav

    //

  • Win OS Related Quick Commands

     Find Who Restarted Windows Server –Run the following command to filter the System Logs with Source as User32. Get-EventLog -LogName System | Where Source -eq User32 –You may also filter the system logs with Event ID 1074 with the following command. Get-EventLog -LogName System | Where EventID -eq 1074

    Read More

    Abhishek Yadav

    //

  • My SQL Innodb Cluster Setup

    Server List clota-dbl05  @@version 8.0.32-commercial 192.168.0.156 My SQL root password Secure@123 ——————————————————————- ota-dbl06 <cota-dbl06> @@version 8.0.33 192.168.0.197 My SQL root password Secure@123 ——————————————————————- clota-dbl07 192.168.0.195 @@version @@version 8.0.33 My SQL root password Secure@321 ——————————————————————- Step 1: Modify /etc/hosts with IP and server_name  on all the nodes… Like below  vim /etc/hosts 192.168.0.156   clota-dbl05 192.168.0.197      ota-dbl06 192.168.0.195   clota-dbl07…

    Read More

    Abhishek Yadav

    //

  • Install MySQL 8 on Oracle Linux

    Installing MySQL on Oracle Linux is simple and straightforward. Download the latest version of MySQL based on your OS version. Download via Command Line (optional): Use wget or curl to download the file directly if you prefer using the command line wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz Change to the directory where you downloaded the tarfile: cd  /test Extract…

    Read More

    Tarif Ahmad

    //

  • Mysql Replication

    MySQL database servers (slave)- I/O thread and SQL Thread- Replication I/O threads-  When a start slave statement is issued on a replica server, the replica creates an I/O thread, which connects to the source and asks it to send the updates recorded in its binary logs. The replication I/O thread reads the updates that the…

    Read More

    Tarif Ahmad

    //

Search

Categories

Recent Posts