Message brokers are not regularly covered here but are, nonetheless, important web-related technologies. Some time ago, I was asked by one of our customer to review a selection of OSS message brokers and propose a couple of good candidates. The requirements were fairly simple: behave well when there’s a large backlog of messages, be able to create a cluster and in case of the failure of a node in a cluster, try to protect the data but never blocks the publishers even though that might imply data lost. Nothing fancy regarding queues and topics management. I decided to write my findings here, before I forget…

I don’t consider myself a message broker specialist and I spent only about a day or two on each so, I may have done some big mistakes configuration wise. I’ll take the blame if something is misconfigured or not used correctly.

…

This month another MySQL User Group meeting is scheduled, this time in Seoul, Korea on May 20, 2014 @ 6:30pm. Please mark your calendar for this day if you are local... It's a great opportunity to hear news about delivering MySQL 5.7.4 as well as we saved some time for a MySQL User Group discussion. Please see details below:

Name: MySQL User Group Meeting

Date: May 20th, 2014

Time: 6:30pm

Place: 15fl. ASEM Tower, (Oracle Korea office), Samsung-dong, Seoul, Korea

For more details see the MySQL Korea User Group Facebook page

Tools for MySQL are a vital part of any deployment, so it’s important to use ones that are reliable and well-designed. Percona Toolkit is a collection of more than 30 command-line tools for MySQL, Percona Server, and MariaDB that can help database administrators automate a variety of database and system tasks. With so many available tools, however, it can be difficult knowing where to start.

For this reason I invite you to join me on Wednesday, May 7 at 10 a.m. Pacific time for a free webinar titled, “The top 9 Percona Toolkit tools that can make your job easier.” You can register directly …

Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Management) On Fedora 20

This document describes how to install a PureFTPd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota and upload/download bandwidth limits with this setup. Passwords will be stored encrypted as MD5 strings in the database.

The Brainiac Corner is a format where we talk with some of the smartest minds in the system, database, devops, and IT world. If you have opinions on pirates, or anything else related, please don't hesitate to contact us. 

Today, we interview Michael Holroyd, a Charlottesville technologist who has formed at least two tech startups, including Arqball and Knollop. Michael is also the Chairman for the Blue Ridge Mountain Rescue Group non-profit which provides search and rescue services for the Virginia area.

How did you get from stork to brainiac (i.e. what do you do today and how did you get there)?

For my Ph.D. I designed and built an extremely accurate system for measuring the 3D shape and …

The Brainiac Corner is a format where we talk with some of the smartest minds in the system, database, devops, and IT world. If you have opinions on pirates, or anything else related, please don't hesitate to contact us. 

Today, we interview Michael Holroyd, a Charlottesville technologist who has formed at least two tech startups, including Arqball and Knollop. Michael is also the Chairman for the Blue Ridge Mountain Rescue Group non-profit which provides search and rescue services for the Virginia area.

How did you get from stork to brainiac (i.e. what do you do today and how did you get there)?

For my Ph.D. I designed and built an extremely accurate system for measuring the 3D shape and …

Recently there was a discussion on the webscalesql mailing list started by Chip Turner on a proposed change to the MAX_STATEMENT_TIME patch. This feature has been known as per query variable settings (WL#681) and even shipping in Percona Server 5.6 as per-query variable statement.

This feature has piqued my interest since 2009, when the MySQL project (then owned by Sun Microsystems) participated in Google Summer of Code 2009, and we got code from …

[…] post Slides from PLMCE 2014 breakout session appeared first on Spooky Action at a […]

As many of you already know, PLMCE is an annual MySQL
community conference and Expo organized by Percona in the month of April
(usually). It is a great conference, not only to meet new and eminent people in
MySQL and related database fields, but also to attend interesting talks, and
also to give some.

This year I spoke about synchronous replication at a higher level. The talk was
titled “ACIDic Clusters: Review of current relational databases with synchronous replication”. Having previously given talks with boring titles (but interesting content), this time I decided to go with an interesting title, and it seemed to fit well with topic being discussed.
…

@Daniël,

Thanks for the details and the link.

Yes, I see a few changes in 5.6 as per the commit introduced in fix of Bug#16430532.

a)
For the issue with diagnostics printed to error log, 5.5 also has it now. (I
see the bug was filed in 2011, so may be it wasn’t there then).

sql_print_warning(“Changed limits: max_open_files: %u max_connections: %ld table_cache: %ld”,
files, max_connections, table_cache_size);

sql_print_warning(“Could not increase number of max_open_files to more than %u (request: %u)”, files, wanted_files);

b)
But, regarding http://bugs.mysql.com/file.php?id=17457&bug_id=62224,
I see that in the above patch, you don’t try to set above the
hard limit (with ‘(max_file_limit > rlimit.rlim_max)’) to avoid failing and
…