Calling all Bostonian MySQL professionals, experts, amateurs, and enthusiasts! On October 10, Baron Schwartz, VividCortex's founder and CEO, will join the Boston MySQL Meetup Group for a presentation titled "Meeting the Challenges of Monitoring in the Cloud."

As DBaaS and "serverless" systems increasingly underlie the current paradigm for app development, understanding the best ways to gain visibility into cloud-based systems is becoming ever more important. Between Baron's experience building VividCortex, a cloud-based database peformance management platform, and writing about best practices for database performance and scaling, he has a unique perspective for leading an insightful and interactive conversation about the current challenges of monitoring in the cloud -- and what those challenges might look like in the …

AGENDA:

In this webinar, we will discuss the practical aspects of migrating a database setup based on traditional asynchronous replication to multi-master Galera Cluster. We will discuss the benefits Galera provides and how traditional replication settings, architecture and practices can be converted to Galera Cluster. We will show the steps that are needed to perform the migration with limited or no downtime, and will demonstrate the procedure in practice using a live database with an actual workload.

Galera Cluster is trusted by thousands of users. Galera Cluster powers Percona XtraDB Cluster and MariaDB Enterprise Cluster. This is a webinar presented by Codership, the developers and experts of Galera Cluster.

DATE AND TIME:  Tue, Apr 12, 2016 10:00 AM – 11:00 AM PDT (Pacific time)

PRESENTERS: Philip Stoev, Sakari Keskitalo Codership

…

AGENDA:

In this webinar, we will discuss the practical aspects of migrating a database setup based on traditional asynchronous replication to multi-master Galera Cluster. We will discuss the benefits Galera provides and how traditional replication settings, architecture and practices can be converted to Galera Cluster. We will show the steps that are needed to perform the migration with limited or no downtime, and will demonstrate the procedure in practice using a live database with an actual workload.

Galera Cluster is trusted by thousands of users. Galera Cluster powers Percona XtraDB Cluster and MariaDB Enterprise Cluster. This is a webinar presented by Codership, the developers and experts of Galera Cluster.

DATE AND TIME:  Tue, Apr 12, 2016 11:00 AM -12:00 PM EEST (Eastern Europe time)

PRESENTERS: Philip Stoev, Sakari Keskitalo Codership

…

Many of you are coming to San Francisco next week for Oracle OpenWorld 2015 and many of you have already booked time on your calendars on Wednesday evening before the appreciation event. You are right — the Annual Oracle Bloggers Meetup, one of your favorite events of the OpenWorld, is happening at usual place and time!

What: Oracle Bloggers Meetup 2015.

When: Wed, 28-Oct-2015, 5:30pm.

Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103 ( …

We will have three presentations about new coming Galera Cluster 4.0.  The presenter will be Seppo Jaakola, CEO and co-founder of Codership and Philip Stoev, QA and Release Manager for Galera Cluster for MySQL

Big Transactions on Galera Cluster

22 September 3:10PM – 4:00PM @ Lausanne

Big and long term transactions have traditionally not behaved well in Galera Cluster. Large replication data sets have resulted in symptoms like elevated conflict rate, increased memory consumption, even OOM kill may happen, flow control pausing, cluster freezing… To deal with these issues, Galera users have been adviced to split large transactions in “reasonable size”. There is also cluster configuration option for rejecting too large transactions, as a safe guard.

This presentation explains the new large transaction replication method in Galera Cluster 4.0, which can now replicate transactions of any size, with minimal …

Oracle MySQL – News, Monitoring, Diagnostic and Backup Event Oracle MySQL (Session in French) – Lausanne / 29.09.2015

You work on MySQL and your needs evolve? ORACLE and dbi services invite you to a workshop dedicated to the monitoring, the diagnostic and the backup of your MySQL databases. We look forward to meeting you there!

• Lausanne, 29.09.2015 · 09:30 – 13:30 (Hôtel Mövenpick, Avenue de Rhodanie 4, CH-1000 Lausanne)
• Our speakers :
  
  M. …

Partitioning The advantage of partitioning is that we can drop / truncate the partitions which is real quick and done in seconds. It does lock the table (metadata lock) during this operation but only for few seconds. That duration depends on the number of pages in use in the buffer pool. With MySQL 5.6 it is possible to exchange the partitions , which helps in moving archived data to another table with similar structure.
   
Fully Automated archival / purge 

Consider a fast growing table which is partitioned to help the queries and help quick archival/purge. The queries if specify the partitioning filter can limit the search to relevant partitions and can considerably reduce the query time. Purging old data to reclaim the storage space can be readily achieved by truncating the old partitions. Archival has multiple techniques but with MySQL 5.6 exchanging the partitions make archival a real …

Codership will be joining OpenStack Summit Vancouver May 18-22. Visit our booth T52. Codership will have demo theater presentation about Galera in cloud, Time Warner Cable will tell how they use Galera and MariaDB gives best practises to use MariaDB Galera Cluster.

OpenStack Summit is the must-attend OpenStack event. The OpenStack Summit is a five-day conference for developers, users, and administrators of OpenStack Cloud Software. It’s a great place to get started with OpenStack.

Codership’s demo theater presentation at Vancouver:

Do More with Galera Cluster in Your OpenStack Cloud

Galera Cluster is already the way to achieve active/active HA for OpenStack back-end databases. Yet, it is possible to do a great deal more: Galera can provide cloud user with a fully redundant database cluster in place of the traditional …

The slides for my MySQL Security Essentials presentation at Percona Live 2015 MySQL Conference and Expo are now available.

In this presentation I discuss just how insecure legacy versions of MySQL are and what are the essential requirements for securing your installation on disk, via network and with user privileges. I provide recommendations for how to manage application access for your most important data asset.

Download PDF Presentation

This presentation describes the key security improvements in MySQL 5.6 and MySQL 5.7 as well as additional features provided in MariaDB 10.0 …

MySQL and Openstack deep dive, 14 April 11:30AM – 12:20PM @ Room 204

Peter Boros, Principal Architect, Percona

Most folks know that there are a number of different flavors of MySQL — standard MySQL, MariaDb, Percona XtraDb, MySQL Galera, Percona XtraDb Cluster, etc. In this talk, we hope to dispel some of these myths and give some clear information on what are the strengths and weaknesses of each of these flavors, what pitfalls to avoid when migrating between them, and what architectural information to take into account when planning your OpenStack MySQL database deployments. We will discuss replication topologies and techniques, and explain how the Galera Cluster variants differ from standard MySQL replication.

…