System News
back1 2 3 4 5 6 7 8 9 10 11 next
Articles for the keywords: MySQL
05 Apr 2017 MySQL High Availability tools - Comparing MHA, MRM and ClusterControl [62252]
Severalnines, April 5th 2017

Krzysztof Ksiazek blogs, "We previously compared two high availability solutions for MySQL - MHA and MariaDB Replication Manager and looked into how they performed fail-over. In this blog post, we'll see how ClusterControl stacks up against these solutions. Since MariaDB Replication Manager is under active development, we decided to take a look at the not yet released version 1.1.

All solutions provide flapping detection. MHA, by default, executes a failover once. Even after you restart masterha_manager, it will still check if the last failover didn't happen too recently. If yes (by default, if it happened in the last 8 hours), no new failover will happen. You need to explicitly change the timeout or set --ignore_last_failover flag..."
(Get More Information . .) open to premium members only

25 Mar 2017 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 . .) open to premium members only

23 Mar 2017 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 . .) open to premium members only

22 Mar 2017 How to Secure MySQL/MariaDB Servers [61841]
By Ashraf Sharif

"After attacks on MongoDB databases, we have recently also seen that MySQL servers are being targeted by ransomware. This should not come as a surprise, given the increasing adoption of public and private clouds. Running a poorly configured database in the cloud can become a major liability.", writes Ashraf.

"In this blog post, we'll share with you a number of tips on how to protect and secure your MySQL or MariaDB servers..."
(Get More Information . .) open to premium members only

21 Mar 2017 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 . .) open to premium members only

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






!-- end archive_section.tpl -->