Correctness of data comes in different forms. One is referential integrity, also known as foreign keys. Another is CHECK constraints. While MySQL supports foreign keys, it doesn’t support CHECK constraints. Today we will look at three ways to emulate them:

• triggers
• views
• generated columns (new in MySQL 5.7)

This is also relevant to another SQL feature: DOMAIN, which, in short, is a user-defined type composed of a base type (INT, CHAR, …), a default value, and a constraint on acceptable values – the latter being some simple sort of CHECK constraint.…

Whenever you need to increment or decrement value of column in database then you do not need to first fetch that record and then update so that way we will make long code and very hard code so basically you can increment and decrement by using increment and decrement statment of laravel query

UPDATE: Starting with MySQL 8.0.16 we have introduced the new minimal tar ball distribution. Take a look here.

MySQL is known and famous for it’s simplicity and small size, especially compared to other RDBMSs. But what if you want to deploy on tiny hardware? I mean something even smaller than RaspberryPi? I tested three steps to make the MySQL footprint as small as possible. All my tests were compiled for Oracle Linux 7 on x64 platform. I did not test any ARM cross compile. And these are the steps:

1. Compile my own binary
2. Remove all unnecessary tools/files
3. Strip symbol information from binary

Let’s take a closer look at the tree steps.
Compile my own binary MySQL is available as a source release. Using that you can configure the make process. That is documented pretty …

MEB 3.12.0 and above support cloud backup and restore using OpenStack-compatible object stores ("Swift"). This allows MySQL database users with Oracle Storage Cloud account to take backups and store them directly in the cloud and restore them from there.

The following steps illustrate how to set up and use MEB with Oracle Storage Cloud :

1) Create Oracle Storage Cloud account at https://cloud.oracle.com/storage . Once service gets activated, make a note of the following credentials that will be required in further steps :

• Username

• Password

• Identity domain name

• Service Instance Name : Customer-specified name of the service instance

…

Mon, 2016-02-01 20:39wlad

The recent release of MariaDB 10.1.11 contains two new authentication plugins:

Named pipe plugin

This plugins works only if user logs in using named pipe. It uses the operating system's username of currently logged on user running the client program. The plugin mirrors functionality of the already existing Unix socket authentication plugin on Windows.

GSSAPI plugin

For this plugin, the more correct name would be GSSAPI/SSPI …

We're excited to announce that VividCortex support for Windows is now available! With VividCortex, Windows users can benefit from the first unified suite of performance monitoring tools specifically designed for today's large-scale, polyglot persistence tier. 

We know that Windows support is vital for many large organizations with sweeping, established systems. Now, government, health care, university, and finance organizations who rely on Windows can employ the powerful insight of VividCortex.

With features including 1-second granularity, behavior-based monitoring, chat-integration, and custom dashboards, VividCortex has the ability to monitor hundreds of thousands of instances in MySQL, PostgreSQL, Redis, MongoDB, and Amazon Aurora. It’s the tool that lets IT teams see their databases with new confidence and reach their highest levels of efficiency and precision.

We're especially excited to serve …

I have used many tools starting with MMM to be able to manage MySQL replication clusters. Some of the tools need more tools and complex HA solutions such as Pacemaker and Corosync, or Zookeeper. While other tools do not do the failover well which leaves the slaves in an inconsistent state, MMM would be an example. And I must say that of all the tools I love MySQL Master HA (MHA) the most. MHA is a great tool to manage MySQL replication clusters for the purpose of HA. The most important thing about MHA is that it tries to take all the necessary steps to do a MySQL master failover in a way that provides as much data consistency as possible. The slave promotion also tends to be very quick, on average I have seen it take 10 to 15 seconds. It is also very easy to deploy unlike some of the other complex HA solutions. I would highly recommend reading about the architecture of MHA on its wiki: https://code.google.com/p/mysql-master-ha/wiki/Architecture Why …

This Log Buffer Edition covers various useful tips and tricks from blogs for Oracle, SQL Server and MySQL.

Oracle:

• pstack(or thread stack) for Windows to diagnose Firefox high CPU usage
• With the ever-changing browser landscape, we needed to make some tough decisions as to which browsers and versions are going to be deemed “supported” for Oracle Application Express.  There isn’t enough time and money to support all browsers and all versions, each with different bugs and varying levels of support of standards.
• Are you effectively using Java SE 8 streams …

The MySQL team has been maintaining a MySQL image on Docker. They have been listening to requests from the community and reacting quickly. So far, they have fixed two bugs that I reported and introduced a feature request that I suggested to make the server more secure.

Thanks, folks!

My latest request was about password management in a MySQL container. I have mentioned in previous posts the compatibility problems introduced by MySQL 5.7 security enhancements. Let me recap the main issues here:

MySQL is secure by default.

The recommended method to install MySQL is mysqld --initialize, which will generate a random password that the DBA will then use to access the …

I have used many tools starting with MMM to be able to manage MySQL replication clusters. Some of the tools need more tools and complex HA solutions such as Pacemaker and Corosync, or Zookeeper. While other tools do not do the failover well which leaves the slaves in an inconsistent state, MMM would be an example.
And I must say that of all the tools I love MySQL Master HA (MHA) the most. MHA is a great tool to manage MySQL replication clusters for the purpose of HA. The most important thing about MHA is that it tries to take all the necessary steps to do a MySQL master failover in a way that provides as much data consistency as possible. The slave promotion also tends to be very quick, on average I have seen it take 10 to 15 seconds. It is also very easy to deploy unlike some of the other complex HA solutions.

I would highly recommend reading about the architecture of MHA on its wiki: …