Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 36089 10 Older Entries
London in May 2016
+0 Vote Up -0Vote Down

I’m happy to be back in London in May 2016, to talk at two events:

  1. The London MySQL Meetup GroupMonday May 9 – 6.30 PM – 9.00 PM – options for High Availability in the ecosystem that one would consider today. This is a cut down from my Percona Live tutorial, which had about 88 registered attendees and about that amount showed up and asked questions even through the break and after. I had a lot of fun, and I expect I will have similar fun in London talking about this area that has changed a lot in …
  [Read more...]
My top author list for Planet MySQL
+0 Vote Up -0Vote Down

Who are the top individual authors of influential recent posts to planet MySQL?  The planet MySQL page includes a list of the top 20 authors as well as a list of the top 10 vendor blogs.  However, since posts to the vendor blogs make up at least 1/4 of all of the posts, and the authors of vendor blog posts are not included in the top author list, I decided to compute my own top author list.  I include the hidden authors from the vendor blogs when computing my top author list.

The first problem is to identify the hidden authors for posts from each vendor blog.  This requires that the author information be extracted …

  [Read more...]
Video of my Percona Live Talk: Why would I run MySQL/MariaDB on POWER anyway?
+0 Vote Up -0Vote Down

Good news everyone! There’s video up for the talk I gave at Percona Live in April 2016 up: Why would I run MySQL/MariaDB on POWER anyway?

The talk is a general overview of POWER and why MySQL/MariaDB may be a good fit.

InnoDB flushing and Linux I/O
+0 Vote Up -0Vote Down

Since documentation is not very clear to me on the topic of InnoDB flushing in combination with Linux IO (specifically the write system call), I decided to put together this article in hopes of shedding some light on the matter.

How Linux does I/O

By default, the write() system call returns after all data has been copied from the user space file descriptor into the kernel space buffers. There is no guarantee that data has actually reached the physical storage.

The fsync() call is our friend here. This will …

  [Read more...]
OpenCPS: Vietnam's Public Sector goes Open Source
+0 Vote Up -0Vote Down

Thu, 2016-05-05 15:33colin

I'm now in Hanoi, Vietnam, for the launch of OpenCPS. What, might you ask, is OpenCPS? OpenCPS translates to Open Core Public Services, as Vietnam is providing online public services and OpenCPS should sit at its core. Naturally, all of this will be open source, and AGPL licensed. OpenCPS is the first open source project to realize the development of e-government services in Vietnam.

Why does this matter to us? Because at the core of its infrastructure is of course, MariaDB Server as the database of choice, with Red Hat being the Linux provider of choice.

…  [Read more...]
Log Buffer #472: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This Log Buffer Edition takes into account blog posts from Oracle, SQL Server and MySQL.

Oracle:

Enterprise Manager Support Files 101- The EMOMS files

From time to time we see a complaint on OTN about the stats history tables being the largest objects in the SYSAUX tablespace and growing very quickly.

Delphix replication and push …

  [Read more...]
How to Deal with MetaData Lock
+1 Vote Up -0Vote Down

What is MetaData Lock?

MySQL uses metadata locking to manage concurrent access to database objects, and to ensure data consistency when performing modifications to the schema: DDL operations. Metadata locking applies not just to tables, but also to schemas and stored programs (procedures, functions, triggers, and scheduled events).

In this post I am going to cover metadata locks on tables and triggers, that are usually seen by DBAs during regular operations/maintenance.

Kindly refer to these 4 different connections to MySQL Instance:

 

The screenshot shows that the uncommitted transaction may cause metadata lock …

  [Read more...]
Planets9s - Sign up for our ClusterControl New Features Webinar
+0 Vote Up -0Vote Down

Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.

Sign up for our ClusterControl New Features Webinar

Join us for this new webinar on Tuesday, May 24th, where we’ll be discussing and demonstrating the latest version of ClusterControl, the one-stop console for your entire database infrastructure. We’ll be introducing some cool new features for MySQL and MongoDB users in particular as well as walk you through the work we’ve recently …

  [Read more...]
Announcing Galera Cluster 5.5.49 and 5.6.30 with Galera 3.16
+0 Vote Up -0Vote Down

Codership is pleased to announce the release of Galera Cluster 5.5.49 and 5.6.30 with Galera Replication library 3.16, implementing wsrep API version 25.

The library is now available as targeted packages and package repositories for a number of Linux distributions including RHEL, Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on …

  [Read more...]
Docker for Mac beta and MySQL - First impressions
+2 Vote Up -0Vote Down

Using Docker for development is a great way of ensuring that what you develop will be the same that you deploy in production. This is true for almost everything. If you develop on Linux, the above statement holds. If you develop on a different operating system (OSX or Windows) there are several restrictions.

I showed one of those issues in a recent article (MySQL and Docker on a Mac: networking oddity.) When you want to export a port from a service running in the container, the …

  [Read more...]
Showing entries 1 to 10 of 36089 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.