Nice to hear that MySQL Enterprise Backup 3.11.0 has been released..in windows what is the minimum requirement for it?..

September 3, 2014 By Severalnines

Running your database cluster on AWS is a great way to adapt to changing workloads by adding/removing instances, or by scaling up/down each instance. At Severalnines, we talk much more about scale-out than scale up, but there are cases where you might want to scale up an instance instead of scaling out. 

In this post, we’ll show you how to change instance sizes with respect to RAM, CPU and IOPS, and how to tune your Galera nodes accordingly. Moreover, this post assumes that instances are launched using Amazon VPC.

When do we need to upgrade an instance?

You typically need to upgrade an instance when you run out of server resources. This includes CPU, RAM, storage capacity, disk throughput and bandwidth. You must allow enough headroom for …

Schedule Builder allows you to effectively plan your conference and pre-enrol in MySQL Central sessions you want to attend. In addition to the keynotes, you can schedule your attendance to conference sessions delivered by Oracle's MySQL engineers, MySQL customers, community members and partners, as well as plan to attend tutorials, hands-on labs and Birds-of-a-Feather sessions. Plus, you can also plan to join all the Oracle OpenWorld keynotes, extensive content and entertainment!

The MySQL Central "Focus On" document provides you an overview of the MySQL Central content (note that one additional tutorial will shortly be added to the doc so …

We are pleased to announce our attendance at the PyCon New Zealand in Wellington, New Zealand, on September 12-14, 2014! This time we do not have a booth, but will be very actively going around and talk to you. Find our staff wearing MySQL t-shirt!

Anyway if you are interested our colleague from the Solaris Modernization team, James C. McPherson is going to have a talk on Why Python rocks Solaris. Come to hear James' talk scheduled for Saturday, Sep 13 @ 11:20 am (Track 1). 

It's hot. I'll try :D

Wed, 2014-09-03 07:48anatoliydimitrov

Auditing is an essential task for monitoring your database environment. Auditing information can help you troubleshoot performance or application issues, and lets you see exactly what SQL queries are being processed. MariaDB's Audit Plugin provides auditing functionality for not only MariaDB, but MySQL as well.

If you installed MariaDB from its official packages, you probably already have the plugin on your system, even though it's neither installed nor enabled by default. Look for a file called server_audit.so (in Linux) or server_audit.dll (in Windows) inside your plugins directory (/usr/lib64/mysql/plugin/ in CentOS 6). If you are not sure which is your plugins directory, run the query SHOW VARIABLES LIKE 'plugin_dir';. …

Let me start by saying a big “thank you” to the staff at Oracle for deciding to open source reducer.sh. It’s a tool I developed whilst I was working for them several years ago. Its sole purpose is to do one thing – but do it good: test-case simplification.

So, let’s say some customer just sent you 120,000 lines of SQL code and affirms that “it definitely causes a crash.” Or maybe you ran RQG (the Random Query Generator) for awhile (with the general query log turned on) and now you have a nice SQL trace which may just lead to that crash the run resulted in. Or you’re a DBA testing the company’s usual queries with Valgrind, and noticed that 2 in 1000 queries give a Valgrind warning in the mysqld error log – you’re just not sure which one. Or maybe you’re a developer, and during testing you saw that a SELECT query output did not look the way it should – the output was “7″ where it should have been “5″ – the …

What MySQL version 3.11.0 with new and improved versions other than

We are pleased to announce that MySQL Enterprise Monitor 3.0.14 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud in a few weeks. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.

You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.

You will also find the binaries on the Oracle Software Delivery Cloud in a few weeks. Choose "MySQL Database" as the Product Pack and you will …

MySQL Enterprise Backup team is glad to announce the new release of MySQL Enterprise Backup (MEB) 3.11.0.

Overview

MEB 3.11.0 focuses on enhancing backup/recovery performance and adding new features that would help database administrators.

This release addresses some of the challenges customers face today while taking backups of very large databases(in terrabytes). This release also provides more complete backup with all the necessary logs required to clone a server. We have also added online restore of tables in 3.11.0 to help DBAs fix corrupted tables in the server from existing backups.

MEB 3.11.0 also brings in cloud support for backup and restore. To meet the growing trend of cloud storage, we released this feature in July '14 as part of  MEB 3.10.2 release.

Please refer to this blog on …