Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 56 10 Older Entries

Displaying posts with tag: high-availability (reset)

Using Ceph with MySQL
+0 Vote Up -0Vote Down

Over the last year, the Ceph world drew me in. Partly because of my taste for distributed systems, but also because I think Ceph represents a great opportunity for MySQL specifically and databases in general. The shift from local storage to distributed storage is similar to the shift from bare disks host configuration to LVM-managed disks configuration.

Most of the work I’ve done with Ceph was in collaboration with folks from Red Hat (mainly Brent Compton and Kyle Bader). This work resulted in a number of talks presented at the …

  [Read more...]
Webinar Thursday June 23: Choosing a MySQL High Availability Solution Today
+1 Vote Up -0Vote Down

Please join Percona, Technical Account Manager, Michael Patrick on Thursday, June 23, 2016 at 10 AM PDT (UTC-7) as he presents “Choosing a MySQL High Availability Solution Today.”

High availability (HA) is one of the solutions to improve performance, avoid data outages, and recover quickly from disasters. An HA environment helps guarantee that your database doesn’t have a single point of failure, accommodates rapid growth and exponentially increasing database …

  [Read more...]
How We Made MySQL Great Again, or Upgrading MySQL with Orchestrator
+0 Vote Up -0Vote Down

In this blog post, we’ll discuss upgrading MySQL with Orchestrator.

I recently had a client, Life360, that wanted to upgrade from Percona Server 5.5 to Percona Server 5.6, and implement GTID in their high transaction environment. They had co-masters and multiple read slaves.

Orchestrator made this job much easier for us. My colleague, Tibi, recently posted about Orchestrator …

  [Read more...]
Docker MySQL Replication 101
+0 Vote Up -0Vote Down

In this blog post, we’ll discuss some of the basics regarding Docker MySQL replication. Docker has gained widespread popularity in recent years as a lightweight alternative to virtualization. It is ideal for building virtual development and testing environments. The solution is flexible and seamlessly integrates with popular CI tools.

 

This post walks through the setup of MySQL replication with Docker using Percona Server 5.6 images. To keep things simple we’ll configure a pair of instances and override …

  [Read more...]
How MaxScale monitors servers
+0 Vote Up -0Vote Down

In this post, we’ll address how MaxScale monitors servers. We saw in the

We saw in the previous post how we could deal with high availability (HA) and read-write split using MaxScale.

If you remember from the previous post, we used this section to monitor replication:

[Replication Monitor]
type=monitor
module=mysqlmon
servers=percona1, percona2, percona3 …
  [Read more...]
High availability with asynchronous replication… and transparent R/W split
+1 Vote Up -0Vote Down

In this post, the first one of a Maxscale series, I describe how to use MariaDB’s MaxScale and MySQL-utilities with MySQL Asynchronous replication.

When we talk about high availability with asynchronous replication, we always think about …

  [Read more...]
Better high availability: MySQL and Percona XtraDB Cluster with good application design
+0 Vote Up -0Vote Down

High Availability

Have you ever wondered if your application should be able to work in read-only mode? How important is that question?

MySQL seems to be the most popular database solution for web-based products. Most typical Internet application workloads consist of many reads, with usually few writes. There are exceptions of course – MMO games for instance – but …

  [Read more...]
MySQL 5.7 first impressions on group-replication
+3 Vote Up -0Vote Down

During the last few weeks I’ve been testing and playing a bit with the new group-replication plugin available for MySQL 5.7. Before continuing I’d like to clarify some aspects: the plugin is only available in labs and is not yet ready for production. The current version is 0.6. I used 5.7.9 GA running in a Vagrant 3 nodes cluster with CentOS 7.
As an additional note, I’ve tested previous version of plugin 0.5 against 5.7.8.rc and there are some good changes, so I recommend starting with the GA version.


  [Read more...]
Announcing: MySQL Fabric 1.6.2 on Labs
Employee_Team +0 Vote Up -0Vote Down

The MySQL Fabric team is pleased to announce that a new version is now available on Labs. This labs release includes our latest developments to give you a taste of what we have been working on. In particular, it includes the following new features and improvements:

  • Multi-node Fabric support is now available!

Compiling and Using the MySQL Router Labs Release
Employee_Team +2 Vote Up -0Vote Down

Last week we released MySQL Router into our Labs and we need to provide a few extra details on how to actually use it.

Requirements

  • A modern OS which comes with a compiler supporting C++11. For example, Ubuntu 14.04 and later, Oracle Linux 7, OS X 10.10.

Showing entries 1 to 10 of 56 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.