MySQL is proud to be a Diamond Sponsor of the Southeast Linxufest June 20-22nd in Charlotte. There is a Zero to DBA track again this year. Be sure to check out the program. I will be speaking on MySQL 5.7, Query Tuning, and Big Data. Drop by the booth for BoogieBots, heavy duty luggage tags, and to talk MySQL.

We recently released a new version of Percona Cloud Tools with MySQL monitoring capabilities. Join me June 25 and learn the details about all of the great new features inside Percona Cloud Tools – which is now free in beta. The webinar is titled “Monitoring All (Yes, All!) MySQL Metrics with Percona Cloud Tools” and begins at 10 a.m. Pacific time.

In addition to MySQL metrics, Percona Cloud Tools also monitors OS performance-related stats. The new Percona-agent gathers metrics with fine granularity (up to once per second), so you are able to see any of these metrics updated real-time.

During the webinar I’ll explain how the new Percona-agent works and how to configure it. And I’ll demonstrate the standard dashboard with the most important MySQL …

I recently presented a webinar explaining how you can enjoy the key benefits of NoSQL data stores without giving up all of the great features provided by a mature RDBMS.

In case you weren’t able to attend (or wanted to refresh your memory) then the webinar replay and charts are now available.

There’s often a lot of excitement around NoSQL Data Stores with the promise of simple access patterns, flexible schemas, scalability and High Availability. The downside can come in the form of losing ACID transactions, consistency, flexible queries and data integrity checks. What if you could have the best of both worlds?

This webinar showed how MySQL Cluster provides simultaneous SQL and …

Welcome again to the series "Docker: Containers for the Masses". Today's post will be the fourth in this series and will concern itself with management of Docker using Ansible

For the reader just joining, the previous three posts in this series are:

• Introduction -- Introduction to Docker
• Installation -- Installation of Docker
• Using Docker -- Using …

In this blog post we are going to cover a pretty useful piece of functionality introduced since MySQL for Excel 1.2.0.

There could be times when users may want to see exactly what SQL queries are being generated either before they are sent to the server, so corrections can be made if the query does not look as intended, or after they are sent to the server to obtain additional information or for debugging purposes.

Starting with MySQL for Excel 1.2.0, new global options were added to modify the behavior of the moment when SQL queries that affect a MySQL database are shown to the users. The Global Options dialog can be accessed from the Options button located in the Schema Selection panel or the DB Objects Selection one as shown below.

Remember you can install the latest GA or maintenance version using the …

Read about it here

mysql-fabric-a-big-hit-at-texas-linuxfest

MySQL was proud to return as a sponsor of the Texas Linuxfest last weekend. Over 700 tickets sold and I probably talked to all bu two or three. Luckily I had help from Quality Assurance Guru Jeb Miller and Software Release Manager Hema Sridharan as things got very busy. The crowd was really supportive of us, MySQL, and extremely friendly.

MySQL Fabric was a popular topic of discussion. Evidently playing ‘who has the virtual IP address’ is a big problem for DevOps staffs and Fabric solves that issue. Many in attendance were on the verge of needing to shard their data and liked having a tool to manage the work for them.

And Workbench 6.1 is extremely popular. Me, “Have you seen the latest MySQL Workbench in action?” Attendee, “Yes, I use it all the time and ti has really become awesome in the last year!” Many non-DBAs who have to look after MySQL instances love the admin tools over fat finger on the command line.

…

“There are four things that motivate open source development teams:
1. The challenge/puzzle of programming, 2. Need for the software, 3. Personal advancement, 4. Belief in open source” — Bruce Momjian.

On PostgreSQL and the challenges of motivating and managing open source teams, I have interviewed Bruce Momjian, Senior Database Architect at EnterpriseDB, and Co-founder of the PostgreSQL Global Development Group and Core Contributor.

RVZ

Q1. How did you manage to transform PostgreSQL from an abandoned academic project into a commercially viable, now enterprise relational database?

Bruce Momjian: Ever since I was a developer of database …

June 17, 2014 By Severalnines

We continuously see great interest in MySQL load balancing and HAProxy, so we thought it was about time we organised a live webinar on the topic!

As most of your will know, database clusters and load balancing go hand in hand. 

Once your data is distributed and replicated across multiple database nodes, a load balancing mechanism helps distribute database requests, and gives applications a single database endpoint to connect to. 

Instance failures or maintenance operations like node additions/removals, reconfigurations or version upgrades can be masked behind a load balancer. This provides an efficient way of isolating changes in the database layer from the rest of the …

The Percona Backup Service managed service launched today. It ensures properly configured backups run successfully as scheduled on customer provided backup storage – whether on premise, in the cloud, or a hybrid. Backup issues or production data recovery are efficiently handled by Percona Managed Services technicians with deep knowledge of MySQL.

As we state in our white papers, “MySQL backup and recovery are a foundational piece of any infrastructure. A well-tested backup and recovery system can be the difference between a minor outage and the end of a business.” While MySQL backups are “foundational,” they …