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:
[Read more]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:
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 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
…
[Read more]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 …
[Read more]
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.
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 …
[Read more]MySQL 5.6.19 was recently released (it is the latest MySQL 5.6, is GA), and is available for download here.
I should actually call this post “5.6.18 and 5.6.19 Overview and Highlights”.
The 5.6 “Release Notes” Index provides an entry/changelog for 5.6.18 and says it was released 2014-04-11. However, it’s not available in the community download archives. This isn’t mentioned in the 5.6.18 changelogs, but it is in the 5.6.19 changelogs, where it says:
“There is no MySQL …
[Read more]
