Download MariaDB Galera Cluster 10.0.16
Release Notes Changelog What is MariaDB Galera Cluster?
MariaDB APT and YUM Repository Configuration Generator
The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.16. This is a Stable (GA) release.
See the …
[Read more]Hi there, it’s been a few months since Percona Live London has finished, but I managed just now to get sometime to post the slides from my presentation about backups. Please, take a look and feel free to comment.
Cloud security company Qualys announced Tuesday the issues prevalent in glibc since version 2.2 introduced in 2000-11-10 (the complete Qualys announcement may be viewed here). The vulnerability, CVE-2015-0235, has been dubbed “GHOST.”
As the announcement from Qualys indicates, it is believed that MySQL and by extension Percona Server are not affected by this issue.
Percona is in the process of conducting our own review into the issue related to the Percona Server source code – more information will be released as soon as it is available.
In the interim the current advisory is to update your glibc packages for your distributions if they are in fact vulnerable. The C code from the Qualys announcement may aid in your diagnostics, section 4 of …
[Read more]Dear MySQL Friends,
Unfortunately, this year we won’t have the pleasure to attend Raghu’s show. Indeed, he couldn’t apply in time for his Visa.
I would like to thank Andrew Morgan to have accepted to present his talk “MySQL & NoSQL – best of both worlds” to replace “ENOMEM: Will databases ever stop asking for more memory” from Raghu.
Respecting the logic, the next talk should have been
“Introduction to MySQL Binlog Events” from Neha Kumari, but once
again it was too late for Visa appliance.
Logically, Andrew was the next one and he agrred to present his
talk even if the notification was very short.
The final schedule is:
| Event | Speakers | Start | End |
|---|---|---|---|
| Sunday | |||
| … |
MySQL 5.6 allows you to execute replicated events in parallel as
long as data is split across several databases. This feature is
named “Multi-Threaded Slave” (MTS) and it is easy to enable by
setting slave_parallel_workers to a > 1 value.
However if you decide to use MTS without GTIDs, you may run into
annoying issues. Let’s look at two of them.
Skipping replication errors
When replication stops with an error, a frequent approach is to
“ignore now and fix later.” This means you will run SET
GLOBAL sql_slave_skip_counter=1 to be able to restart
replication as quickly as possible and later use
pt-table-checksum/pt-table-sync to resync data on the slave.
Then the day when I hit:
mysql> show slave status; [...] Last_SQL_Error: Worker 0 failed executing transaction '' at master log mysql-bin.000017, end_log_pos 1216451; Error 'Duplicate entry '1001' for key 'PRIMARY'' on query. …[Read more]
Qualys announced they had found an exploit in one of the Linux core libraries – glibc – using a buffer overflow technique in gethostbyname(). They have developed a proof-of-concept in which simply sending a specially created e-mail to a mail server enabled them to create a remote shell to the Linux machine. According to Qualys, “This bypasses all existing protections (like ASLR, PIE and NX) on both 32-bit and 64-bit systems.”. How does it affect MySQL servers? Read on!
The vulnerable library call provides DNS name resolution and although it’s been obsoleted in favour of other calls, it is still widely used by both legacy and modern applications.
Having a quick search, MySQL does not seem to rely on gethostbyname() almost at all. A few uses can be found in MySQL Cluster code (NDB), …
[Read more]Release Notes Changelog What is MariaDB 10.0?
MariaDB APT and YUM Repository Configuration Generator
The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.16. This is a Stable (GA) release.
See the Release Notes and …
[Read more]This Log Buffer Edition keeps the aim high and brings few of the best blog posts from Oracle, SQL Server and MySQL.
Oracle:
3 Modes for Moving Data to the BI Applications DW from a Source Application Database.
JSON for APEX Developers.
Neelakanth Nadgir posted a useful utility that prints out various statistics about the ZFS Adaptive Replacement Cache (ARC).
Obtaining Bonus Depreciation Methods for Oracle Fixed Assets.
Existing News – …
[Read more]Madrid MySQL Users Group will have its next meeting on Thursday, the 29th of January. I will be giving a presentation on the MySQL binlog server and how it can be used to help scale reads and be used for other purposes. If you have (more than) a few slaves this talk might be interesting … Continue reading MMUG11: Talk about binlog servers at Madrid MySQL Users Group meeting on 29th January 2015
The post MMUG11: Talk about binlog servers at Madrid MySQL Users Group meeting on 29th January 2015 first appeared on Simon J Mudd's Blog.
Long time ago I wrote a blog post that we started using
Semi-Synchronous replication in production at Facebook. We are
running our own MySQL facebook-5.6 branch, which added many replication
(including Semisync) patches. Some of them were also merged with
WebScaleSQL.
Recently I heard from people from community that they were
suffering from Semisync performance issues in official MySQL 5.6.
I took some time to review our previous MySQL bug reports, then
realized that some important bugs were either still "verified" or
inefficiently fixed. Two most affecting bug reports were …