The binary version for MySQL Cluster 7.2.14 has now been made available at http://www.mysql.com/downloads/cluster/.
A description of all of the changes (fixes) that have gone into MySQL Cluster 7.2.14 (compared to 7.2.13) is available from the 7.2.14 Change log.
The binary and source versions of MySQL Cluster 7.1.29 have now been made available at http://www.mysql.com/downloads/cluster/.
A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.29 (compared to 7.1.28) is available from the 7.1.29 Change log.
Since MariaDB aims to be a compatible/drop-in replacement to MySQL, its crucial that in 10.0 we support all the 5.6 options/system variables, else we have to clearly document them in the Knowledgebase article MariaDB versus MySQL – Compatibility.
To this extent, Sergey Vojtovich (svoj) has created MDEV-5277 as a tracker. There is also plenty of discussion on this topic at the maria-developers mailing list. I encourage current users of MySQL 5.6 to take a look at the list and comment either in Jira or on the mailing list to ensure that when …
[Read more]
Connector/NET 6.7 provides replication & load balancing
configuration that allows to connect to master/slaves
environments and at the same time balancing the request over all
the available server in this scenario. This post will show you
how to configure and use these new features on a console
application.
DBTA roundtable: Building a Geo-Distributed Database for Your Global Applications
THURSDAY, DECEMBER 5, 2013
11:00am PT / 2:00pm ET
In today's global economy, more and more businesses have employees,
(No, this is not a duplicate of the previous blog post I wrote.
It's for another position!)
As MySQL is thriving and growing, we're looking for an
experienced technical writer located in the UK or Ireland
to join the MySQL documentation team.
For this job, we need the best and most dedicated people around.
You will be part of a geographically distributed documentation
team responsible for the technical documentation of all MySQL
products. Team members are expected to work independently,
requiring discipline and excellent time-management skills as well
as the technical facilities and experience to communicate across
the Internet.
Candidates should be prepared to work intensively with our
engineers and support personnel. The overall team is highly
distributed across different geographies and time zones. Our
source format is DocBook XML. We're not just writing
documentation, but also handling …
What does it mean if MySQL returns the ‘Incorrect key file for table’ error for one of my queries? The answer is complicated and depends on which storage engine is returning the error. We have debugged two cases which we describe here.
File system out of space
When running the random query generator, one of the queries failed.
Query: SELECT * FROM (mysql . general_log AS table1 INNER JOIN INFORMATION_SCHEMA . INNODB_BUFFER_PAGE AS table2 ON ( table2 . SPACE = table1 . user_host ) ) ORDER BY table1 . thread_id LIMIT 168 failed: 126 Incorrect key file for table '/data/mysql7/performance_schema_vardir/tmp/#sql_6b8_17.MYI'; try to repair it
Since this query requires a sort, MySQL creates a hidden temporary table called ‘#sql_6b8_17.MYI’ to hold the intermediate results. While the query was executing, some operation performed on the MyISAM table returned an error. What could it be?
MySQL maps the …
[Read more]November 19, 2013 By Severalnines
The Severalnines team is pleased to announce the release of ClusterControl 1.2.4. This release contains key new features along with performance improvements and bug fixes.
We have outlined some of the key features below. For additional details about the release:
The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.6. This is a Beta release. See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 10.0? page in the AskMonty Knowledgebase for general information about the MariaDB 10.0 series.
[Read more]Every MySQL DBA has at least peeked at a mysql.user table. But with the latest versions come some changes that many may have not noticed. The last three of the forty three columns — plugin, authentication_string, and password_expired — fields deserve a closer look.
First off, lets look at the entire table that is the output of
DESC mysq.user run in MySQL Workbench and only the last
few lines are shown for the sake of clarity.
The password_expired field is simply set to ‘N’ if the
password is expired.
ALTER USER 'joeuser'@'localhost' PASSWORD
EXPIRE;
The use will receive a message that their password has expired
and they need to set a new one IF their client supports resetting
password. The account is is “sandbox” mode where the use has …
