[MariaDB]: Galera Cluster installation
You can download MariaDB Galera Linux package from the link https://downloads.mariadb.org/mariadb-galera/10.0.20/#os_group=linux_generic [ root @ maria-galera : /mariadb ] ll -lhtr total 142M -rw-r–r– 1 root root 142M Aug 11 08:18 mariadb-galera-10.0.20-linux-x86_64.tar.gz [ root @ maria-galera : /mariadb ] […
[MariaDB]: Installation from Linux tar ball
You can download mariadb package from https://downloads.mariadb.org/ and copy to your linux box [ root @ vm-16af-8253 : /mariadb ] ll -lhtr total 296M -rw-r–r– 1 sm70768 mongod 296M Aug 11 01:38 mariadb-10.0.21-linux-x86_64.tar.gz [ root @ myhostname : /mariadb ]…
[MariaDB]: MariaDB yum installation
Choose the yum repo as per your linux flavour and place as below. [root@dbversityhost yum.repos.d]# pwd /etc/yum.repos.d [root@dbversityhost yum.repos.d]# [root@dbversityhost yum.repos.d]# [root@dbversityhost yum.repos.d]# cat /proc/version Linux version 3.14.35-28.38.amzn1.x86_64 (mockbuild@gobi-build-64012) (gcc version 4.8.2 20140120 (Red Hat 4.8.2-16) (GCC) ) #1 SMP…
[MySQL]: SysBench Installation procedure
SysBench: System evaluation benchmark Why ? The idea is to quickly get an impression about system performance for MySQL usage without setting up complex benchmark and even without installing MySQL. In some cases this is very helpful. This is also the…
[MariaDB]: Installation on Amazon EC2 machine
[srinivas@dbversity.com ~]$ sudo yum install mariadb-server mariadb Loaded plugins: amazon-id, rhui-lb Package 1:mariadb-5.5.41-2.el7_0.x86_64 already installed and latest version Resolving Dependencies –> Running transaction check —> Package mariadb-server.x86_64 1:5.5.41-2.el7_0 will be installed –> Processing Dependency: perl-DBI for package: 1:mariadb-server-5.5.41-2.el7_0.x86_64 –> Processing…
SQL or NoSQL? … Both with MariaDB 10
Dynamic columns came to my attention a few days back. Since then I read a little bit more in the documentation (see Dynamic columns in the Knowledge Base) and played with it a little. The reason I became curious was…
Enabling GTIDs for server replication in MariaDB 10.0
Replication has been one of the most popular MySQL features since it made its way into the application more than a decade ago. However, as replication implementations became more complex over time, some limitations of MySQL’s original replication mechanisms started…
[MariaDB]: HA with Multi-source Replication
The Basics The topology uses 3 servers: A is the active master, B a stand-by master set up to replicate from A and C a multi purpose slave replicating from A. I also set up A to replicate from…
Installing MariaDB 10 on CentOS 7 / RHEL 7
Installing MariaDB became very easy on the latest CentOS /RHEL Linux version 7. During initial setup MariaDB has a tick in the graphical setup environment which enables MariaDB and replaces MySQL. During installation the section allows enabling a MariaDB server….
How to reset a root password in MariaDB on Linux
You’ve lost the root password for your MariaDB database – now what do you do? You can’t recover your existing password, but you can get into your database to create a new root password. You just need root privileges on…