(Luis Soares) Great news! MySQL 8.0.3 is out and it is a release candidate. In the replication team we have been busy working on interesting new enhancements and also doing some clean up. Some of these new features are out in this release. Let me summarize the new replication bits and pieces in MySQ
Tag: Open Source
sysbench Histograms: A Helpful Feature Often Overlooked
(Peter Zaitsev) In this blog post, I will demonstrate how to run and use sysbench histograms.
Configuring a MySQL Database on Amazon RDS
(Rob Gravelle) Perhaps you’ve noticed that cloud-based database solutions have really taken off in recent years. Although concerns about ownership and security have put a damper on some companies’ aspirations to offload some or all of their database management to a third party, the vast majority of
Find Queries That Need Indexes With VividCortex
(Baron Schwartz) Queries can be slow or resource-heavy for many reasons, but one of the most common is that the table doesn’t have a good index for the query. This is true for MySQL, PostgreSQL, and especially for MongoDB.
ProxySQL Improves MySQL SSL Connections
(Jervin Real) In this blog post, we’ll look at how ProxySQL improves MySQL SSL connection performance.
Probability perspective on MySQL Group replication and Galera Cluster
(Serge Frezefond) Comparing Oracle MySQL Group Replication and Galera Cluster through a probability perpective seems quite interesting.
The MySQL High Availability Landscape in 2017 (the Babies)
(Yves Trudeau) This post is the third of a series focusing on the MySQL high availability solutions available in 2017.
How to combine BATS, PyTest and MySQL X Plugin for tests
(Shahriyar Rzayev) In this post I am going to show some tricks on using BATS framework + PyTest + Python X Plugin things, to have combined, simple test solutions.
cscope: Searching Code Efficiently
(Agustín) In this post, we will discuss how to search code with the help of cscope. Let’s begin by checking its description and capabilities (quoting directly from http://cscope.sourceforge.net/):
MySQL 8 – Roles
(Satej Sahu) With the next version of MySQL that is MySQL 8, there is a very nice feature of creating “roles” which can be assigned certain privileges and then these roles can be assigned to users, thus helping us in maintaining the principle of least privilege.
