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
…

Yesterday I learnt an important lesson about an important difference between NoSQL and MySQL, at least when it comes to the marketing and hype.

I saw a tweet from around marketing of one of NoSQL leaders:

Most people apparently would just conclude from the tweet's text, however I actually clicked the link, and couldn't believe eyes:

I guess that in NoSQL, when it comes to the integrity of data as well as hype - it is eventually consistent...

[…] MySQL variables open_files_limit, table_open_cache and max_connections are inter-related, and this is for obvious reasons: all deal with file descriptors one way or another. If one of the value is provided but others are left out, mysqld calculates others using a … Continue reading → […]

I’ve had this question several times when presenting and once via an internal email thread so I figure I might as well write about it: What is the default transactional engine in MariaDB 10.0? The answer is simple – it is XtraDB.

However this answer has some history: initial releases of MariaDB 10 actually shipped with InnoDB from MySQL 5.6. Only in 10.0.9 RC did the default switch back to being XtraDB. As MariaDB users previously know, XtraDB was the default InnoDB in 5.1, 5.2, 5.3, and 5.5 too. As always, you can switch easily between InnoDB/XtraDB – read more in: Using InnoDB instead of XtraDB. 

How do you tell what version of InnoDB or XtraDB you are running? Simply, run: SHOW GLOBAL VARIABLES LIKE 'innodb_version';

MariaDB 10.0 (read more: …