System News
back6 7 8 9 10 11 12 13 14 15 16 next
Archived MySQL Articles
20 Sep 2016
open to premium members only
MySQL Enterprise Monitor 3.3 [56482]
By Matt Lord

Matt blogs, "We're very happy to announce the general availability of the next release of MySQL Enterprise Monitor, version 3.3 (see the full changelog here). This is the best in class tool for monitoring and management of your MySQL assets, included with your MySQL Enterprise Edition subscription..."
(Get More Information . .)

19 Sep 2016
open to premium members only
The #1 Open Source Database Now Available in Oracle Cloud [56480]
By Bertrand Matthelie

Bertrand blogs, "We're very excited to announce the General Availability of Oracle MySQL Cloud Service!

Oracle MySQL Cloud Service allows you to accelerate innovation and to rapidly, securely and cost-effectively develop & deploy modern applications powered by the world's most popular open source database.

Built on the proven MySQL Enterprise Edition and powered by the Oracle Cloud, it provides a simple, automated, integrated and enterprise-ready cloud service that enables organizations to deliver MySQL-based applications globally at scale..."
(Get More Information . .)

17 Sep 2016
open to premium members only
Maximizing Database Performance - MySQL Tuning Best Practices [56256]
By Janis Griffin

"With the added complexity of growing data volumes and ever changing workloads, database performance tuning is now necessary to maximize resource utilizations and system performance. However, performance tuning is often easier said than done.

Let's face it, tuning is difficult for a number of reasons. For one thing, it requires a significant amount of expertise in order to understand execution plans, and often update or re-write good SQL. On top of that, tuning is usually very time consuming. There will always be a large volume of SQL statements to sort through, which may lead to uncertainty around which specific statement needs tuning; and given every statement is different, so too is the tuning approach.

As data volumes grow and technology becomes increasingly complex, it is becoming more important to tune databases properly to deliver end-user experience and to lower infrastructure costs. Performance tuning can help database professionals quickly identify bottlenecks, target insufficient operations through review of query execution plans and eliminate any guessing games.

Regardless of the complexity or skill level, the following MySQL performance tuning tips will serve as a step-by-step guide to solving MySQL performance problems and help alleviate the pain points that often accompany performance tuning..."
(Get More Information . .)

17 Sep 2016
open to premium members only
Don't Spin Your Data, Use SSDs! [56047]
For database environments

Peter Zaitsev blogs, "For years now, I've been telling audiences for my MySQL Performance talk the following: if you are running an I/O-intensive database on spinning disks you're doing it wrong. But there are still a surprising number of laggards who aren't embracing SSD storage (whether it's for cost or reliability reasons).

Let's look at cost first. As I write this now (September 2016), high-performance server-grade spinning hard drives run for about $240 for 600GB (or $0.40 per GB). Of course, you can get an 8TB archive drive at about same price (about $0.03 per GB), but it isn't likely you'd use something like that for your operational database. At the same time, you can get a Samsung 850 EVO drive for approximately $300 (or $0.30 per GB), which is cheaper than the server-grade spinning drive!.."
(Get More Information . .)

15 Sep 2016
open to premium members only
Roles on MySQL 8.0 [56261]
By Gabriela D'Avila

Gabriela blogs, "his is a blogpost about MySQL 8.0.0, the content here could be subject to changes in the future since this is not a stable release.

This is a feature that will make life the many DevOps and DBAs easier. Believe it or not, a lot of people control access to the database by sharing the same username and password. Which is completely insecure for a number of reasons:

  • If someone is fired, they still have access
  • If you get hacked for using the same password, well, I only can say: good luck

That also means: no more querying to Stack Overflow to get that giant GRANT statement for each user you need to create..."
(Get More Information . .)

12 Sep 2016
open to premium members only
MySQL 8.0 first impressions [56266]
By Giuseppe Maxia

Giuseppe blogs, "MySQL 8.0.0 was released today. It has been some time in the making, shrouded in a veil of secrecy for over one year. We knew, from listening to the gossip and looking at the few available previews, some of what was going to bring. So, for the observant users, its main features may not come as a surprise. For the rest of you, here's a quick roundup:..."
(Get More Information . .)

 
back6 7 8 9 10 11 12 13 14 15 16 next