MariaDB Data encryption at Rest
MariaDB Data at Rest Encryption Having tables encrypted makes it almost impossible for someone to access or steal a hard disk and get access to the original data. This assumes that encryption keys are stored on another system. Using encryption…
Enabling https for MONyog
We can access Monyog using https by configuring Nginx and access Monyog behind Nginx. Please refer our FAQ for the steps to configure here. rm -rf /root/sslcert cd /root mkdir sslcert chmod 0700 sslcert cd sslcert mkdir certs private echo…
Working with Galera Cluster on MariaDB using RHSC
Starting (or bootstrapping) a Galera Cluster using MariaDB from RHSC (RedHat Software Collection) CANNOT be done with –wsrep-new-cluster option at service start up on RHEL6, e.g. commonly known as: # service mysql start –wsrep-new-cluster <=== This DOES NOT work!!! RHEL…
MariaDB RHSC installation
To stick with current version of MariaDB to ensure receiving the latest features and security patches. Use the following steps to install MariaDB re-distributed by Redhead Software Collection (RHSC) on RHEL 6.x: [root@dbverstyhost ~]# cd /net/e12-dma-04/nas/mariadb/support_files [root@dbverstyhost support_files]# ls -l…
MariaDB – Bulk Inserts using Store Procudere
MariaDB [partition_db]> DROP TABLE IF EXISTS mytable; Query OK, 0 rows affected, 1 warning (0.00 sec) MariaDB [partition_db]> CREATE TABLE mytable (id int(10), pin int(10), dt datetime) PARTITION BY HASH ( SECOND(dt) ); Query OK, 0 rows affected (0.03 sec)…
MySQL/MariaDB vs MongoDB Privileges Comparision
privileges_comparision_mysql_or_mariadb_vs_mongodb
MariaDB “JDBC/Connector J” Connection with SSL enabled.
[root@dbversity-com rh-mariadb101]# cat /etc/opt/rh/rh-mariadb101/my.cnf # This group is read both both by the client and the server # use it for options that affect everything [client-server] #################### <– Client-Server SSL Options–> ####################################### ssl ssl-cipher = AES128+EECDH:AES128+EDH ssl-ca = /etc/opt/rh/rh-mariadb101/pki/ca.pem ssl-cert…
MariaDB ODBC Driver (Connector/ODBC) testing
root@dbversity-com ]# ll -lhtr -rw-r–r– 1 698K Oct 4 06:42 mariadb-connector-odbc-2.0.12-ga-linux-x86_64.tar.gz [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# tar -zxvf mariadb-connector-odbc-2.0.12-ga-linux-x86_64.tar.gz mariadb-connector-odbc-2.0.12-ga-linux-x86_64/lib64/libmaodbc.so mariadb-connector-odbc-2.0.12-ga-linux-x86_64/share/doc/mariadb_connector_odbc/COPYING mariadb-connector-odbc-2.0.12-ga-linux-x86_64/share/doc/mariadb_connector_odbc/README [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# ll -lhrt -rw-r–r– 1 698K Oct 4…
Configuring MariaDB With PAM/Kerberos
Please note below directions assume the system is already setup to use AD for user logins. What is here will enable a MariaDB to leverage a system’s current setup. It will not deploy AD from scratch. As of MariaDB 5.0,…