DB users on Windows -- MariaDB or MySQL


jimbo45

Well-known member
Power User
VIP
Local time
2:16 PM
Posts
1,631
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
Hi folks
I've got a friends W2019 Server with MySQL (the free one - not Ms's SQL server) with an older (Free version) of MySQL on it. All the modern open source people seem to be going for MariaDB which has same command syntax etc . I use also MariaDB on a Linux web server with Apache and PHP. This can be done on Windows - so should I convert the DB to MariaDB or as they say "Just let sleeping dogs lie". My gut feel as an old School Engineer is that "If it Ain't Broken - Don't fix it".

However would be interesting to note of any significant differences between the two systems -- the FREE open source version of MySQL and the Mariadb system.

Anybody here running Apache web servers using either of these DB systems on W10/W11, W2091 or W2022 server.

Thanks in advance,

Cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7

z3r010

Administrator
Staff member
Local time
3:16 PM
Posts
1,966
Location
Worsley, Manchester, UK
OS
Windows 11 Workstation
I switched this site over from MySQL8 to MariaDB about a month or so back and there was a significant performance gain (W2019 server).

MairaDB is a straight drop-in replacement.
 

My Computers

System One System Two

  • OS
    Windows 11 Workstation
    Computer type
    PC/Desktop
    Manufacturer/Model
    doofenshmirtz evil incorporated
    CPU
    Ryzen 9 5950X
    Motherboard
    Asus ROG Crosshair VIII Formula
    Memory
    Corsair Vengeance RGB PRO Black 64GB (4x16GB) 3600MHz AMD Ryzen Tuned DDR4
    Graphics Card(s)
    ASUS AMD Radeon RX 6900 XT 16GB ROG Strix LC OC
    Sound Card
    Sound BlasterX Katana
    Monitor(s) Displays
    3 x27" Dell U2714H & 1 x 34" Dell
    Hard Drives
    Samsung 980 Pro 1TB M.2 2280 PCI-e 4.0 x4 NVMe Solid State
    Drive
    PSU
    ASUS ROG THOR 850W 80 Plus Platinum
    Case
    ASUS ROG Strix Helios Midi-Tower ARGB Gaming Case
    Cooling
    ASUS ROG Strix LC Performance RGB AIO CPU Liquid Cooler - 360mm
    Keyboard
    Logi Ergo
    Mouse
    Logitech MX Master 3
    Internet Speed
    900/100 Mbps
    Browser
    Chrome
    Antivirus
    Windows Defender, Malwarebytes Pro
    Other Info
    HP M281 Printer
    Logitech Brio Stream webcam
    Yeti X mic
  • Operating System
    Windows 10
    Computer type
    Laptop
    Manufacturer/Model
    Surface Laptop
    CPU
    i7

jimbo45

Well-known member
Power User
VIP
Thread Starter
Local time
2:16 PM
Posts
1,631
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
I switched this site over from MySQL8 to MariaDB about a month or so back and there was a significant performance gain (W2019 server).

MairaDB is a straight drop-in replacement.
Hi there
Thanks
I'll go for that on the Windows 2019 server.

I take it conversion is easy enough.

Cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7

z3r010

Administrator
Staff member
Local time
3:16 PM
Posts
1,966
Location
Worsley, Manchester, UK
OS
Windows 11 Workstation
I installed Maria on a different port so I could run both side by side, backed up the MySQL DB then just imported it into the Maria instance - that was it, other than point the forum software to the new port and username/password.
 

My Computers

System One System Two

  • OS
    Windows 11 Workstation
    Computer type
    PC/Desktop
    Manufacturer/Model
    doofenshmirtz evil incorporated
    CPU
    Ryzen 9 5950X
    Motherboard
    Asus ROG Crosshair VIII Formula
    Memory
    Corsair Vengeance RGB PRO Black 64GB (4x16GB) 3600MHz AMD Ryzen Tuned DDR4
    Graphics Card(s)
    ASUS AMD Radeon RX 6900 XT 16GB ROG Strix LC OC
    Sound Card
    Sound BlasterX Katana
    Monitor(s) Displays
    3 x27" Dell U2714H & 1 x 34" Dell
    Hard Drives
    Samsung 980 Pro 1TB M.2 2280 PCI-e 4.0 x4 NVMe Solid State
    Drive
    PSU
    ASUS ROG THOR 850W 80 Plus Platinum
    Case
    ASUS ROG Strix Helios Midi-Tower ARGB Gaming Case
    Cooling
    ASUS ROG Strix LC Performance RGB AIO CPU Liquid Cooler - 360mm
    Keyboard
    Logi Ergo
    Mouse
    Logitech MX Master 3
    Internet Speed
    900/100 Mbps
    Browser
    Chrome
    Antivirus
    Windows Defender, Malwarebytes Pro
    Other Info
    HP M281 Printer
    Logitech Brio Stream webcam
    Yeti X mic
  • Operating System
    Windows 10
    Computer type
    Laptop
    Manufacturer/Model
    Surface Laptop
    CPU
    i7

jimbo45

Well-known member
Power User
VIP
Thread Starter
Local time
2:16 PM
Posts
1,631
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
I installed Maria on a different port so I could run both side by side, backed up the MySQL DB then just imported it into the Maria instance - that was it, other than point the forum software to the new port and username/password.
Worked fine for me too -- thanks -- much appreciated
Cheers
jimbo
 
Last edited:

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
Top Bottom