Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 154 Next 30 Older Entries

Displaying posts with tag: High Availability (reset)

David Axmark & Monty Widenius will be Berliners on June 18th - SkySQL & MariaDB Roadshow
+5 Vote Up -0Vote Down

Join us at the next MySQL & Cloud Database Solutions Day hosted by SkySQL & MariaDB in Berlin on June 18th

It’s a beautiful day in Berlin today and we’re putting the final touches to next week’s MySQL & Cloud Database Solutions Day, which takes place on Tuesday June 18th in the facilities provided by Bitkom in Berlin Mitte.

read more

David Axmark & Monty Widenius will be Berliners on June 18th - SkySQL & MariaDB Roadshow
+0 Vote Up -0Vote Down

Join us at the next MySQL & Cloud Database Solutions Day hosted by SkySQL & MariaDB in Berlin on June 18th

It’s a beautiful day in Berlin today and we’re putting the final touches to next week’s MySQL & Cloud Database Solutions Day, which takes place on Tuesday June 18th in the facilities provided by Bitkom in Berlin Mitte.

read more

Scaling Wordpress and MySQL on Multiple Servers for Performance
+0 Vote Up -0Vote Down
June 11, 2013 By Severalnines

Over the years, WordPress has evolved from a simple blogging platform to a CMS. Over seven million sites use it today, including the likes of CNN, Forbes, The New York Times and eBay. So, how do you scale Wordpress on multiple servers for high performance? 

 

This post is similar to our previous post on Drupal, Scaling Drupal on Multiple Servers with Galera Cluster for MySQL but we will focus on Wordpress, Percona XtraDB Cluster and GlusterFS using Debian Squeeze 64bit.

read more

Choosing a MySQL HA Solution – Post-Webinar Q&A
+1 Vote Up -0Vote Down

Thanks to everyone who was in attendance on 05 June 2013 for my “Choosing a MySQL HA Solution” webinar. If you weren’t able to make it but are interested in listening to the presentation, it’s currently up and available for viewing over at percona.com.

My apologies if we weren’t able to get to your question during the initial session, so I’ll address those lingering questions in this post, along with providing a bit more detail on some of the questions that I did cover during the session.

Q: What

  [Read more...]
High Availability for Drupal Part 2 - The Contenders
+0 Vote Up -0Vote Down

When looking at high availability for any CMS, and particularly for Drupal, the list of contenders for part or all of the solution is growing and can be daunting. We'll take a look at the various parts of a solution and what options we have.

Go Cloud?

It seems nearly every answer to every problem in IT these days is "The Cloud", but is it?

read more

High Availability for Drupal Part 2 - The Contenders
+0 Vote Up -0Vote Down

When looking at high availability for any CMS, and particularly for Drupal, the list of contenders for part or all of the solution is growing and can be daunting. We'll take a look at the various parts of a solution and what options we have.

Go Cloud?

It seems nearly every answer to every problem in IT these days is "The Cloud", but is it?

read more

Choosing a MySQL HA Solution – MySQL Webinar: June 5
+1 Vote Up -0Vote Down

Selecting the most appropriate solution for a MySQL HA infrastructure is as much a business and philosophical decision as it is a technical one, but often the choice is made without adequately considering all three perspectives.  When too much attention is paid to one of these aspects at the cost of the others, the resulting system may be over-engineered, poorly-performing, and/or various other flavors of suboptimal.

On Wednesday, June 5, at 10 a.m. PDT (1700 UTC), I will be presenting a webinar entitled, Choosing a MySQL HA Solution, in

  [Read more...]
High Availability for Drupal Part 1 - Investigating the Issues
+2 Vote Up -0Vote Down

Drupal is one of the most popular Content Management Systems (CMS) and is used increasingly in high-visibility sites, such as www.whitehouse.gov. This has brought a lot of attention on how to get the most performance out of Drupal and how to improve the availability of such sites. In this blog series I'll take you through the basics and on through to designing your own HA Drupal site.

But first, we need to understand what the challenges are in getting Drupal (or indeed any CMS) working on multiple servers in such a way as to ensure high availability and performance.

read more

High Availability for Drupal Part 1 - Investigating the Issues
+0 Vote Up -0Vote Down

Drupal is one of the most popular Content Management Systems (CMS) and is used increasingly in high-visibility sites, such as www.whitehouse.gov. This has brought a lot of attention on how to get the most performance out of Drupal and how to improve the availability of such sites. In this blog series I'll take you through the basics and on through to designing your own HA Drupal site.

But first, we need to understand what the challenges are in getting Drupal (or indeed any CMS) working on multiple servers in such a way as to ensure high availability and performance.

read more

Make MySQL clustering work for you
+0 Vote Up -1Vote Down
We’ve told you all about MySQL mult-master replication’s limitations. If you write to two masters it is bound to fail for myriad reasons. Now what? Do what the pros do that’s what. A. Don’t write to both masters Using multi-master replication works great as long as you do so in active-passive mode. Never write to [...]
Slides and spreadsheets for my MySQL High Availability tutorial
+1 Vote Up -0Vote Down

