www.accelerationdb.com
Table of Contents Background 3 MySQL High
Availability and synchronous replication 3 About Continuent
Tungsten 3 About MySQL MHA 4 Production Readiness 4 Development
Tools 5 Architecture 5 MHA 5 MHA deployment diagram 6 MHA
failover diagram 7 Continuent Tungsten 8 Tungsten Deployment
Diagram 11 Tungsten Failover Diagram 12 Installation 13 MHA 13
Tungsten 13 Management 13 MHA 13 Tungsten 14 Open Source 14
Conclusion
BackgroundWe selected two MySQL High Availability solutions - MHA
from http://code.google.com/p/mysql-master-ha/and
Continuent Tungsten Enterprise from www.continuent.com. Both suites of applications
MHA and Tungsten deliver MySQL high availability, both of them
operate in asynchronous …
The MySQL Connect Call for Papers closes on May 6 so you only have a few days left to submit your session proposals! Thanks to all of you who already submitted conference sessions and BOFs.
MySQL Connect represents a tremendous opportunity for you to present your real-world experience and share your expertise and best practices with the MySQL community.
Interested in sponsorship and exhibit opportunities? You will find more information here.
We look forward to hearing from you!
Following my previous benchmarks of SATA SSD cards I got
Intel SSD 520 240GB into my hands. In this
post I show the results of raw IO performance of this card.
The benchmark methodology I described in previous posts, so let me jump directly to results.
First case is random write asynchronous 8 threads IO,
the test is done just after a secure erase operation on the
card.
The card is doing stable 380 …
[Read more]Please join me tomorrow (Wednesday) for a webinar about the new version of pt-online-schema-change, Percona Toolkit’s tool for performing nonblocking ALTER TABLE operations. Registration is free. I will explain how the tool works and cover some typical use scenarios. This might be helpful if you’re trying to decide whether the tool is right for you. I am also planning to leave plenty of time for questions!
Further Reading:
[Read more]Recently, got an opportunity to do some implementation using Ajax and PHP. Having previously used NetBeans IDE 6.1/6.5 for PHP, it was an obvious choice to come back to NetBeans IDE again.
Although, I am yet to download the latest version, I am currently using 6.8 and I enjoyed every bit of it, while playing with CSS and jQuery for the first time, while implementing Ajax with PHP.
As I am gonna stay with PHP for sometime now, so I guess I better get my NetBeans IDE upgraded, before I miss out on any useful features.
It’s good to be back
Devopsdays Mountainview sold out in a short 3 hours .. but
there's other events that will breath devops this summer.
DrupalCon in Munich will be one of them ..
Some of you might have noticed that I`m cochairing the devops
track for DrupalCon Munich,
The CFP is open till the 11th of this month and we are still
actively looking for speakers.
We're trying to bridge the gap between drupal developers and the
people that put their code to production, at scale.
But also enhancing the knowledge of infrastructure components
Drupal developers depend on.
We're looking for talks both on culture (both success stories and
failure) , automation,
specifically looking for people talking about drupal deployments
, eg using tools like Capistrano, Chef, Puppet,
We want to hear where Continuous Integration fits in your
deployment , do you do Continuous Delivery of a drupal
environment.
And how do you …
The MySQL Connect call for papers will be closing soon. We have received some very good submissions but yours needs to be included! . No need to panic but May 6th is the cut off date and that is just a few days away. So tell us how you solved problems with MySQL, your approach to scaling, how you teach with MySQL, or something you would like to share.
[Read more]Get a detailed introduction to the very broad topic of end-to-end performance optimization in web applications based on LAMP stack (Linux, Apache, MySQL, PHP).
Short Url: http://j.mp/EM-LAMP-opt
Presenter: Ronald Bradford
Schedule:
- OTN MySQL Developer Day in May 2012 – New York.
- Effective MySQL Meetup York and …
I was checking out my schedule as I prepared to submit some talks to Percona Live: NYC, when I noticed that it conflicts with Oracle OpenWorld, and starts the day after MySQL Connect finishes. The dates for Oracle OpenWorld were announced at the end of last year’s OpenWorld, so Percona has made a bold statement by choosing to conflict with Oracle OpenWorld. I do not believe Percona knew about MySQL Connect, but it’s happening all the same.
This is all mostly to say that I cannot attend Percona Live: NYC – I have obligations as an Oracle ACE Director to attend some meetings before and during Oracle OpenWorld, but even if I did not, I just submitted presentations to MySQL Connect and it’s not feasible for me to do that …
[Read more]Security-Enhanced Linux or SELinux is a Linux kernel feature that provides a mechanism for supporting access control security policies. It enables a system administrator to create an extra set of rules that define allowed operations for programs even after the standard controls are checked. In other words, SELinux can help improving system security by restricting access of an application to only a few resources it actually needs, which makes it more difficult for an attacker to gain access to the entire system through exploiting any possible vulnerabilities in the application.
However as rarely anything in life is free, is there any price we have to pay to use SELinux on a MySQL server?
I ran a simple MySQL benchmark first with database working in a system with SELinux enabled (SELINUX=enforcing), and then also with the extra security layer entirely disabled (SELINUX=disabled).
The …
[Read more]