Earlier I wrote about check constraints
when MySQL 8.0.16 was released. But this week I noticed two
different folks having similar problems with them. And sadly it
is 'pilot error'.
The first was labeled MYSQL 8.0.17 CHECK not working even though it has
been implemented and a cursory glance may make one
wonder what is going on with the database.
The table is set up with two constraints. And old timers will
probably mutter something under their breath about using ENUMs
but here they are:
JOB_TITLE varchar(20) CHECK(JOB_TITLE IN ('Lecturer',
'Professor', 'Asst. Professor', 'Sr.
Lecturer')),
…
Aug
23
2019
Aug
23
2019
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the
release of
MySQL Notifier version 1.1.8, the latest addition to the
MySQL
Installer for Windows.
MySQL Notifier enables developers and DBAs to easily monitor,
start and
stop all their MySQL database instances. It provides a
familiar
Microsoft SQL Server look and feel and integrates with MySQL
Workbench.
MySQL Notifier is installed using the MySQL Installer for
Windows.
The MySQL installer comes in 2 versions
– Full (400 MB) which includes a complete set of mysql products
with
their binaries included in the download
or
– Web (18 MB – a network install) which will just pull the
MySQL
Notifier over the web and install it when run.
You can download MySQL Installer from our official Downloads …
Aug
22
2019
Percona announces the release of Percona Server for MySQL 5.7.27-30 on August 22, 2019 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.27, including all the bug fixes in it. Percona Server for MySQL 5.7.27-30 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free.
Bug Fixes:
- Parallel doublewrite buffer writes must crash the server on an I/O error occurs. Bug fixed …
Aug
22
2019
Do you want to run Galera Cluster in the Microsoft cloud? Why not
learn to setup a 3-node Galera Cluster using Microsoft Azure
Compute Virtual Machines, and run it yourself. In this webinar,
we will cover the steps to do this, with a demonstration of how
easy it is for you to do.
In addition, we will cover why you may want to run a 3-node (or
more) Galera Cluster (active-active multi-master clusters)
instead of (or in addition to) using Azure Database for MySQL or
MariaDB. We will also cover cost comparisons.
Join us and learn about storage options, backup & recovery, as well as monitoring & metrics options for the “roll your own Galera Cluster” in Azure.
EMEA webinar 10th of September 1-2 PM CEST (Central European
Time)
JOIN THE EMEA WEBINAR
USA webinar 10th of September 9-10 AM …
[Read more]
Aug
22
2019
Author: Robert Agar
The monitoring of IT systems is an important practice that should be in place in any complex computing environment. It provides a window into the inner-workings of the systems and applications with which a business or organization operates. The statistics produced by a monitoring platform can be used to optimize systems, enhance the user experience or plan for capacity upgrades.
A viable monitoring platform is designed with the ability to generate and send alerts. This feature increases the utility of the tool by introducing the possibility of creating immediate notifications to address potential issues or inconsistencies in the systems being observed. Alerts are routed to individuals or teams who can take action to further investigate or resolve the problems. Let’s take a closer look at why you want alerts to be created and how your organization should handle them.
Why …
[Read more]
Aug
21
2019
ProxySQL 2.0.6, released by ProxySQL, is now available for download in the Percona Repository along with Percona’s proxysql-admin tool.
ProxySQL is a high-performance proxy, currently for MySQL and database servers in the MySQL ecosystem (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues.
This release includes ProxySQL 2.0.6 which introduces many new features and enhancements and also …
[Read more]
Aug
21
2019
Excellent….Work like charm !!!
Aug
21
2019
One of the perks of working on MySQL is that the code can compile (and has been compiled) on pretty much all of the modern (and no so modern) C/C++ compilers and all the modern OSes. This enables each individual developer to choose their “weapon”: pick the OS and the compiler they feel best about.…
Facebook Twitter LinkedIn
Aug
21
2019
While building my student image on Fedora 30, I installed the MySQL PHP Connector (php-mysqlndrp) but neglected to install the Python Connector. This adds the installation and basic test of the Python Connector to the original blog post.
You use the following command with a wildcard as a privileged user. The wildcard is necessary because you need to load two libraries to support Python 2.7 and 3.7, which are installed on Fedora 30. You also need to be the root user or a user that is found in the sudoer’s list:
yum install -y mysql-connector-python*
Display detailed console log →
Last metadata expiration check: 0:35:46 ago on Tue 20 Aug 2019 05:36:29 PM MDT. Dependencies resolved. …[Read more]
Aug
20
2019
Percona announces the release of Percona Server for MySQL 5.6.45-86.1 on August 20, 2019. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository.
Based on MySQL 5.6.45, and including all the bug fixes in it, Percona Server for MySQL 5.6.45-86.1 is the current GA release in the Percona Server for MySQL 5.6 series. …
[Read more]