MySQL Replication and GTID-based failover - A Deep Dive into Errant Transactions

Twitter icon
Facebook icon

For years, MySQL replication used to be based on binary log events - all a slave knew was the exact event and the exact position it just read from the master. Any single transaction from a master may have ended in different binary logs, and in different positions in these logs. It was a simple solution that came with limitations - more complex topology changes could require an admin to stop replication on the hosts involved.

Press Release: Severalnines primed for even stronger customer growth

Twitter icon
Facebook icon

Severalnines, a database clustering pioneer which helps businesses automate and manage highly available open source SQL and NoSQL database clusters, reported over 100 percent sales growth last year.

A DevOps Guide to Database Infrastructure Automation for eCommerce - Replay & Slides

Twitter icon
Facebook icon

Thanks to everyone who attended and participated in last week’s webinar on ‘A DevOps Guide to Database Infrastructure Automation for eCommerce’. If you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

ClusterControl Template for Zabbix

Twitter icon
Facebook icon

We’re delighted to announce a ClusterControl Template for Zabbix, so Zabbix users can now get information about the status of their database clusters, backups and alarms. We have previously published integrations with other monitoring systems including Nagios and PagerDutyThis template is built using the ClusterControl REST API to retrieve monitoring data.

Resources for Database Cluster: New DevOps Guide Webinar, Load Balancing for MySQL Replay and More ...

Twitter icon
Facebook icon

Check Out Our Latest Technical Resources for MySQL, MariaDB & MongoDB Clusters

Like every month, we have created new content and tools for you; here is a summary of what we’ve published. Please do check it out and let us know if you have any comments or feedback.

How to Deploy High Availability CloudStack with MariaDB Galera Cluster

Twitter icon
Facebook icon

Apache CloudStack is a turnkey orchestration platform to deliver IaaS clouds. As a cloud infrastructure scales to hundreds or thousands of servers, with production environments supporting multiple applications and services, high availability becomes a key requirement. Just as for OpenStack, it is possible to deploy the CloudStack management server in a multi-node installation. Since the management server uses a MySQL database to store the state of all its objects, the database could become a single point of failure. The CloudStack manual recommends MySQL replication with manual failover in the event of database loss. We believe there is a better way.

HowTo: Offline Upgrade of Galera Cluster to MySQL 5.6 or MariaDB 10

Twitter icon
Facebook icon

MySQL 5.6 has an extensive list of new features and changes, so upgrading from a previous version can be risky if not tested extensively. For this reason, we recommend our users to read and understand the changes before doing the upgrade. If you are on older MySQL versions, it is probably time to think about upgrading. MySQL 5.6 was released in February 2013, that’s almost two years ago!

New year, new job opportunity: we’re hiring (yet again)! Our sales team is expanding!

Twitter icon
Facebook icon

We're looking for an enthusiastic International Inside Sales Representative (preferably in North American / European timezones) to join our small and driven sales team. This position is full-time and pay is negotiable. The hours are flexible and work can be done remotely; in fact, it will need to be done remotely, we all work from home ;-)

 

High Availability File Sync and Share - Deploying ownCloud with Galera Cluster for MySQL and GlusterFS

Twitter icon
Facebook icon

Cloud storage is hot. Dropbox, Apple iCloud, Google Drive, Microsoft SkyDrive and Amazon Cloud Drive all offer cloud sharing platforms where you can store documents in the cloud and access them from all your devices. For enterprises who require full control, ownCloud is an open source solution that allows files to be stored on-premises and/or a backend cloud. 

Resources for Database Clusters: New Chef Cookbook, New Devops Webinar for eCommerce and More

Twitter icon
Facebook icon

Check Out Our Latest Technical Resources for MySQL, MariaDB & MongoDB Clusters Like every month this year, we have created new content and tools for you; here is a summary of what we’ve published this December. Please do check it out and let us know if you have any comments or feedback.

Pages