Skip to main content
Database Administrators

Return to Answer

revised statements and casing
Source Link
edit approved Jul 22, 2014 at 15:14
Shanky
edit approved Jul 22, 2014 at 15:14
Shanky
  • 19.1k
  • 4
  • 36
  • 58

I agree with previous answer from jynusJynus. MariaDB is pretty straightforward to install and there are many howtoshow to topics to do inplace replacements of MySQL (worry notYou dont need to worry much, all the utilsutilities and commands you know are the same), for For example, from MariaDB site itself MariaDB Upgrade. You can also simulate a MariaDB/Percona/MySQL configuration with your hardware settings from Several Nines site (search for the configurator)

I advise you to do a prior reading in Galeracluster's own site forso that you tocan evaluate if those features presented are really what are you looking for. Personally I think Galera as a great "enabler" for HA on MySQL (and "derivatives") without changing significantly the way you deal with databases.

side notePlease Note:If If your going with Galera (and not NDB type cluster) consider using Percona XtraBackup instead of the proposed rsync or mysqldump for SST (state snapshot transfer)

I agree with previous answer from jynus. MariaDB is pretty straightforward to install and there are many howtos to do inplace replacements of MySQL (worry not, all the utils and commands you know are the same), for example, from MariaDB site itself MariaDB Upgrade. You can also simulate a MariaDB/Percona/MySQL configuration with your hardware settings from Several Nines site (search for the configurator)

I advise you to do a prior reading in Galeracluster's own site for you to evaluate if those features presented are really what are you looking for. Personally I think Galera as a great "enabler" for HA on MySQL (and "derivatives") without changing significantly the way you deal with databases.

side note:If your going with Galera (and not NDB type cluster) consider using Percona XtraBackup instead of the proposed rsync or mysqldump for SST (state snapshot transfer)

I agree with previous answer from Jynus. MariaDB is pretty straightforward to install and there are many how to topics to do inplace replacements of MySQL (You dont need to worry much, all the utilities and commands you know are the same) For example, from MariaDB site itself MariaDB Upgrade. You can also simulate a MariaDB/Percona/MySQL configuration with your hardware settings from Several Nines site (search for the configurator)

I advise you to do a prior reading in Galeracluster's own site so that you can evaluate if features presented are really what are you looking for. Personally I think Galera as a great "enabler" for HA on MySQL (and "derivatives") without changing significantly the way you deal with databases.

Please Note: If your going with Galera (and not NDB type cluster) consider using Percona XtraBackup instead of the proposed rsync or mysqldump for SST (state snapshot transfer)

Source Link
bigux
bigux
  • 21
  • 3

I agree with previous answer from jynus. MariaDB is pretty straightforward to install and there are many howtos to do inplace replacements of MySQL (worry not, all the utils and commands you know are the same), for example, from MariaDB site itself MariaDB Upgrade. You can also simulate a MariaDB/Percona/MySQL configuration with your hardware settings from Several Nines site (search for the configurator)

I advise you to do a prior reading in Galeracluster's own site for you to evaluate if those features presented are really what are you looking for. Personally I think Galera as a great "enabler" for HA on MySQL (and "derivatives") without changing significantly the way you deal with databases.

side note:If your going with Galera (and not NDB type cluster) consider using Percona XtraBackup instead of the proposed rsync or mysqldump for SST (state snapshot transfer)