Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 34236 10 Older Entries
Locking accounts in MySQL 5.7
Employee +0 Vote Up -0Vote Down

I’ve written previously about use cases where having accounts which cannot be used to establish client connections are useful. There are various hacks to accomplish this with legacy versions (insert invalid password hash into mysql.user table, etc.), and we introduced the mysql_no_login authentication plugin for this very purpose. Now as of MySQL 5.7.6, …

  [Read more...]
MySQL Enterprise Edition Database Firewall – Control and Monitor SQL Statement Executions
+0 Vote Up -0Vote Down

As of MySQL 5.6.24, MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall (it runs within the mysql database process) that enables database administrators to permit or deny SQL statement execution based on matching against whitelists of accepted statement patterns. This helps harden MySQL Server against attacks such as SQL injection or attempts to exploit applications by using them outside of their …

  [Read more...]
Percona Live Presentation: MySQL Security Essentials
+1 Vote Up -0Vote Down

The slides for my MySQL Security Essentials presentation at Percona Live 2015 MySQL Conference and Expo are now available.

In this presentation I discuss just how insecure legacy versions of MySQL are and what are the essential requirements for securing your installation on disk, via network and with user privileges. I provide recommendations for how to manage application access for your most important data asset.

  [Read more...]
Considering Sharding with MySQL? Join my April 22 webinar. Questions welcome!
+0 Vote Up -0Vote Down

MySQL sharding is one of the most used and surely the most abused MySQL scaling technology. My April 2 Dzone article, “To Shard, or Not to Shard,” proved there is indeed quite an interest in this topic.

As such, I’m hosting a live webinar tomorrow (April 22) that shed light on questions about sharding with MySQL. It’s titled: To Shard or Not to Shard That is the Question!

I’ll be answering questions …

  [Read more...]
MySQL 5.7 milestone
+0 Vote Up -0Vote Down

MySQL 5.7 will be a great milestone in MySQL total history.
Oracle has released many useful new features in LAB version . MySQL is becoming more similar to Oracle database

Read this presentation I post on slideshare:

MySQL 5.7 milestone

SSL/TLS and RSA Improvements for OpenSSL Linked MySQL 5.7 Binaries
Employee_Team +0 Vote Up -0Vote Down

What?

MySQL 5.7 server binaries compiled with the OpenSSL library now make it easy to set up SSL/TLS and RSA artifacts, and to enable them within MySQL. Two new read-only global options have been introduced through this work:

  • --auto-generate-certs: Enables automatic generation and detection of SSL artifacts at server start-up.
  • --sha256-password-auto-generate-rsa-keys: Enables automatic generation of an RSA key pair.

These options …

  [Read more...]
SQL Load Balancing Benchmark - Comparing Performance of MaxScale vs HAProxy
+1 Vote Up -0Vote Down

In a previous post, we gave you a quick overview of the MaxScale load balancer and walked through installation and configuration. We did some quick benchmarks using sysbench, a system performance benchmark that supports testing CPU, memory, IO, mutex and also MySQL performance. We will be sharing the results in this blog post.

Sysbench setup

For our tests we used the latest version …

  [Read more...]
VividCortex Receives the MySQL Application of the Year Award
+0 Vote Up -0Vote Down

Last week at Percona Live, VividCortex received the MySQL community award for 2015 Application of the Year.

Baron Schwartz, our founder and CEO, is quoted, “It’s an honor to receive this award from the MySQL community. We aim to raise the bar for database monitoring the same way MySQL has raised the bar for open source databases. Our product would not be at this point without the dedication and help of our employees, friends, customers and investors. We thank them for their support and look forward to many years of mutually beneficial relationships. On a personal note, as a previous recipient of Community Member of the …

  [Read more...]
Connector/Python 2.0
+1 Vote Up -0Vote Down

Connector/Python 2.0 (2.0.4 GA, published on Tuesday, 21 Apr 2015)

Percona Live 2015 Wrap-up: Bigger and better every year
+1 Vote Up -0Vote Down

Mon, 2015-04-20 20:43Marc Sherwood

So I am now back in my office in Vancouver, BC after an amazing week in Santa Clara for the Percona Live MySQL Conference and Expo. I though that I would take a break from trying to catch up with my email and write down some quick thoughts about this great event. 

This year's event was announced to be the largest in several years, with an estimated 1200 people in attendance. To me what stands out about this number is just how it supports the fact that the MariaDB and MySQL community is growing and stronger than ever. If we assume that each of the 1200 attendees were our of the office for the full …

  [Read more...]
Showing entries 1 to 10 of 34236 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.