Percona is glad to announce the release of Percona XtraBackup 2.2.3 on June 12th 2014. Downloads are available from our download site here and Percona Software Repositories.

Percona XtraBackup enables 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 backup. The new 2.2.3 …

In a previous post I was talking about How to Setup MySQL Replication using the classic method (based on binary logs information). In this article I'll go through the transaction-based replication implementation using GTID in different scenarios.

The following topics will be covered in this blog:

• What is the concept of GTID protocol?
• GTID Replication Implementation
  • Fresh Installations
  …

MariaDB 5.5.38 was recently released (it is the latest MariaDB 5.5), and is available for download here:

https://downloads.mariadb.org/mariadb/5.5.38/

This is a maintenance release, and so there are not too many big changes of note, just a number of normal bug fixes. However, there are a few items worth mentioning:

• Includes all bugfixes and updates from MySQL 5.5.38
• XtraDB updated to the version from Percona Server 5.5.37-35.0
• TokuDB updated to version …

It was back in the 1980's when I was first introduced to Unix, the concept of scripting and in particular pipes. At that time I remember being really impressed by the concept of small utilities that could be easily strung together to quickly create tools. It was a great way to implement those one off jobs or things that would not warrant the development of a specific tool, or so it seemed. I soon realised that actually, for some purposes, there was no need to go on a develop a bespoke tool to do the job, scripts were good enough. What does this have to do with MySQL and MaxScale?

read more

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.11. This is a Beta release.

See the Release Notes and Changelog for detailed information on this release and the What is MariaDB Galera Cluster? page in the MariaDB Knowledge Base for general information about MariaDB Galera Cluster.

Download MariaDB Galera Cluster 10.0.11

…

June 12, 2014 By Severalnines

We’re delighted to be joining Team MariaDB at SkySQL with a talk on ‘Automation & Management of Database Clusters’ as they tour across several European regions in the coming weeks.

Whether you’re a MariaDB enthusiast or newbie, a MySQL veteran or newbie, or even a MongoDB user who also happens to run MySQL or MariaDB databases: this roadshow is a good place to find out about the latest developments on the MariaDB database as well as related tools and technologies. 

From our own perspective, we’ll be updating participants on how to best automate & manage their database clusters, and demo some of the capabilities of …

Being a terminal fan myself, I usually find myself running queries in the mysql client instead of a UI interface as it is much faster. You get to see the results instantaneously.

One thing which is pretty tedious is editing a big query again after once running it as the whole multi-line formatted query now appears on a single line, thus reducing its readability.

But no problems, you can edit your query from a file and run the file from your mysql client terminal as many times as you want with as many edits.

To do so, follow the below steps:

1. Open your terminal and cd into the folder you want to store our sample mysql file. Then save your query in a sample file called my_query.sql

$ cd /path/to/folder
$ vim my_query.sql

Save a sample query like:

SELECT * FROM employees
WHERE type LIKE …

It was back in the 1980's when I was first introduced to Unix, the concept of scripting and in particular pipes. At that time I remember being really impressed by the concept of small utilities that could be easily strung together to quickly create tools. It was a great way to implement those one off jobs or things that would not warrant the development of a specific tool,  or so it seemed. I soon realised that actually, for some purposes, there was no need to go on a develop a bespoke tool to do the job, scripts were good enough. What does this have to do with MySQL and MaxScale?
The answer lies in a new feature that has been introduced in version 0.7 of MaxScale, filters. Filters are simple MaxScale plugins that can be inserted into the processing stream of a MaxScale service. One or more filters can be placed between the client application protocol module and the router module within MaxScale. The request data received from the client …

MySQL is proud to repeat our sponsorship of Texas Linuxfest

MySQL is a proud sponsor of the Texas Linuxfest and yes we will have Boogiebots at the booth!

and we will again be in Austin at the convention center with BoogieBots, heavy duty luggage tags, and the latest MySQL stickers. Last week Drupalcon was in the same hall and we are returning. Plus many local MySQL employees will be in the booth to talk MySQL. So drop by to say ‘howdy’, grab a BoogieBot, and let us know your view on who has the best BBQ(1) or beer(2) in Austin.

1. The Salt Lick
2. Jester King

Percona is glad to announce the release of Percona Server 5.6.17-66.0 on June 11, 2014. Downloads are available here and from the Percona Software Repositories.

Based on MySQL 5.6.17, including all the bug fixes in it, Percona Server 5.6.17-66.0 is the current GA release in the Percona Server 5.6 series. All of Percona’s software is open-source and free, all the details of …