The latest from the MySQL community

We are happy to invite you to the upcoming MySQL Meetup in Dubai. Please find details below:

• Date: Wednesday, February 13, 2019
• Time: 7:30-9:30 pm
• Place: Oracle Office Building 6 Internet City, Room Jumeirah (map)
• Agenda: MySQL Clustering and how to make the database "High Available" -> with focusing on MySQL InnoDB Cluster (8.0) and MySQL NDB Cluster (7.6), speaker: Ted Wennmark, the MySQL Cluster Specialist
• More information

We are looking forward to seeing you all there!

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.0.38, the latest stable release in the MariaDB 10.0 series, and also the final in the maintenance window, as well as MariaDB Connector/J 2.4.0, the latest stable MariaDB Connector/J release, and MariaDB Connector/Node.js 2.0.3, the first stable release of the 100% JavaScript non-blocking MariaDB […]

The post MariaDB 10.0.38, MariaDB Connector/J 2.4.0 and MariaDB Connector/Node.js 2.0.3 now available appeared first on MariaDB.org.

We continue with announcing the upcoming shows & conferences where you can find MySQL Community or MySQL Experts at. Please find the list of events with details below. 

February 2019:

• FOSDEM 2019, Brussels, Belgium, February 1& 2-3, 2019

  • MySQL is again part of FOSDEM. Again this year with a MySQL booth & the whole day of MySQL dedicated talks in the MySQL track, see schedule here. There is also MySQL Pre-Fosdem Day followed by MySQL Pre-Fosdem Dinner, both planned for February 1, 2019. See more details in Fred Descamps' blog.
  • We are really looking to meeting you at this biggest OS show …

Introduction –

Recently i worked on a production issue for one of our client under support .They have a architecture of a three node Galera cluster with one asynchronous slave .

• Node1 – 172.10.2.11
• Node2 – 172.10.2.12
• Node3 – 172.10.2.13
• Replica – 172.10.2.14

Architecture –

The slave(replica) was configured with node3 as replica master. Unfortunately the node 3 was crashed with an OOM killer ,also server has a low gcache size, so when i am trying to start the node 3 , it went to SST . Here the data size was around 2.6 TB , in general for completion of whole SST and joining the node back to cluster will take around  approximately 12 hours.

As i told earlier, the replication slave was under …

Hello all. Last months have been busy for me with various tasks, and one of them is finally done and released in MySQL 8.0.14 : LATERAL derived tables. All details are in my post on mysqlserverteam. I think it is a useful addition to our SQL capabilities. Enjoy!

While the PMM team works hard on our PMM 2.0 release, we have been working on a few things in the background which we’d like to show off !  In particular we have developed a new dashboard that displays metrics related to memory usage on Linux systems. The dashboard leverages information collected by node_exporter. The graphs take advantage of  /proc filesystem files, specifically:

• meminfo: Provides information about distribution and utilization of memory. This varies by architecture and compile options.
• vmstat: Provides information about block IO and CPU activity in addition to memory.

…

In the just-released MySQL 8.0.14 I added a feature called LATERAL derived tables.

The manual describes the syntax and has examples of how the feature can be used to find greatest values in tables. In the present post I’m going to consider a different problem solved by LATERAL: let’s say that we have a bunch of nodes, and want to make a “random graph”, by connecting every node to other nodes.…

Facebook Twitter Google+ LinkedIn

Database Security is important to any MySQL setup. Users are the foundation of any system. In terms of database systems, I generally think of them in two distinct groups:

1. Application, service, or program users - basically customers or clients using a service.
2. Database developers, administrators, analyst, etc… - Those maintaining, working with or monitoring the database infrastructure.

While each user does need to access the database at some level, those permissions are not all created equal.

Related resources

 ClusterControl for MySQL

…

Tweet

The slow query log is the trusted old method of recording slow query, so the database administrator can determine which queries are in the most need for optimization. Since MySQL 5.6, it has to some extend been overshadowed by the Performance Schema which has lower overhead and thus allows collecting statistics about all queries. The slow query log has one major advantage though: the data is persisted. In MySQL 8.0.14 which was recently released, there is an improvement for the slow query log: additional statistics about the recorded queries.

The slow query log with log_slow_extra enabled.

Contribution

Thanks for Facebook for …

As you may have noticed by now, we are continuously improving and enhancing the experience of managing a MySQL server. Furthermore, we have also released tools, such as MySQL shell, that make advanced and distributed setups like creating, deploying, and running clusters of InnoDB instances, seamless to the end user.…

Tweet Google Plus Share