I am happy to announce the availability of alpha release of our new product Percona XtraDB Cluster.

Percona XtraDB Cluster is High Availability and Scalability solution for MySQL Users and based on Percona Server 5.5.17

Percona XtraDB Cluster provides:

• Synchronous replication. Transaction either commited on all nodes or none.
• Multi-master replication. You can write to any node.
• Parallel applying events on slave. Real “parallel replication”.
• Automatic node provisioning.
• Data consistency. No more unsyncronised slaves.

Percona XtraDB Cluster is fully compatible with MySQL or Percona Server in the following meaning:

• Data compatibility. Percona XtraDB Cluster works with …

I find myself constantly looking up server variables (and manuals and changelogs) for MySQL, MariaDB, and XtraDB, which versions they are in, and so forth. So I finally created a couple pages which contain the links to all of these various bits of information across the various flavors of MySQL.

I’ve been using them every day, so I thought some others might want to bookmark these as well.

I’ve created the following:

o Changelogs
o Documentation
o Server Variables
o InnoDB Plugin Versions

The Changelogs page contains links for MySQL 3.23 up through 5.6, MariaDB 5.1 – 5.3, XtraDB 5.1 – 5.5, Xtrabackup 1.3 – …

Installing Apache2 With PHP5 And MySQL Support On CentOS 6.1 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 6.1 server with PHP5 support (mod_php) and MySQL support.

If you have 1.5 years experience, consider the MySQL for DBA course to see if this suits you better. It is also available as LVC and self-paced versions.

As we all settle into 2012, I remember the great saying “Stay hungry, stay foolish.”

The famous“Stay hungry, stay foolish” reference is from the last Whole Earth Catalog and also made popular via the Steve Jobs 2005 Commencement Address at Stanford, for those that do not know. Computers today would be a very different place without the numerous people that did stay hungry and  foolish as it all came together.  How does that apply to the DBA of today?

Hopefully we are all still hungry but not foolish with our data. MySQL is running most of the databases that power the web these days and we cannot afford to be foolish with that data.  When it comes to data integrity and security we should “wag more bark less.” By that I mean, be excited about the …

As a MySQL  consultant, I spend a lot of time talking with people about their backups. More specifically, we talk a lot about recovery. I had an interesting incident myself, which illustrates some of the things that are bound to happen as time passes.

First, let me explain how I do my personal backups. I have a series of external hard drives, which are fully encrypted, as is my computer’s hard drive. I maintain a full mirror of my computer’s hard drive on these external hard drives. I occasionally switch the hard drives out, and carry one or more of them to a bank’s safe deposit box. I try to do this once a week, but sometimes it isn’t quite that often.

As a result, I have one hard drive located physically near my computer, which contains a very recent backup of all my work. I have at least one, usually 3 or more, other copies of my data in a slightly less fresh format, but durably stored in a bank.

While …

If you have 1.5 years experience, consider the MySQL for DBA course to see if this suits you better. It is also available as LVC and self-paced versions.

Start off 2012 with the MySQL for Beginners course. You can get this training from your desk with the MySQL for Beginners Live Virtual Delivery and now you can even learn at your own pace with the all new MySQL for Beginners self-paced online delivery.

All you need to take the MySQL for Beginners course is a basic level of computer literacy.

With this course you will learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on …

Start off 2012 with the MySQL for Beginners course. You can get this training from your desk with the MySQL for Beginners Live Virtual Delivery and now you can even learn at your own pace with the all new MySQL for Beginners self-paced online delivery.

All you need to take the MySQL for Beginners course is a basic level of computer literacy.

With this course you will learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on …

Globo.com is the latest business initiative of Organizações Globo, a Brazilian media group that owns the television networks Rede Globo, Globosat, and TV Globo Internacional, as well as radio broadcast, publishing, and production companies. Globo.com gathers and publishes content through the Internet to Portuguese-speaking audiences worldwide.

Read our case study to find out how globo.com improved the performance and scalability of its Web portal while improving flexibility and reducing costs by 65% with MySQL Enterprise Edition.

To learn more about MySQL Enterprise Edition, get our “MySQL Enterprise Edition Product Guide”.