DB users on Windows -- MariaDB or MySQL


jimbo45

Well-known member
Pro User
VIP
Local time
8:59 AM
Posts
5,954
Location
Hafnarfjörður IS
OS
Windows XP,11 Linux Fedora Rawhide pre-release 46
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 My Computer

At a glance

Windows XP,11 Linux Fedora Rawhide pre-releas...2 X Intel i7
OS
Windows XP,11 Linux Fedora Rawhide pre-release 46
Computer type
PC/Desktop
CPU
2 X Intel i7
Screen Resolution
4KUHD X 2
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 My Computers

  • At a glance

    Windows 11 WorkstationRyzen 9 5950XCorsair Vengeance RGB PRO Black 64GB (4x16GB)...ASUS AMD Radeon RX 6900 XT 16GB ROG Strix LC OC
    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 U2724D & 1 x 34" Dell U3415W
    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 Vertical
    Internet Speed
    1000/200 Mbps
    Browser
    Chrome
    Antivirus
    Windows Defender, Malwarebytes Pro
    Other Info
    HP M281 Printer
    Logitech Brio Stream webcam
    Logitech G Yeti orb mic
  • At a glance

    Windows 11 ProSnapdragon X2 Plus64GB
    Operating System
    Windows 11 Pro
    Computer type
    Laptop
    Manufacturer/Model
    Surface Laptop
    CPU
    Snapdragon X2 Plus
    Memory
    64GB
    Monitor(s) Displays
    15"
  • Nothing to see here.
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 My Computer

At a glance

Windows XP,11 Linux Fedora Rawhide pre-releas...2 X Intel i7
OS
Windows XP,11 Linux Fedora Rawhide pre-release 46
Computer type
PC/Desktop
CPU
2 X Intel i7
Screen Resolution
4KUHD X 2
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 My Computers

  • At a glance

    Windows 11 WorkstationRyzen 9 5950XCorsair Vengeance RGB PRO Black 64GB (4x16GB)...ASUS AMD Radeon RX 6900 XT 16GB ROG Strix LC OC
    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 U2724D & 1 x 34" Dell U3415W
    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 Vertical
    Internet Speed
    1000/200 Mbps
    Browser
    Chrome
    Antivirus
    Windows Defender, Malwarebytes Pro
    Other Info
    HP M281 Printer
    Logitech Brio Stream webcam
    Logitech G Yeti orb mic
  • At a glance

    Windows 11 ProSnapdragon X2 Plus64GB
    Operating System
    Windows 11 Pro
    Computer type
    Laptop
    Manufacturer/Model
    Surface Laptop
    CPU
    Snapdragon X2 Plus
    Memory
    64GB
    Monitor(s) Displays
    15"
  • Nothing to see here.
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 My Computer

At a glance

Windows XP,11 Linux Fedora Rawhide pre-releas...2 X Intel i7
OS
Windows XP,11 Linux Fedora Rawhide pre-release 46
Computer type
PC/Desktop
CPU
2 X Intel i7
Screen Resolution
4KUHD X 2

Latest Support Threads

Back
Top Bottom