The MySQL Devroom is pleased to announce the committee that will decide on the talks to be presented for this totally new format of the next FOSDEM edition. Indeed, if you are not yet aware of it, FOSDEM 2021 will be an online event. Every year we are overwhelmed with submissions and it’s the committee that has the thankless task of deciding on the final selections and agenda.

Every year, we try to have a mix of experienced members knowing the process of the devroom talks rating and expect them to mentor the new members.

This year’s committee members are:

• Elisa Usai
• Gabriela D’Ávila Ferrara
• Liz Van Dijk
• Silvia …

Recently (earlier today), I blogged about how to use PHPMyAdmin with a MDS instance. I also showed at the end of the video that it’s possible to open MySQL Router on the compute instance to connect from anywhere. However this has security risks of course. Therefor, it’s not recommended.

If you want to connect from on-premise to your MDS instance you should use a VPN or a SSH tunnel. Take a look at these previous post:

• https://lefred.be/content/migrate-from-on-premise-mysql-to-mysql-database-service/
• …

I recently received several messages from developers not being comfortable with command line when they need to create schemas, tables, … They were asking me for an easy alternative when testing MDS.

There is a very popular tool in the developer community to manage their databases in MySQL: PHPMyAdmin.

So if you are trying MDS (MySQL Database Service in Oracle Cloud Infrastructure), it’s possible to deploy such instance with a compute instance hosting PHPMyAdmin very easily using OCI’s Resource Manager and a stack (zip file) that you can find here: https://github.com/lefred/oci-phpmyadmin-mds/releases/tag/1.1.0

If you want to try MDS in OCI, you can get free credits using this url: …

We are happy to inform you know about regular MySQL Webinars run by Carsten Thalheimer, the MySQL Solution Engineer. They are scheduled once a month and they are fully virtual. See details below:

• In English:
  • Timing: every first Thursday of a month
  • Focus: English speaking audience (focus Middle East)
  • Webinar Title: Things I should have known before I installed MySQL... 
  • URL for Zoom: https://oracle.zoom.us/webinar/register/WN_uMez9v1dQfiw7WucMyuxXw
• In German
  • Timing: every first Friday of a month
  • Focus: German speaking audience (focus D-A-CH)
  • Webinar Title: Things I should have known before I installed MySQL... …

We are happy to inform you know about regular MySQL Webinars run by Carsten Thalheimer, the MySQL Solution Engineer. They are scheduled once a month and they are fully virtual. See details below: In English: Timing: every first Thursday of a month Focus: English speaking audience (focus Middle East)...

This blog includes: Keynote video highlights, link to full keynote, product demo, testimonial, upcoming MySQL Database Service and Analytics Engine webinars, and more.

Today the MySQL team introduces the MySQL Database Service with the MySQL Analytics Engine.

1. Watch the keynote highlights:

2. See the MySQL Database Service in action in a short product demo. 

3. Learn about the great savings over competitive solutions such as Amazon Aurora, RDS, or Redshift.   

4. Discover how the MySQL Analytics Engine accelerates MySQL queries by 400x.

5. Check out the benchmarks: MySQL Database Service with Analytics Engine is 1100x faster than Amazon Aurora, 2.7x faster than …

This blog includes: Keynote video highlights, link to full keynote, product demo, testimonial, upcoming MySQL Database Service and Analytics Engine webinars, and more. Today the MySQL team introduces the MySQL Database Service with the MySQL Analytics Engine. 1. Watch the keynote highlights: 2. See ...

Introduction

MySQL is the most popular open-source database and many organizations choose MySQL to store their valuable enterprise data. MySQL is optimized for OLTP, but it is not designed for analytic processing. As a result, organizations which need to efficiently run analytics on data stored in MySQL database move their data to another database to run analytic applications.

This approach of moving data to another database introduces complexity and additional cost for customers in multiple ways:

1. Applications need to define complex logic for extracting relevant data from MySQL.
2. The extracted data needs to be transported to another database across networks in a secure way, which takes times and creates security vulnerability.
3. Data in the other database needs to be manually kept in sync with the MySQL database and as a result the data on which analytics is performed can become …

Introduction MySQL is the most popular open-source database and many organizations choose MySQL to store their valuable enterprise data. MySQL is optimized for OLTP, but it is not designed for analytic processing. As a result, organizations which need to efficiently run analytics on data stored in M...

The benefits of jemalloc versus glibc memory allocator for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) there is less memory fragmentation, and thus more efficient resource management of the server memory. For MySQL 5.6, installing jemalloc is enough to enable it when starting the MySQL process. However, for MySQL 5.7 and 8.0.X series, you will need to take a few extra steps.

Enabling jemalloc on Percona Server for MySQL

Installing the jemalloc package is simple for Percona. This is because the library is available on the Percona repository, which is available for both apt and yum package management:

…