Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 34197 10 Older Entries
Log Buffer #416, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This log buffer edition sprouts from the beauty, glamour and intelligence of various blog posts from Oracle, SQL Server, and MySQL.

Oracle:

Oracle Exadata Performance: Latest Improvements and Less Known Features

Exadata Storage Index Min/Max Optimization

  [Read more...]
Percona XtraDB Cluster 5.5.41-25.11 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the new release of Percona XtraDB Cluster 5.5 on March 30th 2015. Binaries are available from downloads area or from our software repositories.

Based on Percona Server

  [Read more...]
Greetz replaces Oracle’s Real Application Cluster with Galera Cluster for MySQL high availability
+0 Vote Up -0Vote Down

Highly Available Greetings: Greetz uses MariaDB Galera Cluster for online Greeting Card Platform

 

Greetz provides on-line personalized greeting cards to thousands of customers. Their webshop application is built on Java and Hibernate (Object Relation mapping) and, prior to moving to MariaDB Galera Cluster, used Oracle(TM) Real Application Cluster as its underlying database. Their infrastructure is based on Linux and they use Ansible for configuration management.

 

Greetz approached Codershipʼs partner SkySQL (now MariaDB Corp.) to provide them with a …

  [Read more...]
MySQL bind-address
+0 Vote Up -0Vote Down

While I try to keep things simple, sometimes eliminating options and explanations comes back to haunt me. After posting how to open a Fedora firewall port for a LAMP stack, somebody got trapped by my instructions for installing MySQL on Fedora. They got stuck because they had the following setting in their /etc/my.cnf file:

bind-address=localhost.localdomain

I’d suggested using …

  [Read more...]
How to Deploy and Configure MaxScale for SQL Load Balancing with Read-Write Split
+0 Vote Up -0Vote Down

There are two models of load balancing: transport and application layer. HAProxy is a great TCP load balancer, but it’s lack of SQL awareness effectively limits its ability to address certain scaling issues in distributed database environments. In the open source world, there’s been a few SQL-aware load balancers, namely MySQL Proxy, ProxySQL and MaxScale, but they all seemed to be in beta status and unfit for production use. So we were pretty excited when the MariaDB team released a GA version of MaxScale earlier this year. In this blog, we’ll have …

  [Read more...]
EXPLAIN minor wishlist
+0 Vote Up -0Vote Down

While we always want better performance and more and larger features for MySQL, those cannot just “magically appear” from one version to another, requiring deep architecture changes and lots of lines of code. However, there are sometimes smaller features and fixes that could be implemented by an intern or an external contributor, mainly at SQL layer, and that could make the MySQL ecosystem friendlier to newbies and non-experts. Making a piece of software easier to use is sometimes overlooked, but it is incredibly important -not everybody using MySQL is a DBA, and the more people adopting it, more people will be able to live from it, both upstream and as third party …

  [Read more...]
Formal methods in the real world
+0 Vote Up -0Vote Down

A lot of interesting work is done at Amazon but not much is written about it. There is an article on their use of formal methods via TLA+ and PlusCal. I haven't seen much use of formal methods in my career. I have spent a lot of time debugging code written by other people, so I wouldn't mind if such tools were used more frequently.

I used the Spin tool for two MySQL …

  [Read more...]
Open Fedora Port 80
+0 Vote Up -0Vote Down

After installing the LAMP stack on Fedora, you need to open port 80 in the Firewall to access the PHP programs on the Fedora instance from external servers. You can open a firewall port by launching the firewall-config application as the root user with the following syntax:

firewall-config

The firewall-config utility opens the following …

  [Read more...]
Fedora Install LAMP
+0 Vote Up -0Vote Down

My students wanted an extra credit assignment, so I thought a LAMP configuration and test would be appropriate. The only problem was I hadn’t added it to their course VMware instance. So, here are the instructions to install Apache2, PHP, and MySQLi for a complete LAMP stack when MySQL is already installed.

The post builds on my Fedora Install of MySQL and MySQL Workbench on Fedora posts from last year. It also presumes that you’ve installed a …

  [Read more...]
‘Woz on your mind?’ Share your questions for Steve Wozniak during his Percona Live keynote!
+0 Vote Up -0Vote Down

Here’s your chance to get on stage with Woz! Sort of. Apple co-founder and Silicon Valley icon and philanthropist Steve Wozniak will participate in a moderated Q&A on creativity and innovation April 14 during the Percona Live MySQL Conference and Expo in Santa Clara, California.

Woz once said that he never intended to change the world. That was the other Steve, Steve Jobs.

“I didn’t want to start this company,” Woz told the Seattle Times of Apple’s beginnings in a 2006 …

  [Read more...]
Showing entries 1 to 10 of 34197 10 Older Entries

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