In the past five posts of the blog series, we covered deployment of clustering/replication (MySQL / Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health, how to make your setup highly available through HAProxy and MaxScale and in the last post, how to prepare …

Here’s a step-by-step guide on how to invert roles for master and slave so you can perform a master server upgrade, and then switch roles back to the original setup.

* While following this guide consider server-A as your original master and server-B as your original slave. We will assume server-B already produces binlogs and that both nodes have log-slave-updates=1 in my.cnf

Check this following link for more details on log-slave-updates: https://dev.mysql.com/doc/refman/5.6/en/replication-options-slave.html#option_mysqld_log-slave-updates

1. Prepare the original Slave to invert roles.

Make sure the slave is …

Sweden’s self-funded database provider powers past 2014 revenues and grows team

Stockholm, Sweden and anywhere else in the world - 01 DECEMBER 2015 - Severalnines, a database automation pioneer which helps businesses deploy and manage open source databases in any environment, closes 2015 on a high with new customer wins and new hires.
 
Momentum highlights:

• Over 100% sales growth achieved early in first half of 2015
• 150+ enterprise customers, 8,000+ community users
• New enterprise accounts wins such as the European Broadcast Union, European Gravitational Observatory, BT Expedite and French national scientific research centre, CNRS
• Hired Gerry Treacy, former MongoDB executive, as Vice President of Sales
• Added support for PostgreSQL to ClusterControl alongside MySQL …

The client library — libmysqlclient — is part of the same source code repository as the server. It comes both as a dynamic link library (.so), also called a shared library, and as a static link library (.a). During the 5.7 development cycle, we’ve made several improvements to the library, which has resulted in a bump from ABI version 18 to version 20.…

The Call for Papers is over !

Thank you to all of you who have submitted a talk for the Fosdem 2016 MySQL & Friends devroom !

We received 40 talks that will be sent to the committee for review. Then as soon as the talks we be rated, we will contact all the submitters to let them know if their talk(s) was approved or not.

Be patient ! ;-)

Thank you again, this will be an awesome event !

Recently, I was working on a MySQL support ticket where a customer was facing an issue while transporting tablespace from MySQL 5.6 to MySQL 5.7.
After closely reviewing the situation, I saw that while importing tablespace they were getting errors such as:

ERROR 1808 (HY000): Schema mismatch (Table flags don't match, server table has 0x10 and the meta-data file has 0x1)

After some research, I found that there is a similar bug reported to MySQL for this issue (https://bugs.mysql.com/bug.php?id=76142), but no solution is mentioned. I tested the scenario locally and found a solution …

Adaptive Fault detection is a prime example of how efficiently VividCortex can help you understand and optimize your system. We define a “fault” as a special kind of system stall: a period during which applications are asking the server to perform a great deal of work, but that work is getting bottlenecked and therefore not completing.

This understanding of faults is based on Queueing Theory (if you need a refresher on QT, be sure to check out our recent and highly accessible ebook, Everything You Need to Know About Queueing Theory); we detect faults by using advanced statistics and machine learning. VividCortex’s Fault Detection is completely adaptive and self-tuning – it doesn’t require any configuration. The program can detect faults as short as one second in duration. Even the most attentive user would likely fail to notice system stalls so …

The Percona Live Data Performance Conference 2016 isn’t until 18-21 April 2016, but community voting is now open. So if you’re going, and want to see lots of MariaDB talks, please click on the buttons below and vote! You have to be logged in to the Percona site to vote. Once logged in, scroll to […]

The post MariaDB Talks at Percona Live Data Performance Conference 2016 appeared first on MariaDB.org.

I’ve made two session proposals for Percona Live conference:

• Window functions in MariaDB covers Window functions, a new feature in MariaDB 10.2. As far as I know, this the first attempt to have a talk about this feature.
• Exploring MariaDB Query Optimizer with ANALYZE for statements is about making use of ANALYZE (actually, ANALYZE FORMAT=JSON mostly) from …

In the last blog I spoke of CPU counters. Now, I'll talk of Memory counters.

MEMORY Counters (CIM_PhysicalMemory class, Win32_PerfFormattedData_PerfOS_Memory class, Memory Performance Information ...): Note: I introduced the notion of samples and how to fetch them using NextValue() so I will occasionally omit $var.NextValue() going forward.

Let me note here that if you thought previously described performance classes were complicated, you are now entering the realm of black magic ;-) There is a good …