(Todd Farmer) Transport Layer Security (TLS, also often referred to as SSL) is an important component of a secure MySQL deployment, but the complexities of properly generating the necessary key material and configuring the server dissuaded many users from completing this task.
Tag: Open Source
Frictionless MySQL installation
(Giuseppe Maxia) I saw an interesting post about the ability of installing MySQL 5.7 without changing existing tools and procedures. The post is a plea to make MySQL installation frictionless.
MySQL 5.7 default configuration: what’s new? (and what’s not)
(Aurimas Mikalauskas) Inspired by Peter Zaitsev’s post for MySQL 5.6, I decided to do a comparison between default configuration of MySQL 5.6 and 5.7. And I gotta tell you, some of the changes I found will have a huge impact on performance so make sure to get yourself familiar with them before you u
An update on default_password_lifetime
(Morgan Tocker) With MySQL 5.7, our goal is to be secure by default. This means that without having to change configuration settings or perform any additional steps, your fresh installation should be safe for production use.
MySQL 5.7 auto-generated root password
(Marcelo Altmann) You may have noticed something different when you install a fresh copy of MySQL 5.7 either via yum or using binary source. The root password is auto-generated.
MySQL Replication Defaults After 5.7
(Matt Lord) The default or “out of the box” experience is simply the experience for most people, so it’s critically important for us to ensure that the default configuration offers a good experience for the vast majority of cases.
Using Connector/J with Python
(Daniel van Eeden) With Python you would normally use MySQL Connector/Python or the older MySQLdb to connect from Python to MySQL, but there are more options.
SQL qualified names
(Peter Gulutzan) Bewilderedly behold this SQL statement:
MySQL 5.7 Multi-Source Replication – Automatically Combining Data From Multiple Databases Into One
(Tony Darnell) MySQL’s multi-source replication allows you to replicate data from multiple databases into one database in parallel (at the same time). This post will explain and show you how to set up multi-source replication. (WARNING: This is a very long and detailed post. You might want to grab a
MySQL 5.7 multi-source replication – automatically combining data from multiple databases into one
(Tony Darnell) MySQL’s multi-source replication allows you to replicate data from multiple databases into one database in parallel (at the same time). This post will explain and show you how to set up multi-source replication.