Good morning Percona Live visitors! Attached to this post you can find a spreadsheet (both LibreOffice or Excel, as you prefer) that you can use towards the end of my tutorial. I've also attached the slides so you can download a copy of them.

SkySQL named 2013 Top 100 Europe winner, more dates added for MySQL & Cloud Database Solutions Day
+0 Vote Up -0Vote Down

We were delighted last week to find out that we’d been named one of the ‘2013 Top 100 Europe’ winning companies by the Red Herring editorial team. Congratulations to all companies involved!

read more

SkySQL named 2013 Top 100 Europe winner, more dates added for MySQL & Cloud Database Solutions Day
+0 Vote Up -0Vote Down

We were delighted last week to find out that we’d been named one of the ‘2013 Top 100 Europe’ winning companies by the Red Herring editorial team. Congratulations to all companies involved!

read more

The write cache: Swap insanity tome III
+2 Vote Up -0Vote Down

Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster basically forbids calling malloc after the startup phase and hence its rather complex configuration.

Probably most readers of this blog know (or should know) about Linux swappiness setting, which basically controls how important is the file cache for Linux. Basically, with InnoDB, since the file cache is not important we add “vm.swappiness = 0″ to “/etc/sysctl.conf” and run “sysctl -p” and we are done.

Swappiness solves part of the swapping issue but not all. With Numa systems, the picture is more complex and swapping can occur because of a memory imbalance between the physical cpus, the sockets and not cores. Jeremy Cole explained this

  [Read more...]
No tools to reconcile MySQL with two masters
+0 Vote Up -0Vote Down
Here’s the last nail in the coffin. We hope this convinces you not to write to multiple masters with MySQL replication. Reason 10 – No tools to reconcile inconsistent masters For all the endless reasons we’ve already outlined MySQL replication is prone to failure. We know it’s going to happen, you now know too. When [...]
Temp tables can break replication
+0 Vote Up -0Vote Down
If you’re not convinced yet that writing to dual masters is a bad idea, we have a couple more reasons. 9. Temp tables break replication after restart MySQL’s replication is sensitive to temporary tables. You shouldn’t use them. If your queries create them to work against, and a node crashes, the temp tables will be [...]
Crashed nodes corrupt your MySQL cluster
+0 Vote Up -0Vote Down

Read the original article at Crashed nodes corrupt your MySQL cluster

Writing to two masters is like walking around with a loaded shotgun. Eventually one of your instances will fail and when it does, replications position & synchronization information could easily become corrupt! Reason 8 – Crashed nodes cause big problems MySQL instances, unfortunately can crash. When that happens, they don’t always sync the replication position [...]

For more articles like these go to Sean Hull's Scalable Startups

