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: …

因公司业务发展迅速，部门现在招两个mysql dba 同学，目前本人在平安健康互联网（平安好医生）数据团队，负责数据库的整体规划，想来的同学可以发简历到我的邮箱 ylouis83@gmail.com 靠谱的公司靠谱的团队 ：）

关于公司：

国内最大的互联网医疗平台，提供全品类互联网医疗服务，目前国内前三大的a轮估值

Some time when you are open any link your website then browser display following massageh2 stylemargin0pxpadding0pxNot Foundh2span stylemargin0padding0The requested URL testhtml was not found on this serverspanspan stylemargin0padding0Additionally a 404 Not Fo