Today we’re happy to announce that we’ll be partnering with Datavail to provide solutions for continuous & highly available MySQL, Percona Server & MariaDB database operations based on Tungsten Clustering & Datavail Database Services.

Datavail is a renowned, tech-enabled data management, applications, business intelligence, and software solutions provider with a team of 700+ DBAs that look after customers’ database environments.

What are we aiming for?

Together we’re looking to continue to drive momentum in supporting rapid MySQL & MariaDB based application deployments as well as highly available and scalable database implementations for existing and future customers.

This new …

The MySQL Windows Experience Team is proud to announce the release of MySQL Notifier version 1.1.5, the  latest addition to the MySQL Installer for Windows.

MySQL Notifier 1.1.5 introduces the following features:

• The MySQL Utilities can now be opened from MySQL Notifier if installed separately from MySQL Workbench (it is no longer bundled with MySQL Workbench 6.x).
• Added Workbench connections edition capability right from the Monitor MySQL Server Instance window of the MySQL Notifier (accessed through Actions > Manage Monitored Items… > Add… > MySQL Instance). Any of the listed MySQL Workbench connections can be right-clicked and a new “Edit Connection” context menu is available for users to edit the Workbench connection properties.
• Changed the way the Workbench connections and servers files are monitored, now the Notifier detects automatically …

The MySQL Windows Experience Team is proud to announce the release of MySQL Notifier version 1.1.4, the  latest addition to the MySQL Installer for Windows.

MySQL Notifier 1.1.4 introduces the following features:

• Monitoring of services in remote Windows computers (any service, not only MySQL Server services, similar to the local services monitoring offered in MySQL Notifier 1.0.3) via asynchronous Windows Management Instrumentation. Monitored services are grouped by computer name where the topmost is the Localhost. After a service in the Localhost or a remote computer is added to the monitored list, the MySQL Notifier automatically monitors for MySQL Server services addition (this option can be turned-off by users).
• Monitoring of MySQL Server instances on any platform via a timer configurable by users.  These instances are monitored via MySQL Workbench connections which are automatically …

Read the original article at Anatomy of a Performance Review

A lot of firms come to us with a specific scalability problem. “Our user base is growing rapidly and the website is falling over!” Or they’re selling more widgets, “Our shopping cart is slowing down and we’re seeing users abandon their purchases”. These are real startup growing pains, so what to do?

We like to take a measured approach with these types of challenges, so we thought it would be helpful to run through a hypothetical scenario and see how we work.

Having trouble with scalability? Check out our 5 things toxic to scalability piece. …

Hi all,

Here is another installment on working in the cloud, the AWS cloud that is. Today's topic: creating a custom AMI. This may sound like as easy task. And it would have been, had AWS documentation been up to scratch. I spent lots of time messing around with this, and I finally got it to work. Here's how:

1. Launch an exiting image (I chose a Fedora 8 image). Modify the /var/www/html/index.html file to something else (thus making it "your unique AMI). I went one step further: I installed JDK 6 and MySQL on mi AMI for use at a later date.
2. Now you have to upload your private key and x509 certificate to the AMI. Here's how to do this in the terminal:

       scp -i ~/.ssh/<yourkeypair.pem> ~/.ec2/<pk-whatever.pem> ~/.ec2/<cert-whatever.pem> root@your-public-DNS:/mnt.

   The private key and x-509 certificate should be uploaded to the mnt directory to prevent them from being …

Hi all,

Here is another installment on working in the cloud, the AWS cloud that is. Today's topic: creating a custom AMI. This may sound like as easy task. And it would have been, had AWS documentation been up to scratch. I spent lots of time messing around with this, and I finally got it to work. Here's how:

1. Launch an exiting image (I chose a Fedora 8 image). Modify the /var/www/html/index.html file to something else (thus making it "your unique AMI). I went one step further: I installed JDK 6 and MySQL on mi AMI for use at a later date.
2. Now you have to upload your private key and x509 certificate to the AMI. Here's how to do this in the terminal:

       scp -i ~/.ssh/<yourkeypair.pem> ~/.ec2/<pk-whatever.pem> ~/.ec2/<cert-whatever.pem> root@your-public-DNS:/mnt.

   The private key and x-509 certificate should be uploaded to the mnt directory to prevent them from being …

Hi all,

Hmmmm...

I switched on my machine this morning thinking a new day will bring new results. Nope. Same old results. As I mentioned in an earlier blog entry, I created a server instance using Fedora with LAMP, complete with MySQL. Hmmm.. Sound good? Well, it comes with MySQL 4.1. Normally an update would be a straightforward process. Since Fedora 8 doesn't come with an

apt-get

command, I chose to go the

yum

route. I tried

 yum update mysql-server

. No dice. problems. I spent another 30 minutes or so, trying to correct the problem, but to no avail. So I decided to create a whole new server instance with Fedora 8 and no MySQL. I manually installed MySQL on the machine, by doing the following:

• I download the MySQL sever, cient, and headers and libraries from the MySQL.com.

      wget …

Hi all,

Hmmmm...

I switched on my machine this morning thinking a new day will bring new results. Nope. Same old results. As I mentioned in an earlier blog entry, I created a server instance using Fedora with LAMP, complete with MySQL. Hmmm.. Sound good? Well, it comes with MySQL 4.1. Normally an update would be a straightforward process. Since Fedora 8 doesn't come with an

apt-get

command, I chose to go the

yum

route. I tried

 yum update mysql-server

. No dice. problems. I spent another 30 minutes or so, trying to correct the problem, but to no avail. So I decided to create a whole new server instance with Fedora 8 and no MySQL. I manually installed MySQL on the machine, by doing the following:

• I download the MySQL sever, cient, and headers and libraries from the MySQL.com.

      wget …

Hi all,

Today I'll be write more about my experiences with Amazon Web Services. Before I continue, I'd like to provide some background information.

I signed up for Amazon Web Services. I used the Fedora LAMP AMI to create a server instance. The main reason for choosing this AMI was its inclusion of MySQL and Apache, a nice little package indeed. I ran into a few problems at first. Because I am based in Europe, I am allowed to use only the EU-West region, and the default in the US-East region. The drop down list is rather small, and i took a couple of unsuccessful instances to figure out that this was the problem. When I say "unsuccessful instances," I mean that the nothing appeared in the browser when I copied the public DNS to the browser's address bar. I attached an EBS volume to the server instance and it was OK.

Now for more on the command line.

I spent a lot of time messing around with the commands in the …

Hi all,

Today I'll be write more about my experiences with Amazon Web Services. Before I continue, I'd like to provide some background information.

I signed up for Amazon Web Services. I used the Fedora LAMP AMI to create a server instance. The main reason for choosing this AMI was its inclusion of MySQL and Apache, a nice little package indeed. I ran into a few problems at first. Because I am based in Europe, I am allowed to use only the EU-West region, and the default in the US-East region. The drop down list is rather small, and i took a couple of unsuccessful instances to figure out that this was the problem. When I say "unsuccessful instances," I mean that the nothing appeared in the browser when I copied the public DNS to the browser's address bar. I attached an EBS volume to the server instance and it was OK.

Now for more on the command line.

I spent a lot of time messing around with the commands in the …