I’m happy to speak at Percona Live Europe Amsterdam 2016 again this year (just look at the awesome schedule). On my agenda:
During Oracle OpenWorld, on Tuesday, September 20th,
at 7.00pm, the place to be will be at the MySQL Community
Reception !
OpenWorld attendees, members of local MySQL user groups, MySQL
users in the Bay Area – you’re all invited to Oracle’s MySQL
Community Reception to meet the MySQL Team !
Mingle with your peers, run into old friends from around the MySQL Community and/or meet the MySQL engineers to discuss the new features of MySQL 8.0, discuss performance with DimitriK or Group Replication with the replication team !
And don’t forget to chat with the MySQL Oracle ACEs that will be present too.
You can already register to the event’s page!
We are looking forward to see you there.
We are pleased to announce the next development release of MySQL Connector/J 6.0 which supports both JDBC 4.2 API and the new X DevAPI.
MySQL Connector/J 6.0.4 can be downloaded from the official distribution channels MySQL Downloads (see the “Development Releases” tab) and The Central repository. MySQL Connector/J source is also available on GitHub.
As always, we recommend that you check the CHANGES
file in the download archive and/or the release notes to be aware of …
.NET Core and MySQL Connector NET
It is exciting times! Recently Microsoft released .NET Core 1.0, a cross platform implementation of the .NET Framework. .NET Core works on Windows, Mac OS, and Linux and is fully open source!
We wanted to enable users of Connector/Net to be able to use .NET Core so we have been working hard for the past few months to make our provider fully .NET Core compatible. Because .NET Core does not yet fully replace the traditional .NET Framework, we will continue to ensure our provider is compatible with both frameworks.
Along with these exciting changes, we are also including in our most recent release support for Entity Framwork 7.0 and Entity Framework Core 1.0.
In this article I will explain how to install and setup .NET Core and how to make a simple sample that connects and retrieve data in screen.
Setup
Further information about …
[Read more]This post will tell you how to get MySQL passwords in plain text using the .mylogin.cnf file.
Since MySQL 5.6.6, it became possible to store MySQL credentials in an encrypted login path file named .mylogin.cnf, using the mysql_config_editor tool. This is better than in plain text anyway.
What if I need to read this password in plain text?
Perhaps because I didn’t save it? It might be that I don’t need it for long (as I can reset it), but it’s important that I get it.
Unfortunately (or intentionally),
mysql_config_editor
doesn’t allow it.
[root@db01 ~]# cat /root/.mylogin.cnf
????uUd????ٞN??3k??ǘ);??Ѻ0
?'?(??W.???Xܽ<'?C???ha?$
?? …[Read more]
Yesterday I was in Paris to attend a OpenTech Meetup related to MySQL.
You can find below the two presentations I gave (Warning: in French).
Haute disponibilité my sql avec group réplication from Frédéric Descamps
MySQL 5.7 & JSON – Nouvelles opportunités pour les dévelopeurs from Frédéric Descamps
The audience was very interested and I got …
[Read more]This release fixes two rare crashes and also we have upgraded the (MariaDB) C-connector to latest version (2.3.1). Most important this solves an issue when connecting to Amazon RDS using SSL. This was not possible before.
Changes as compared to MySQL GUI 12.2.5 include:
Bug Fixes:
* SQLyog was not able to connect to RDS instances using SSL
encryption. Attempting to do so returned the error “Failed
to connect to MySQL: SSL connection error: certificate verify
failed”.
* After having a connection open for very long time, SQLyog
could crash when closing this connection.
* Corrupted connection information in the ‘session
restore’-database could cause a crash. We had one
reproducible report of this, but please note that there is
no indication that SQLyog itself caused the corruption. It
may be due to a hardware error, for …
This blog post proposes modifications to the MySQL semi-sync
replication process in order to improve the overall consistency
and resilience of the system.
This is based on my previous blog post on Flexible Paxos and the related
paper Flexible Paxos: Quorum intersection
revisited by Howard, Malkhi and
Spiegelman.
Background Durability requirements have changed over the last few
years. Traditional systems considered their data Durable if it
was written to disk. However, this is not acceptable any more. In
today’s world, data is considered durable only if it has been
replicated to more than one machine.
MySQL is one of the few databases that has made an effort to
satisfy this form of durability. It supported …
In this post, I’ll point you to MyRocks Docker images with binaries, allowing you to install and play with the software.
During the @Scale conference, Facebook announced that MyRocks is mature enough that it has been installed on 5% of Facebook’s MySQL slaves. This has saved 50% of the space on these slaves, which allows them to decrease the number of servers by half. Check out the announcement here: https://code.facebook.com/posts/190251048047090/myrocks-a-space-and-write-optimized-mysql-database/
Those are pretty impressive numbers, so I decided to take a serious look at MyRocks. The biggest showstopper is usually binary availability, since Facebook only provides the source …
[Read more]Introduction
This is the final installment of a five part blog series to explore InnoDB internals by looking at the related tunable system variables. In this section we’re going to cover variables that relate to enforcing data consistency, and how index statistics are handled and stored.
Just like previous sections, I would like to emphasize something that was written in part one of this blog post series.
“I should note that while tuning recommendations are provided, this objective of this blog post series was NOT meant to be a tuning primer, but instead to explore the mechanics that each variable interacts with. As such I would like to advise against reading this guide and trying to fine tune all of the available InnoDB variables. System variable tuning is an exercise in diminishing returns, the most benefit you’ll get out of tuning your MySQL server will occur within the first 15 minutes of configuration. In …
[Read more]