Auditing your database means tracking access and changes to your data and db objects. The Audit Log Plugin has been shipped with Percona Server since 5.5.37/5.6.17, for a little over 12 months. Prior to the Audit Log Plugin, you had to work in darker ways to achieve some incarnation of an audit trail.

We have seen attempts at creating audit trails using approaches such as ‘sniffing the wire’, init files, in-schema ‘on update’ fields, triggers, proxies and trying to parse the traditional logs of MySQL (slow, general, binary, error). All of these attempts miss a piece of the pie, i.e. if you’re sniffing tcp traffic you’ll miss local connections, parsing binary logs you’re missing any reads. Your reasons for audit logging might be down to compliance requirements (HIPAA, PCI DSS) or you may need a way to examine database activity or track the connections incoming.

Over the past …

At our August meetup, our guest Calvin Sun gave a presentation on life @ Twitter. Some of the details of his presentation included:

Download PDF Presentation

• Information on existing data and storage solutions in operation.
• MySQL 5.6 performance improvements over MySQL 5.5
• The short upgrade cadence, most servers are running 5.6.26.
• Various patches and optimizations developed by Twitter to run at scale.
• Cotton on Mesos
• Best practices

Download Introduction Slides …

Download MariaDB 10.1.7

Release Notes Changelog What is MariaDB 10.1?

MariaDB APT and YUM Repository Configuration Generator

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.7. This is a Release Candidate (RC) release.

See the …

The MySQL server supports a variety of client connection methods. To summarize: you have TCP/IP (v4 and v6) on all OSes (with or without TLS/SSL encryption), Unix Domain Sockets on Unix/Linux, and Named Pipes and/or Shared Memory on Windows.

Each of these connection methods has its own set of pros and cons: speed, security, portability, and ease-of-use.…

A database replication topology is never written in stone - it evolves along with your application and data. Changes are usually needed to help scale out, to distribute your database across multiple regions or data centers, or to perform software/hardware maintenance operations. The initial setup of a replication topology is simple, but as soon as you start changing it, things can quickly get complex. 

How do we fail-over our replication masters and slaves without affecting the availability and consistency of our data?

In this webinar, we will discuss how to perform replication topology changes in MySQL / MariaDB, and what the failover process may look like. We’ll also discuss some external tools you may find useful when dealing with those operations.

DATE, TIME & REGISTRATION

Europe/MEA/APAC
Tuesday, September 29th at 09:00 BST / 10:00 CEST (Germany, France, …

http://blog.booking.com/abstracting_binlog_servers_and_mysql_master_promotion_wo_reconfiguring_slaves.html

Follow the link above to read my latest article on the Booking.com Developer Blog.  It is about Binlog Servers and how to promote a slave as the new master without reconfiguring all slaves.

This is also a good opportunity to remind you of my next talks:

I’ll be giving a talk about Binlog

There are cases where we need to implement MySQL partitioning, or at least test if it is an option to solve an issue. However, how are we able to test it when the table on our production environment has hundreds of millions of rows, several composite indexes and/or the size on disk is hundreds of gigabytes?

Testing environments usually don’t have all the data that production has and if they have, probably you are not testing all the use-cases at a database level. Therefore, is it possible to test MySQL Partitioning on production impacting as less as possible?

When we execute pt-online-schema-change, it creates a table, triggers, and then copies the data. As we are going to test partitioning we are going to need both tables – with and without partitioning – and we are going to use triggers to keep both tables consistent. A good thing about changing a table to use partitioning is that, usually, …

Originally Posted by Adam Bird

There needed to be a better way for agents in Zendesk to track the tasks that had been assigned them. Using the Cronofy calendar API we created an app that keeps those assignments synchronized with the agent’s calendar.

This post shares our learnings from interacting with the Zendesk API, hopefully to help you with your own Zendesk project.

The Ruby source code for our integration is also available.

When a Ticket is a Task

Tickets are the core entity in the Zendesk domain. Tasks are just Tickets of type : ‘task’. This gives them an additional attribute due_at.

We also need to track the status of the ticket to know when it’s …

There needed to be a better way for agents in Zendesk to track the tasks that had been assigned them. Using the Cronofy calendar API we created an app that keeps those assignments synchronized with the agent's calendar.

This post shares our learnings from interacting with the Zendesk API, hopefully to help you with your own Zendesk project.

The Ruby source code for our integration is also available.

When a Ticket is a Task

Tickets are the core entity in the Zendesk domain. Tasks are just Tickets of type : 'task'. This gives them an additional attribute due_at.

We also need to track the …

Thanks to everyone who joined us for our recent live webinar on ‘Schema Changes for MySQL Replication & Galera Cluster’ led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the webinar are now available to watch and read online via the links below.

Watch the replay

Become a MySQL DBA - Webinars - Schema Changes for MySQL Replication & Galera Cluster (Replay) from Severalnines AB

Read the slides

Become a MySQL …