Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on March 5th 2015. Binaries are available from downloads area or from our software repositories.
Based on Percona Server 5.6.22-72.0 including all the bug fixes in it, Galera Replicator 3.9, and on Codership wsrep API 25.8, Percona XtraDB Cluster 5.6.22-25.8 is now the current …
[Read more]MariaDB 10.0.17 was recently released, and is available for download here:
https://downloads.mariadb.org/mariadb/10.0.17/
This is the eighth GA release of MariaDB 10.0, and 18th overall release of MariaDB 10.0.
For the most part, there are not a whole lot of new changes to report for this release, but there is a new version of the Audit Plugin and many other engines have been updated as well.
Here are the main items of note:
MariaDB 10.0.16 was recently released (~1.5 months ago on 1/27/2015 – sorry for the delay on my end – I was just extra busy in my spare time recently), and is available for download here:
https://downloads.mariadb.org/mariadb/10.0.16/
This is the seventh GA release of MariaDB 10.0, and 17th overall release of MariaDB 10.0.
For the most part, there are not a whole lot of changes to report for this release, but there are 2 enhancements of note – one being the JSON table type (still *experimental*) and the other a new variable to aid with index statistics calculations on large tables, as well as some security fixes.
Here are the main items of note:
When looking at Percona live Santa Clara 2015 agenda I saw two intriguing conferences : - JSON support in MySQL 5.7 – Docstore: document database for MySQL at Facebook
Both conference are talking about supporting a native JSON type in MySQL ! This sounds really great. I have never seen any blog post or github [...]
The MySQL Utilities Team is pleased to announce a new alpha
release of MySQL Utilities. This release includes a number of
improvements for useabilty, stability, and a few enhancements. A
complete list of all improvements can be found in our release notes.
New Enhancements!
This release represents a stable release of the product. Along
with several defect patches, we also include the following
enhancements.
Improved support for MySQL 5.7 early releases
Improved output for mysqldbcompare
Improved SSL support
New Utilities!
This release also has three new utilities for you to try
out:
mysqlslavetrx - skip transactions on one or more slaves to solve
errant transactions and consistency errors - …
The MySQL Utilities Team is pleased to announce the general
availability (GA) release of MySQL Utilities. This release
includes a number of improvements for useabilty, stability, and a
few enhancements. A complete list of all improvements can be
found in our release notes.
New Enhancements! This release represents a stable release
of the product. Along with several defect patches, we also
include the following enhancements.
How Can I Download MySQL Utilities?
You can download MySQL Utilities 1.5.2 GA from the following link
using one of the pre-built installation repositories including a
source download.
…
As the systemd integration keeps on getting forward. It is hardly to be ignored by us MySQL folks :)
Lets have a look into a simple problem, you are not going to solve like you used to solve it. (At least on Centos7 installing the MariaDB package)
Increasing table_open_cache was only a configuration
issue. As mysqld was started as root and then
switching to the unix user mysql. On Centos7 this
was not working anymore. As MariaDB/MySQL ist startet with a
service file starting the process as user mysql:
[Service]
Type=simple
User=mysql
Group=mysql
..
As not root (having the right capability) it will be not able to change the open files limit. In the error log you are going to find something like:
150303 11:57:02 [Warning] Changed limits: max_open_files: 1024
max_connections: 214 table_cache: 400
Reading the …
[Read more]
I've completed a new release of the Connector/Arduino! The new
release contains some minor improvements as follows.
Enjoy!
Full text is a critical point when it comes to mysql. It used to have that feature in MyISAM but that’s not really maintained anymore nor it is advised to use unless you have a very specific use case in which it might make sense. There are 3rd party solution which takes the problem away (Lucene, Sphinx, Solr, ElasticSearch) but all bring extra complexity to your setup which has its own cost. So do you need to give up on fulltext search if you’re using MySQL + InnoDB? No! Definitely not.
Alternatives for full-text search in MySQL
I have an live database with 9000+ products with category, brand and short description which is perfect to test my searches on. I’m going to run the queries many times and use profile information to collect more granular and accurate timing information.
LIKE
Well… It’s not a real alternative but just for a sec see how well it behaves.
SELECT SQL_NO_CACHE b.name, …[Read more]
Talking with Percona Live attendees last year I heard a couple of common themes. First, people told me that there is a lot of great advanced content at Percona Live but there is not much for people just starting to learn the ropes with MySQL. Second, they would like us to find a way to make such basic content less expensive.
I’m pleased to say we’re able to accommodate both of these wishes this year at Percona Live! We have created a two-day intensive track called “MySQL 101” that runs April 15-16. MySQL 101 is designed for developers, system administrators and DBAs familiar with other databases but not with MySQL. And of course it’s ideal for anyone else who would like to expand their professional experience to include MySQL. The sessions are designed to lay a solid foundation on many aspects of MySQL development, design and …
[Read more]