vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Thinking about switching to MariaDB (https://vborg.vbsupport.ru/showthread.php?t=318194)

thetechgenius 04-10-2015 01:16 PM

Thinking about switching to MariaDB
 
I am really thinking about switching to MariaDB. I have been doing research about MariaDB for the past 10 days or so, and it seems like a really big step forward.

But I have a question, does anyone know how to switch from MySQL 5.6 to MariaDB without loosing any MySQL databases?

My servers are running Windows Server 2008R2.

MentaL 05-03-2015 06:40 PM

I'll reply here since google throws this one up first. It's fairly easy transition from MYSQL to MariaDB, if you have a cpanel license, update to the latest build then from WHM select switch to mariadb. It will automatically remove the old binarys and install the new mariadb files.

As per the DBs, since its a fork, nothing needs to be altered, its a 5 minute automated job. Although, its always handy to have a backup.

thetechgenius 05-07-2015 11:41 PM

Quote:

Originally Posted by MentaL (Post 2544778)
I'll reply here since google throws this one up first. It's fairly easy transition from MYSQL to MariaDB, if you have a cpanel license, update to the latest build then from WHM select switch to mariadb. It will automatically remove the old binarys and install the new mariadb files.

As per the DBs, since its a fork, nothing needs to be altered, its a 5 minute automated job. Although, its always handy to have a backup.

I don't have cPanel installed since my servers are running Windows Server 2008R2, but I have been reading and it seems easy. Like you said, its a 5 minute automated job, and it does everything for you. And yeah, I always backup before any major change to my servers. I also have my servers setup with Auto backups, it backs up my entire server OS and all the files to one of my backup storage servers that is not connected to the net, only to the local network. So if there is a problem I can always restore the latest working backup, Its set to keep backups for 7 days, and Database Backups for 14 Days.


All times are GMT. The time now is 08:02 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01005 seconds
  • Memory Usage 1,712KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete