Lets see what HA solutions can be designed in mysql and where are they suited.
1. Single master - single slave.
M(RW)|S(R) A simple master slave solution can be used for a small site - where all the inserts go into the master and some (non-critical) requests are served from the slave. In case if the master crashes, the slave can be simply promoted as the master - once it has replicated the "
Winners of the 2012 MySQL Community Awards were announced at the Percona Live MySQL Conference and Expo just a few hours ago:
...
In terms of continuing with MySQL traditions, it has been my privilege the past years to be the secretary of the MySQL Community Awards panel. We have so many amazing persons, products and companies in this community. One of the nicest thing we can do to each other, and what really builds and fuels a community, is to show appreciation and say thanks to people that really deserve it.
Today we released MariaDB 5.5.23 as stable (GA). The last few days
we have also released MariaDB 5.3.6 stable (second GA release)
and MariaDB 5.2.12 and MariaDB 5.1.62.
The reason for doing the older releases was that we found a very
serious security issue in all recent MariaDB / MySQL releases and
we strongly recommend everyone to upgrade to one of the above
releases ASAP. We have informed Oracle of the problem and they
are likely to issue a new MySQL release soon!
That said, I am very happy that MariaDB 5.5 is finally available
as a stable release and I wish you the best of luck with
it!
MariaDB 5.5 includes all features from MySQL 5.5 and MariaDB 5.3
(with the exception of OQGraph for which we are awaiting a patch
from the OQgraph developers to solve a compatibility
issue).
MariaDB 5.5 is a …
Determining the Query Execution Plan (QEP) of an SQL statement is the primary analysis tool for DBAs. Understanding how to interpret the information from the EXPLAIN command and what additional commands and tools exist to add supplementary information are essential skills that will be used daily in production operations.
The MySQL EXPLAIN QEP is significantly different from an Oracle QEP and Oracle DBAs need to understand and learn the most appropriate way to understand and navigate this information to effective …
[Read more]
Schooner announced initial benchmarks of SchoonerSQL™ against the
new Percona XtraDB Cluster. Percona XtraDB Cluster is a
distribution of Percona Server with the Galera HA toolkit.
Standard benchmarks are a proxy for the performance that users
may see with their own workloads. Schooner ran the standard DBT2
benchmark, which is the open-source OLTP version of the TPC-C
benchmark, using a heavy workload of 1,000 warehouses with 32
concurrent connections to the database and zero think time.
Measurements in each case were made using a typical two-node
master-slave configuration. Each node was a standard IBM x86
server with 12/24 processor cores/threads, 72 GB of DRAM, and two
320 GB Fusion-io ioDriveDuos, running Red Hat Enterprise Linux
6.2.
SchoonerSQL Delivers Three Times the Throughput of …
Liveblog: What’s New In MySQL 5.5 and 5.6 Replication
presented by Giuseppe Maxia at the Percona Live MySQL Conference
and Expo.
Has been working with MySQL for 11 years.
Yesterday Oracle released MySQL 5.6.5 with new stuff, so the
content was rewritten last night.
main features we’ll talk about:
5.5 semi synchronous replication
5.6 delayed replication
server uuid
crash-safe slave
multi-threaded slave
global transaction identifiers
In MySQL 5.5 – what is semisync replication? It increases
reliability by making sure that the changes are committed on at
least one of the slaves before the write query is returned.
To use it, install the plugin rpl_semi_sync_master on the master,
and rpl_semi_sync_slave on the slave. Then you configure the
master to use the plugin, and then you restart both the master
and slave to activate the plugin and config.
Once you …
[Read more]MySQL is receiving mainstream media attention this week with Twitter publicly deciding to open source work on its MySQL database. Of course, the problems we see every day are being called out. Per GigaOm’s article:
But it [MySQL] has its problems, among them scalability and performance under the pressure of high transaction rates.
Like Twitter, our customer AppDynamics, is working to better manage data at high availability rates, but they’re taking a slightly different tact. In a recent post on the AppSignal blog, Boris Livshutz, introduces what he calls a ‘Data Cloud’ and looks for common ground between SQL and NoSQL rather than calling out the differences. …
[Read more]We are pleased to announce the immediate availability of MariaDB 5.5.23. This stable (GA) release incorporates MariaDB 5.3.6 and MySQL 5.5.23, some performance improvements, and bug fixes.
Please see the What is MariaDB 5.5 page for an overview of MariaDB 5.5.
Sources, binaries, and package downloads are available from our …
[Read more]
Every old mansion has some old history, and the older it is, the
scarier it gets ...
MySQL is no exception: there are some very old ghosts still
lurking inside the server.
One of these ghosts is the 'host cache', which haunts the server
main entrance halls, just right pass the TCP/IP front door.
How long has this ghost been there ? From the very beginning it
seems, as is was first spotted on April 26, 2006 ... Yes, that was 6
years ago, back in the 4.1 old times.
This ghost has been haunting DBA's worst nightmares since
then.
Public sightings include:
- Bug#22821 Adding "SHOW HOST_CACHE" patch from
Jeremy Cole
- Bug#24906 No command to …
And lastly, from none other than The Brian Aker, a keynote on The New MySQL Cloud Ecosystem. He was formerly the Director of Architecture for MySQL and also the creator of Drizzle. He is currently a fellow at HP, leading their cloud architecture group.
He began with a little history on MySQL of course. The drivers as seen by Brian over the years: initially “Batteries Included” or embedded into a product, to “Enterprise” or feature-creep, market-parity, stored-procedures… And of course, the GPL license, which caused no end of confusion in the marketplace.
Now onto DBAs (or the lack thereof!), again something we can all relate to. Yes, Pythian is also always looking for good MySQL DBAS. Continuing on, however, there are no more distribution/GPL concerns as MySQL is provided as a service in the cloud now, and software as a service in the cloud does not need to …
[Read more]