GreenSQL Securing MySQL Database Application

After identifying the need for a more thorough and stringent database security solution, GreenSQL took as its mission the creation of the most comprehensive, holistic, and robust application for database security and protection. With its roots in the open-source community, GreenSQL developed the first MySQL Database application Database Firewall as open-source software. It took the vast knowledge that it gained from the open-source community and poured it into the capabilities of the GreenSQL.

The post GreenSQL Securing MySQL Database …

Percona is glad to announce the release of Percona XtraBackup 2.3.2 GA on October 22nd, 2015. Downloads are available from our download site or Percona Software Repositories.

Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backups.

…

Percona is glad to announce the release of Percona XtraBackup 2.2.13 on October 22nd, 2015. Downloads are available from our download site or Percona Software Repositories.

Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL …

Dear MySQL users,

MySQL Connector/Net 6.7.9, 6.8.7, and 6.9.8 are maintenance releases for the series of the .NET driver for MySQL. They can be used for production environments.

They are appropriate for use with MySQL server versions 5.5-5.7.

• The GB18030 Chinese character set is now supported, a character set that was added in MySQL 5.7.4.
• The JSON type is now supported, a type that was added in MySQL 5.7.8.
• Generated columns (GENERATION_EXPRESSION) are now supported, a feature added in MySQL 5.7.6.

An additional entry added for 6.8.7:

• A connection string that included Chinese characters for a database or uid property would emit the following exception;
  “MySqlException: Unknown database ‘???'”. To solve this, the handshake process was hanged to use bytes instead of encoded strings.

The …

The MySQL developer tools team announces 6.3.5 as our GA release for MySQL Workbench 6.3.

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/list.php?152

Download MySQL Workbench 6.3.5 GA now, for Windows, Mac OS X 10.7+,
Oracle Linux 6 and 7, Fedora 21 and Fedora 22, Ubuntu 14.04 and
Ubuntu 15.04 or sources, from:
http://dev.mysql.com/downloads/tools/workbench/

Enjoy!

Dear MySQL users,

The MySQL developer tools team announces 6.3.5 as our GA release for
MySQL Workbench 6.3.

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?152

Download MySQL Workbench 6.3.5 GA now, for Windows, Mac OS X 10.7+,
Oracle Linux 6 and 7, Fedora 21 and Fedora 22, Ubuntu 14.04 and
Ubuntu 15.04 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/

On occasion, one will produce the script that will not work in _ISE or on some particular version of Powershell. So, before allowing script to run, I always do several checks depending on the task at hand. Here's the code:

#region Check
if ($host.Name -ne 'ConsoleHost')
{
    #Running in ISE
    $host.UI.WriteErrorLine("`t Script can not be run in _ISE. Exiting.")
    Exit 1
}

if (($PSVersionTable).PSVersion.Major -lt 3) {
    $host.UI.WriteErrorLine("`t Script can not be run in PS 2. Exiting.")
    Exit 2
}

$clrV = 
  ((Get-ChildItem 'HKLM:\SOFTWARE\Microsoft\NET Framework Setup\NDP' -recurse |
  Get-ItemProperty -name Version,Release -EA 0 |
  Where { $_.PSChildName -match '^(?!S)\p{L}'} |
  Select Version | Sort Version -Desc | Select -First 1).Version).Split('.')[0]
if ( $clrV -lt 4) {
    $host.UI.WriteErrorLine("`t Script can not be …

Requires ClusterControl 1.2.11 or later. Applies to MySQL based clusters.

From time to time it is necessary to tune and update your configuration. Here we will show you how you can change/update  individual parameters using the ClusterControl UI. Navigate to Manage > Configurations.

Pretend that you want to change max_connections from 200 to 500 on all DB nodes in your cluster.

Click on Change Parameter. Select all MySQL Servers in the DB Instances drop down and select the Group (in this case MYSQLD) where the Parameter that you want to change resides, select the parameter (max_connections), and set the New Value to 500:

…

When you have read my previous blog post about MariaDB 10.1 GA performance, you have probably wondered why I didn’t include any numbers for MySQL 5.7. There are two reasons: first MySQL wasn’t GA at that time and secondly MySQL is not running stable on Power8. Today I will come up with a comparison benchmark. […]

The post MariaDB 10.1 and MySQL 5.7 performance on commodity hardware appeared first on MariaDB.org.

MySQL uses a cost-based optimizer to determine the best way to execute a query. It usually does a great job, but not all the time. There are different reasons for that. In some cases, it might not have enough information about the data and plan queries in a non-optimal way.  

The optimizer makes decisions based on statistics and some fixed costs per operation, but it does not understand the differences in hardware. For instance, disk access may have different costs depending on the type of storage used - SSD drives will have quicker access times than spindles, and can perform more operations in a given time. 

However, it is possible to impact how a query will be executed, and this is the topic of today’s blog. 

(Note that in MySQL 5.7, a lot of work has been done in order to improve this - users can modify the cost of different types of operations.)

This is the fourteenth installment in the …