How to Deploy and Configure MaxScale for SQL Load Balancing with Read-Write Split

Twitter icon
Facebook icon

There are two models of load balancing: transport and application layer. HAProxy is a great TCP load balancer, but it’s lack of SQL awareness effectively limits its ability to address certain scaling issues in distributed database environments. In the open source world, there’s been a few SQL-aware load balancers, namely MySQL Proxy, ProxySQL and MaxScale, but they all seemed to be in beta status and unfit for production use. So we were pretty excited when the MariaDB team released a GA version of MaxScale earlier this year. In this blog, we’ll have a look at MaxScale and see how it compares with HAProxy.

How to Manage the World’s Top Open Source Databases: ClusterControl 1.2.9 Features Webinar Replay

Twitter icon
Facebook icon

Thanks to everyone who attended and participated in this week’s webinar on 'New Features - ClusterControl 1.2.9 Release'. If you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online. Our speaker this time was Johan Andersson, CTO, Severalnines.

How to Cluster Atlassian Server Apps in your Data Center - JIRA, Confluence, Stash with MySQL Galera Cluster

Twitter icon
Facebook icon

Atlassian apps are widely used by development teams to facilitate software development and collaboration. For larger teams who require enterprise-grade tools, you might want to host the applications in your own data center and cluster them for high availability and performance. 

Monitoring Galera Cluster for MySQL or MariaDB - Understanding and Optimizing CPU-related InnoDB metrics

Twitter icon
Facebook icon

The performance of a Galera cluster is strongly connected to the performance of MySQL. Galera only supports the InnoDB storage engine, it is therefore important to have an insight into how InnoDB operates  what metrics we can rely on and what kind of issues we might face. In this blog post, we will give you a tour of some of the InnoDB internals. Note that we covered Galera monitoring and host/OS monitoring in previous blogs.

New Features Webinar: ClusterControl 1.2.9 Manages the World’s Top Open Source Databases - Live Demo

Twitter icon
Facebook icon

With over 7,000 users to date, ClusterControl is the leading, platform independent automation and management solution for the MySQL, MongoDB and now Postgres databases, its latest main feature. With ClusterControl 1.2.9, we’ve introduced a whole range of new features, which we’d like to demonstrate to you in this live webinar on March 24th.

Monitoring Host Metrics of your Database Instances - How to interpret Operating System Data

Twitter icon
Facebook icon

Monitoring the metrics of the database hosts is critical. By keeping Swap and Physical Memory usage within allowable limits, you’ll ensure that there is enough memory for queries to be executed and connections to be created. By monitoring Disk Utilization, you can map growth patterns and better plan for capacity upgrades.

Press Release: New Severalnines platform manages the world’s top open source databases

Twitter icon
Facebook icon

Severalnines, the provider of database management automation, today announced the next step towards its goal of uniting the world’s fragmented open source database architectures in the enterprise, by launching the latest version of ClusterControl. The new platform allows IT professionals to deploy, monitor, manage and scale the world’s top three open source databases - MySQL, MongoDB and now PostgreSQL with one user-friendly application.

ClusterControl 1.2.9 Released

Twitter icon
Facebook icon

The Severalnines team is pleased to announce the release of ClusterControl 1.2.9. This release contains key new features along with performance improvements and bug fixes. We have outlined some of the key new features.

Monitoring Galera Cluster for MySQL or MariaDB - Understanding metrics and their meaning

Twitter icon
Facebook icon

To operate any database efficiently, you need to have insight into database performance. This might not be obvious when everything is going well, but as soon as something goes wrong, access to information can be instrumental in quickly and correctly diagnosing the problem.

How to migrate ClusterControl to a new server

Twitter icon
Facebook icon

As your needs change, and you start managing more database instances or larger centralized backups with ClusterControl, you might find that your controller host is over-utilized. Or you might need to migrate your infrastructure to the cloud. If this is the case, you can migrate to another instance.

Pages