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!
10 Older Entries »
MariaDB Server 5.5.59 now available dbart Fri, 01/19/2018 - 11:07[Read more]
FromDual offers short term a Percona XtraDB Cluster and MySQL Galera Cluster training (2 days) in English.
The training will take place in the Linuxhotel in Essen/Germany on February 7/8 2018.
There are already enough registrations so it is certain the training will take place. But there are still free places for some additional participants.
You can book online at the Linuxhotel.
Important: The Linuxhotel is nearly fully booked out. So accommodation is in nearby locations. The Linuxhotel will recommend you some locations.
The training is in English.
You can find the contents of this 2-day Percona XtraDB Cluster training …[Read more]
ProxySQL and pt-heartbeat
The Percona toolkit provides a very useful script for more
accurate replication lag monitoring called pt-heartbeat. The
pt-heartbeat script provides replication lag metrics based on
actual data that has been replicated and is more accurate than
Seconds_Behind_Master metrics gathered from the
SHOW SLAVE STATUS.
Seconds_Behind_Master relies purely on system time
(i.e. current time - time the event executed on the master
server). By default ProxySQL relies on the output of the
SHOW SLAVE STATUS command in order to identify
replicas that should be excluded from the backend connection pool
max_replication_lag has been configured for a
server in the
Starting from ProxySQL version 1.4.4 a new feature has been introduced in order to leverage the data provided by pt-heartbeat and …[Read more]
In this blog post, we’ll look at does the Meltdown fix affect performance for MySQL on bare metal servers.
Since the news about the Meltdown bug, there were a lot of reports on the performance hit from proposed fixes. We have looked at how the fix affects MySQL (Percona Server for MySQL) under a sysbench workload.
In this case, we used bare metal boxes with the following specifications:
- Two-socket Intel(R) Xeon(R) CPU E5-2683 v3 @ 2.00GHz (in total 56 entries in /proc/cpuinfo)
- Ubuntu 16.04
- Memory: 256GB
- Storage: Samsung SM863 1.9TB SATA SSD
- Percona Server for MySQL 5.7.20
- Kernel (vulnerable) 4.13.0-21
- Kernel (with Meltdown fix) 4.13.0-25
Please note, the current kernel for Ubuntu 16.04 contains only a Meltdown fix, …[Read more]
The MariaDB project is pleased to announce the availability of MariaDB 10.3.4, the second beta release in the MariaDB 10.3 series, as well as MariaDB Connector/C 3.0.3, the latest stable release in the MariaDB Connector/J 3.0 series, and MariaDB Connector/C 2.3.5, the latest stable release in the MariaDB Connector/C 2.3 series. See the release notes […]
The post MariaDB 10.3.4 and MariaDB Connector/C 3.0.3 and 2.3.5 now available appeared first on MariaDB.org.
I’m going to narrate you a story that happened around a crashing MyQL, Corrupted InnoDB table and finally the recovery by table restore. We will see how our database administrator detected the issue and what he did to resolve it. A day in MySQL Database Consultant’s day was taking its shape while a friend called […]
Database security is an essential part of any system. With more and more news reports of widespread data breaches coming in from around the world, there is no better time to check your environments and make sure you have implemented these basic steps to remain secure.
ClusterControl for Database Security
ClusterControl provides advanced deployment, monitoring and management features to ensure your databases and their …[Read more]
Now with System Versioned Tables - Announcing MariaDB Server 10.3 Second Beta RalfGebhardt Thu, 01/18/2018 - 07:19
We are happy to announce the second beta release of MariaDB Server 10.3, the fastest growing open source relational database. Beta is an important time in our release and we encourage you to download this release today! Please note that we do not recommend running beta releases in production.
MariaDB Server 10.2 added enhancements like Window Functions, Common Table Expressions, JSON functions and CHECK constraints. MariaDB Server 10.3 is the next evolution. For MariaDB Server 10.3 a lot of effort has been spent on database compatibility enhancements, especially for stored routines. This will allow easier migration of stored functions and better usability of stored functions in general.
With System Versioned …[Read more]
AWS recently announced the release MariaDB 10.2 for RDS. One of customer needs this release for GIS indexing .The recent encounter on a Replication issue with RDS MariaDB 10.2 is briefed here .
After the upgrade of replicas to MariaDB 10.2 on RDS, Once replication is stopped manually through “call mysql.rds_stop_replication;” or replication failed due to some error. Replication cannot be started back using “call mysql.rds_start_replication;” and there is no straightforward way or documented process to start the replication back. Also, most of the replication related RDS commands like skip errors etc will not work. This is due to the implementation of replication handling in RDS.
On Jan 5, 2018, RDS announced support for MariaDB 10.2. …[Read more]
10 Older Entries »