Related posts:
  • MySQL Cluster In The Cloud – Managers Guide
  •   [Read more...]
    Transaction isolation breaks when writing two masters
    +0 Vote Up -0Vote Down

    Read the original article at Transaction isolation breaks when writing two masters

    Continuing our discussion of multi-master replication, we hit on five more reasons why writing to two masters aka active-active replication is very dangerous. Click through to the end for multi-master solutions that work with MySQL. Reason 6 – You lose transaction isolation This may sound like a theoretical point to some. But hopefully we can [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • MySQL needs single master to check data integrity
  •   [Read more...]
    Active-active replication reduces operational flexibility
    +0 Vote Up -0Vote Down

    Read the original article at Active-active replication reduces operational flexibility

    Among the myriad data integrity and corruption risks associated with active-active replication, you also lose out on configurability and operational flexibility. Reason 7 – Can’t add nodes easily The often touted solution to use auto_increment_increment and auto_increment_offset fixes you to a given setup forever. You can set it up with a discrete two nodes, all [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • 10 reaons active-active is hard and how to solve it
  •   [Read more...]
    How to make MySQL multi-master work for you
    +0 Vote Up -0Vote Down

    Read the original article at How to make MySQL multi-master work for you

    Coming soon! Want more? Grab our Scalable Startups monthly for more tips and special content. Here’s a sample Related posts:Transaction isolation breaks when writing two masters MySQL requires an authoritative master to build slaves MySQL needs single master to check data integrity A master isn’t born but made Why does MySQL replication fail?

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • Transaction isolation breaks when writing two masters
  •   [Read more...]
    MySQL needs single master to check data integrity
    +0 Vote Up -0Vote Down

    Read the original article at MySQL needs single master to check data integrity

    MySQL slaves can drift out of sync. Many of our clients are surprised to find some data differences in their replication topology, once we do some checking and sniffing around. Such checks require a single reliable or authoritative master to compare against. Click through to the end for multi-master solutions that work with MySQL. Reason [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • MySQL requires an authoritative master to build slaves
  •   [Read more...]
    MySQL requires an authoritative master to build slaves
    +0 Vote Up -0Vote Down

    Read the original article at MySQL requires an authoritative master to build slaves

    In MySQL database operations, you often need to rebuild slaves. They fail for a lot of different reasons, fall out of sync or crash. When this happens you may find you need to reclone and start fresh. This is normally done by finding your authoritative master database, and doing a hotbackup. Click through to the [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • Limitations of MySQL row-based replication
  • Why does MySQL replication
  •   [Read more...]
    Limitations of MySQL row-based replication
    +0 Vote Up -0Vote Down

    Read the original article at Limitations of MySQL row-based replication

    MySQL offers a few different options for how you perform replication. Statement-based has been around a lot longer, and though it has some troublesome characteristics they’re known well and can be managed. What’s more it supports online schema changes with multi-master active-passive setup. We recommend this solution. Row-based replication is newer. It attempts to address [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • Why does MySQL replication fail?
  • 5
  •   [Read more...]
    10 reaons active-active is hard and how to solve it
    +0 Vote Up -0Vote Down

    Read the original article at 10 reaons active-active is hard and how to solve it

    Multi-master replication provides redundant copies of your most important business assets. What’s more it allows applications to scale out, which is perfect for cloud hosting solutions like Amazon Web Services. But when you decide you need to scale your write capacity, you may be considering active-active setup. This is dangerous, messy and prone to failure. [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • Why does MySQL replication fail?
  •   [Read more...]
    Why does MySQL replication fail?
    +0 Vote Up -0Vote Down

    Read the original article at Why does MySQL replication fail?

    When considering active-active multi-master, you must consider it’s foundation technology. Although MySQL replication is straightforward to setup, it can fail in a myriad of ways. Most of those are known and well understood. We can solve them only if we use the technology in the standard way. Click through to the end for multi-master solutions [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • 5 Ways to fortify MySQL replication
  • Easy MySQL replication with
  •   [Read more...]
    MySQL 5.6 Replication Webinar
    Employee +3 Vote Up -0Vote Down

    Update – the recording of this webinar is now available here.

    This Wednesday (27th March) Mat Keep and I will be presenting a free, live webinar on MySQL 5.6 Replication. You need to register here (http://www.mysql.com/news-and-events/web-seminars/mysql-5-6-replication-enabling-next-generation-of-web-mobile-social-and-cloud-services/" target="_blank) ahead of the webinar – worth doing even if you can’t attend as you’ll then be sent a link to the replay when it’s available. We’ll also have some of the key MySQL replication developers

      [Read more...]
    Tungsten University: Configure & provision Continuent Tungsten clusters
    +1 Vote Up -0Vote Down
    Are you unsure of the steps needed to get your Continuent Tungsten cluster up-and-running? In this virtual course, we will teach you how to get from a single database server to a scalable cluster, or from a brittle MySQL replication system to a transparent, manageable Tungsten cluster.  We will discuss the benefits of leveraging Continuent Tungsten clustering with MySQL, and walk you through the
    MySQL 5.6 GA – Replication Enhancements
    Employee +5 Vote Up -0Vote Down

    Multi-Threaded Slave

    MySQL 5.6 has now been declared Generally Available (i.e. suitable for production use). This is a very exciting release from a MySQL replication perspective with some big new features. These include:

    • Global Transaction Identifiers (GTIDs) – a unique identifier that is used accross your replication topology to identify a transaction. Makes setting up and managing your cluster (including the promotion of a new master) far simpler and more reliable.
    • Multi-threaded slaves (MTS) – Increases the performance of replication on the slave;
      [Read more...]
    Beyond Failover: MySQL Multi-Region Master–Master Replication Considerations and Limitations.
    +0 Vote Up -0Vote Down

    Standard MySQL is configurable such that a single master server can be clustered with a number of read-only slave servers. To enable this master-slave replication, master’s transaction logs are communicated to the slaves (log shipping). Log shipping is a form of asynchronous replication. Under this configuration, the data on the slave always remains behind the master, a condition referred to as slave lag or replication lag. The extent of the slave lag depends on workload, network bandwidth and network latency. Database reads can be served out of the slaves, assuming the application has been designed to tolerate the slave lag and requisite staleness of data (eventual consistency), which can at times be variable and opaque. MySQL master-slave replication offers the possibility of promoting a slave to become the new master

      [Read more...]
    Meeting the MySQL Team at UKOUG (ICC Birmingham, December 3-5 | 2012)
    +4 Vote Up -1Vote Down
    If you're planning to attend UKOUG in Birmingham on Dec 3-5, here's your guide to know more about Oracle's MySQL.

    There's a MySQL stream on Monday 5th and we've a great list of sessions, including:



      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 154 Next 30 Older Entries

    Planet MySQL © 1995, 2014, 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.