Tag: MariaDB

Software

MariaDB 5.5.59 now available

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.59. This is a stable (GA) release. See the release notes and changelog for details. Download MariaDB 5.5.59 Release Notes Changelog What is MariaDB 5.5? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!   Source link

Clustering

How to convert galera node to async slave and vice-versa with MariaDB Galera Cluster

Recently, I was working with one of our customer and this is what their requirement as they want to automate this process for converting galera node to async slave and make async slave to galera node without shutting down any server. ———- I’ve tested locally with my galera cluster and it’s working smoothly. But with …

Miscellaneous

Best Practices for Upgrading Amazon RDS for MySQL and Amazon RDS for MariaDB

One key feature of Amazon RDS is that you can easily upgrade a database instance to a new minor or major version of your database engine. You can perform upgrades on demand by using the AWS Management Console or AWS CLI. You can decide to automatically upgrade to a new minor engine version when it …

Clustering, Security

How to Secure Galera Cluster – 8 Tips

  As a distributed database system, Galera Cluster requires additional security measures as compared to a centralized database. Data is distributed across multiple servers or even datacenters perhaps. With significant data communication happening across nodes, there can be significant exposure if the appropriate security measures are not taken. In this blog post, we are going …

Miscellaneous

First Docker steps with MySQL and MariaDB

The Docker version of the distributions are often quite old. On Ubuntu 16.04 for example: shell> docker –version Docker version 1.13.1, build 092cba3 But the current docker version is 17.09.0-ce (2017-09-26). It seems like they have switched from the old version schema x.y.z to the new year.month.version version schema in February/March 2017. Install Docker CE …

Software

FromDual Performance Monitor for MySQL and MariaDB 0.10.6 has been released

FromDual has the pleasure to announce the release of the new version 0.10.6 of its popular Database Performance Monitor for MySQL, MariaDB, Galera Cluster and Percona Server fpmmm. You can download fpmmm from here. In the inconceivable case that you find a bug in fpmmm please report it to our Bug-tracker. Any feedback, statements and …

Clustering, Security

ClusterControl Tips & Tricks: Securing your MySQL Installation (Updated)

  Requires ClusterControl 1.2.11 or later. Applies to MySQL based clusters. During the life cycle of Database installation it is common that new user accounts are created. It is a good practice to once in a while verify that the security is up to standards. That is, there should at least not be any accounts …

Security

Ten Tips on How to Achieve MySQL and MariaDB Security

  Security of data is a top priority these days. Sometimes it’s enforced by external regulations like PCI-DSS or HIPAA, sometimes it’s because you care about your customers’ data and your reputation. There are numerous aspects of security that you need to keep in mind – network access, operating system security, grants, encryption and so …