Download MariaDB Galera Cluster 10.0.19
Release Notes Changelog What is MariaDB Galera Cluster?
Download MariaDB Galera Cluster 5.5.43
Release Notes Changelog What is MariaDB Galera Cluster?
…
[Read more]
May
18
2015
May
18
2015
Amazon Web Services is one of the most popular cloud environments. Galera Cluster is one of the most popular MySQL clustering solutions. This is exactly why you’ll see many Galera clusters running on EC2 instances. In this blog post, we’ll go over five performance tips that you need to take under consideration while deploying and running Galera Cluster on EC2. If you want to run regular MySQL on EC2, you’ll find these tips still useful because, well, Galera is built on top of MySQL after all. Hopefully, these tips will help you save time, money, and achieve better Galera/MySQL performance within AWS.
Choosing a good instance size
When you take a look at the instance chart in the AWS documentation, you’ll see that there are so many instances to choose from. Obviously, you will pick an instance depending on your application needs (therefore you have to do some benchmarking first to understand those needs), but …
[Read more]
May
17
2015
Student questions are always interesting! They get me to think and to write. The question this time is: “How do I write a Bash Shell script to process multiple MySQL script files?” This post builds the following model (courtesy of MySQL Workbench) by using a bash shell script and MySQL script files, but there’s a disclaimer on this post. It shows both insecure and secure approaches and you should avoid the insecure ones.
It seems a quick refresher on how to use arrays in
bash shell may be helpful. While it’s essential in a
Linux environment, it’s seems not everyone masters the
bash shell.
Especially, since I checked my …
[Read more]
May
17
2015
I recently released version 0.1.10 of my library django-mysql, for which the main new
feature was a backend for Django’s cache framework called
MySQLCache. This post covers some of the inspiration
and improvements it has, as well as a basic benchmark against
Django’s built-in DatabaseCache.
TL;DR - it’s better than DatabaseCache, and if you’re using MySQL, please try it out by following the instructions linked at the end.
Why bother?
Django’s cache framework provides a generic API for key-value
storage, and gets used for a variety of caching tasks in
applications. It ships with multiple backends for popular
technologies, including Redis and Memcached, as well as a basic
cross-RDBMS DatabaseCache. The
DatabaseCache is recommended only for …
May
16
2015
Taxonomy upgrade extras: mysql performance monitor monitoring fpmmm maas performance monitor mpm
FromDual has the pleasure to announce the release of the new version 0.10.4 of its popular Database Performance Monitor for MySQL, MariaDB, Galera Cluster and Percona Server fpmmm.
You can download …
[Read more]
May
16
2015
FromDual has the pleasure to announce the release of the new version 0.10.4 of its popular Database Performance Monitor for MySQL, MariaDB, Galera Cluster and Percona Server fpmmm.
You can download fpmmm from here.
In the inconceivable case that you find a bug in
fpmmm please report it to our Bug-tracker.
Any feedback, statements and testimonials are welcome as well! Please send them to feedback@fromdual.com.
This release contains various minor bug fixes and improvements.
New installation of fpmmm v0.10.4
Please follow our mpm installation …
[Read more]
May
15
2015
Yesterday I was able to present to the Portland MySQL Users Group two presentations that are important foundations for effective development with MySQL.
Download Architecture Presentation
Download Development Presentation
With 26 years of architectural experience in RDBMS and 16 years of MySQL knowledge, my extensive …
[Read more]
May
15
2015
In an earlier post titled Using Perl to send tweets stored in a MySQL database to twitter, I showed you a way to use MySQL to store tweets, and then use Perl to automatically send your tweets to twitter.
In this post, we will look at automatically sending a “thank you” to people who retweet your tweets – and we will be using Perl and MySQL again.
Just like in the first post, you will need to register your application with twitter via apps.twitter.com, and obtain the following:
consumer_key consumer_secret access_token access_token_secret
One caveat: twitter has a rate limit on how often you may connect with your application – depending upon what you are trying to do. See …
[Read more]
May
15
2015
Hi, everyone. Just a quick note here to let you all know that we’ve just added Debian 8 support to our Apt repos. We have the latest MySQL Server 5.6 ready for you, as well as the latest 5.7 Development Milestone, and more of our products for Debian 8 are in our QA pipeline as […]
May
15
2015
Fedora comes with vim and gedit
installed but the gedit installation is bare bones.
You can update gedit to include supplemental
Plug-ins with the following yum command as the
root user:
yum install -y gedit-plugins |
It generates the following log file:
Loaded plugins: langpacks, refresh-packagekit mysql-connectors-community | 2.5 kB 00:00 mysql-tools-community | 2.5 kB 00:00 mysql56-community | 2.5 kB 00:00 pgdg93 | 3.6 kB 00:00 updates/20/x86_64/metalink | 14 kB 00:00 updates | 4.9 kB 00:00 … |