System News
 1 2 3 4 5 6 7 8 9 10 11 next
Archived MySQL Articles
25 Mar 2017
open to premium members only
MySQL 8.0 roles [61831]
The Data Charmer, March 25th, 2017

Giuseppe blogs, "One of the most interesting features introduced in MySQL 8.0 is roles or the ability of defining a set of privileges as a named role and then granting that set to one or more users. The main benefits are more clarity of privileges and ease of administration. Using roles we can assign the same set of privileges to several users, and eventually modify or revoke all privileges at once..."
(Get More Information . .)

23 Mar 2017
open to premium members only
MySQL Group Replication: native support in ProxySQL [61837]
By Lefred

Lefred blogs, "ProxySQL is the leader in proxy and load balancing solution for MySQL. It has great features like query caching, multiplexing, mirroring, read/write splitting, routing, etc. The latest enhancement in ProxySQL is the native support of MySQL Group Replication. No more need to use an external script within the scheduler like I explained in this previous post.

This implementation supports Groups in Single-Primary and in Multi-Primary mode. It is even possible to setup a Multi-Primary Group but dedicate writes on only one member..."
(Get More Information . .)

21 Mar 2017
open to premium members only
An Insider's View of MySQL Group Replication-Now Available in Oracle MySQL Cloud Service! [61838]
By Wei-Chen

Wei-Chen writes, "MySQL is the #1 open source database. Because of MySQL's high performance, scalability, and availability, it has been widely popular for Web applications and has become the foundation for IT platforms that support high-traffic social media portals, e-commerce applications, and fast-growing organizations.

As business models and technology requirements are being transformed in all industries, more and more companies are embracing and leveraging the cloud platform to enjoy the benefits of flexibility, agility and cost-savings. Available in Oracle Cloud, the Oracle MySQL Cloud Service provides an enterprise-grade MySQL database service to rapidly, securely, and cost-effectively deliver modern applications. With the latest MySQL 5.7.17 update release, MySQL Group Replication is now available in Oracle MySQL Cloud Service and offers native, built-in high availability for MySQL databases..."
(Get More Information . .)

17 Mar 2017
open to premium members only
MySQL 5.7: Improved JOIN Order by Taking Condition Filter Effect into Account [61619]
By Oystein

Oystein blogs, "One of the major challenges of query optimizers is to correctly estimate how many rows qualify from each table of a join. If the estimates are wrong, the optimizer may choose a non-optimal join order.

Before MySQL 5.7, the estimated number of rows from a table only took into account the conditions from the WHERE clause that were used to set up the access method (e.g., the size of an index range scan). This often led to row estimates that were far too high, resulting in very wrong cost estimates for join plans. To improve this issue, MySQL 5.7 introduced a cost model that considered the entire WHERE condition when estimating the number of qualifying rows from each table. This model estimates the filtering effect of the table's conditions..."
(Get More Information . .)

16 Mar 2017
open to premium members only
Monitoring Databases: A Product Comparison [61623]
By Manjot Singh

Manjot blogs in Percona, "In this blog post, I will discuss the solutions for monitoring databases (which includes alerting) I have worked with and recommended in the past to my clients. This survey will mostly focus on MySQL solutions.

One of the most common issues I come across when working with clients is monitoring and alerting. Many times, companies will fall into one of these categories:..."
(Get More Information . .)

16 Mar 2017
open to premium members only
MySQL Community Awards 2017: Call for Nominations! [61624]
By Shlomi Noach

Shlomi blogs, "The 2017 MySQL Community Awards event will take place, as usual, in Santa Clara, during the Percona Live Data Performance Conference, April 2017.

The MySQL Community Awards is a community based initiative. The idea is to publicly recognize contributors to the MySQL ecosystem. The entire process of discussing, voting and awarding is controlled by an independent group of community members, typically based of past winners or their representatives, as well as known contributors.

It is a self-appointed, self-declared, self-making-up-the-rules-as-it-goes committee. It is also very aware of the importance of the community; a no-nonsense, non-political, adhering to tradition, self criticizing committee..."
(Get More Information . .)

 
 1 2 3 4 5 6 7 8 9 10 11 next