In this blog post, I will demonstrate how to configure MariaDB to use LDAP authentication and group mapping. I have previously written blog posts about configuring PAM authentication and user mapping with MariaDB and configuring PAM authentication and group mapping with MariaDB. If you’ve read those blog posts, a lot of this information will be familiar to you. However, a ... Read More
- Texas LinuxFest – July 8-9 2016 – Austin, Texas – I’ve never spoken at this event before but have heard great things about it. I’ve got a morning talk about what’s in MariaDB Server 10.1, and what’s coming in 10.2.
- db tech showcase – July 13-15 2016 – Tokyo, Japan – I’ve regularly spoken at this event and its a case of a 100% pure database conference, with a very captive audience. I’ll be talking about the lessons one can learn from other people’s database failures (this is the kind of talk that keeps on changing and getting better as the software improves).
Ahoi,There will be the IT-Tage 2016 conference. Where I'm going to
give two talks.One will be about Docker being more then a
technical revolution.The other one is about Best Practices for
As always: fun first!Erkan
I have a few upcoming speaking engagements in June 2016:
- Nerdear.la – June 9-10 2016 – Buenos Aires, Argentina – never been to this event but MariaDB Corporation are sponsors and I’m quite excited to be back in Buenos Aires. I’m going to talk about the MySQL ecosystem in 2016.
- SouthEast LinuxFest – June 10-12 2016 – Charlotte, NC, USA – I have a few talks here, a bit bummed that I’m going to be missing the speaker dinner, but I expect this to be another great year. Learn about MariaDB Server/MySQL Security Essentials, the MySQL ecosystem in 2016, and about distributions from the view of a package.
- NYC MySQL Meetup – June 27 2016 – New York, USA – I’m …
New versions of systemd (like in Ubuntu 16.04) are able to
configure pid Cgroups (
ulimit -u via Cgroups) using
Check the commit implementing TaksMax.
Author: Lennart Poettering <firstname.lastname@example.org> Date: Fri Nov 13 19:28:32 2015 +0100 core: enable TasksMax= for all services by default, and set it to 512 Also, enable TasksAccounting= for all services by default, too. See: http://lists.freedesktop.org/archives/systemd-devel/2015-November/035006.html
But not we’ve got silly defaults:
$ systemctl show -p TasksMax docker TasksMax=512 $ systemctl show -p TasksMax mysql TasksMax=512
So if you use Docker or MySQL most likely you are going to have trouble without really putting load on your server.
Just set TasksMax for your service.
Feel free to configure that setting …[Read more]
Monday I started at MariaDB working on ColumnStore. My interest in column store technology extends way back to the days as the MySQL evangelist at Kickfire, which was a compressing column store and "SQL CHIP" appliance. My initial tasks are documentation related, but I'll be helping with development, and of course testing it with Shard-Query, which is a great stress testing system.
Just a few days ago, I presented at the MariaDB Roadshow in London, and I had a lot of fun. While I had canned slides, I did know the topic intimately well, so it was good to get further in-depth. In addition, we had these MasterMind sessions, basically the place to get one-on-one time with Anders/Luisa/or me, I noticed that pretty much everyone said they were buying services afterwards (which more or less must mean the event was rather successful from that standpoint!).
In addition to that, I was happy to see that from attendee feedback, I did have the highest averages – thank you!
So here’s to repeating this in Paris next week — Gestion des données pour les applications vitales – …[Read more]
In MariaDB and MySQL, cursors create a temporary table.
Does this statement deserve a whole blog post? Apparently not. However, in some cases one does not expect a temporary table to be created:
SELECT ... FOR UPDATE: An exclusive lock is created, yes, but you still read data from a temporary table.
SELECT FROMa temporary table: you are reading from a temporary tables, yes, but an internal temporary table is created anyway.
A quick example:
CREATE TEMPORARY TABLE t ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY ); CREATE PROCEDURE p() BEGIN DECLARE c CURSOR FOR SELECT id FROM t WHERE 0 LIMIT 0 FOR UPDATE; OPEN c; CLOSE c; END; MySQL [test]> SHOW STATUS LIKE 'Created_tmp_tables'; +--------------------+-------+ | Variable_name …
I’m happy to be back in London in May 2016, to talk at two events:
- The London MySQL Meetup Group – Monday May 9 – 6.30 PM – 9.00 PM – options for High Availability in the ecosystem that one would consider today. This is a cut down from my Percona Live tutorial, which had about 88 registered attendees and about that amount showed up and asked questions even through the break and after. I had a lot of fun, and I expect I will have similar fun in London talking about this area that has changed a lot in recent times.
- Data for the Enterprise – MariaDB Roadshow in London – Wednesday, May 11, 2016 from 9:30 AM to 2:00 …
Good news everyone! There’s video up for the talk I gave at Percona Live in April 2016 up: Why would I run MySQL/MariaDB on POWER anyway?
The talk is a general overview of POWER and why MySQL/MariaDB may be a good fit.