Above the events announced on September 15, 2017 MySQL experts and / or MySQL Community team is going to attend following events below. Please mark your calendars for:

• MySQL User Camp, Bangalore, India, November 10, 2017
  • Next MySQL User Camp in Bangalore, India will be hold on Nov 10, see details below:
    • Date: November 10, 2017
    • Time: 3-5:30 pm
    • Agenda:  
      • Router with Demo
      • InnoDB Features in 5.7
      • MySQL Enterprise Backup: A deep dive
    • Venue: …

We are happy to invite you to the first MySQL Meetup of the MySQL UAE User Group! Please find more details below:

• Date: Wednesday, October 4th, 2018
• Time: 6-8pm
• Agenda: MySQL Overview or Welcome to MySQL Ecosystem
  • Abstract: MySQL is the most popular open-source database in the world and has been downloaded and/or distributed by MySQL sites over 100 million times. With its outstanding speed, reliability, and ease of use, MySQL has become the preferred choice for Web, SaaS, ISV, and telecom companies like Facebook, Uber, Paypal and many others. In this short overview we will highlight some of the MySQL use cases and will look at how booking.com use MySQL today. 
• Presenter: Carsten Thalheimer …

In my previous article about roles I said that one of the problems with role usage is that roles need to be activated before they kick in. Let's recap briefly what the problem is:

## new session, as user `root`

mysql [localhost] {root} ((none)) > create role viewer;
Query OK, 0 rows affected (0.01 sec)

mysql [localhost] {root} ((none)) > grant select on *.* to viewer;
Query OK, 0 rows affected (0.01 sec)

mysql [localhost] {root} ((none)) > create user see_it_all identified by 'msandbox';
Query OK, 0 rows affected (0.01 sec)

mysql [localhost] {root} ((none)) > grant viewer to see_it_all;
Query OK, 0 rows affected (0.01 sec)

## NEW session, as user `see_it_all`

mysql [localhost] {see_it_all} ((none)) > use test
ERROR 1044 (42000): Access denied for user 'see_it_all'@'%' to database 'test'

mysql [localhost] {see_it_all} ((none)) > show grants\G …

It's our pleasure to announce that MySQL Community team is supporting multiple shows around the world. Please find a list of conferences & events where you can find us in August & September below:

NA&LAD

• UbuCon LA,Lima, Peru, Aug 18-19, 2017

  • MySQL Community team is supporting this small Ubuntu conference in LAD as Platinum sponsor.  
• Pacific Northwest PHP, Seattle, US, Sep 9-11, 2017
  • You can find our team at the MySQL Community booth in the expo area.
• Madison PHP, Madison, US, Sep 22-23, 2017
  • MySQL Community team is supporting this PHP conference as Community partner. …

One of the goals of the MariaDB Foundation is to help new contributors understand the source code and to lower the barrier for new participants. One way to measure this is to look at the number of pull requests received and accepted, as these mostly reflect community contributions. The figures below are for the main […]

The post Community contributions to MariaDB appeared first on MariaDB.org.

Recently I posted a blog on my time attending a DevOps event in Toronto.  In that blog I had intended to focus on the conference and highlight some of the topics that stood out for me.  In this blog though, I wanted to share what others were doing with containers like Docker, and particularly and… Read More »

I recently attended DevOpsDays Toronto 2017, my first proper DevOpsDaysTO event.  I had the pleasure of attending and being able to immerse myself in this openly collaborative and supportive culture of IT professionals.  The variety of considerations expressed for delivering software features in a rapidly, frequently and reliable release focused manner was really intriguing….but not without its own complexities.… Read More »

Once again, Pythian is organizing the traditional Open Source Database Community dinner in Santa Clara!

• When: Tuesday April 25, 7pm-10pm
• Where: David’s Restaurant, a short 5-minute walk from the Santa Clara Convention center.
• Tickets: Register here!

Among the attendees will be Pythian’s amazing lineup of speakers at the PerconaLive Conference.

This event is open to all open source database community members who will be in the area; many will be in town for the …

In the MySQL team, one of our focuses over the last few releases has been improving the usability of the MySQL Server for operations teams.  The results can be seen in a number of areas:

• Our continued investment in Performance Schema.  

…

About one month ago, the MySQL team at Oracle released MySQL 8.0, with a large list of changes. One of the most interesting features in the new release is also one that does not show up much, also because the team has gone to great length to keep most of its implementation hidden: the data dictionary.

What makes the data dictionary so interesting, despite its scarce visibility, is the effect that it has on performance. Up to MySQL 5.7, searching the information_schema was an onerous operation, potentially crippling the system. In MySQL 8.0, the same operations are …