A much awaited release from the MariaDB project is now stable (GA) – MariaDB Galera Cluster 10.0.12. This is a complete merge of MariaDB 10.0.12 and Galera Cluster, with additional features and bug fixes. This gives you the entire power of Galera Cluster as well as the benefits of all the MariaDB 10 features.
This is the fourth release in the 10.0 Galera Cluster series, and for more changes, please review the …
[Read more]
In the previous post of this series we saw how you
could use mysqlrpladmin to perform manual
failover/switchover when GTID replication is enabled in MySQL
5.6. Now we will review mysqlfailover (version 1.4.3),
another tool from the MySQL Utilities that can be used for
automatic failover.
Summary
mysqlfailover can perform automatic failover if
MySQL 5.6′s GTID-replication is enabled.
--master-info-repository=TABLE.
One of the most frequent questions in our forums is about how to get the graphical integration when using Visual Studio with MySQL databases.
When developing applications with MySQL databases there are two basics products: a .net driver for MySQL, which is MySQL Connector/Net, and a tool to integrate all of the Visual Studio database oriented tools such as the Server Explorer window. These tools are designed to make a lot easier the creation and edition of MySQL databases when using an IDE like Visual Studio.
The MySQL Utilities Team is pleased to announce a new release that contains our newest features – SSL and configuration file support. These were added to release-1.5.0-alpha.
How can I make a secure connection to my server via Utilities?
Use the new SSL command-line options that are available for all utilities:
–ssl-ca : The path to a file that contains a list of trusted SSL
certificate authorities.
–ssl-cert : The name of the SSL certificate file to use for
establishing a secure connection.
–ssl-key : The name of the SSL key file to use for establishing a
secure connection.
Then just specify the appropriate values on the command-line with any other parameters.
How can I use configuration files?
If typing all of those SSL options seems tedious, you can specify this information in your configuration file and reference the file via a new syntax. You can also supply a path to …
[Read more]
I was recently asked about if MySQL Enterprise Backup would be
able to restore single databases.
My initial answer was that this was complicated, but might be
doable with the Transportable Table Space (TTS) option.
But first let's go back to the basics. A common way of working
with mysqldump is to get a list of databases and then loop
through the databases and dump the data and schema to a SQL file.
But both backups and restores will take a lot of time if the size
of the database grows. And it's a luke-warm backup at best
instead of a hot backup. So that's why we have MySQL Enterprise
Backup.
MySQL Enterprise Backup allows you to make a hot backup of InnoDB
tables by copying the datafiles while watching the InnoDB redo
log files.
On disk the data from the InnoDB storage engine consists of a
system tablespace (one of more ibdataX files), the redo log files
(iblogfileX) and zero or more …
MySQL for Visual Studio is a product including all of the Visual Studio integration previously available as part of Connector/Net. The 1.2.1 version is a beta release of this product which is feature complete but still can contain minor bugs and is not suitable for production environments.
Why do we need to recover InnoDB dictionary
c_parser is a tool from TwinDB recovery toolkit that can read InnoDB page and fetch records out of it. Although it can scan any stream of bytes recovery quality is higher when you feed c_parser with pages that belong to the PRIMARY index of the table. All InnoDB indexes have their identifiers a.k.a. index_id. The InnoDB dictionary stores correspondence between table name and index_id. That would be reason number one.
Another reason – it is possible to recover table structure from the InnoDB dictionary. When a table is dropped MySQL deletes respective .frm file. If you had neither backups nor table schema it becomes quite a challenge to recover the table structure. This topic however deserves a separate post which I write some other day.
Let’s assume you’re convinced …
[Read more]The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.1. This is a RC release for 1.3.x.
As this is a Release Candidate version the MySQL for Excel product can be downloaded only by using the product standalone installer at this link: http://dev.mysql.com/downloads/windows/excel/
Your feedback on this release candidate version is very well appreciated, you can raise bugs on the MySQL bugs page or give us your comments on the MySQL for Excel forum.
Percona is glad to announce the release of Percona Server 5.5.38-35.2 on July 2, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.38, including all the bug fixes in it, Percona Server 5.5.38-35.2 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the …
[Read more]This article discusses the storage (inline and external) of field data in the InnoDB storage engine. All fields of variable length types like VARCHAR, VARBINARY, BLOB and TEXT can be stored inline within the clustered index record, or stored externally in separate BLOB pages outside of the index record (but within the same tablespace). All of these fields can be classified as large objects. These large objects are either binary large objects or character large objects. The binary large objects do not have an associated character set, whereas the character large objects do.
Within the InnoDB storage engine there is no difference between the way character large objects and binary large objects …
[Read more]