This Log Buffer Edition goes out deep into the vistas of database world and brings out few of the good ones published during the week from Oracle, SQL Server, and MySQL.
Oracle:
Percona is pleased to announce the availability of Percona Toolkit 2.2.15. Released August 28, 2015. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source.
This release is the current GA (Generally Available) stable release in the 2.2 series. It includes multiple bug fixes as well as continued preparation for MySQL 5.7 compatibility. Full details are below. Downloads are available here and from …
[Read more]Codership is pleased to announce the release of Galera Cluster 5.5.42 and 5.6.25 with Galera Replication library 3.12, implementing wsrep API version 25.
Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.
This and future releases will be available from http://www.galeracluster.com, while previous releases remain available on LaunchPad. The source repositories and bug tracking are now on http://www.github.com/codership.
New features and notable changes in Galera Cluster and the Galera library:
In this article we will walk you through the steps on how to install LAMP (Linux, Apache, MySQL and PHP-FPM) on a Debian 8 VPS. A LAMP stack is a synonym of LAMP server or LAMP web server. It refers to a set-up which includes Linux, Apache, MySQL (MariaDB) and PHP. REQUIREMENTS We will be using our SSD 1 Linux VPS hosting plan for this tutorial. UPDATE THE SYSTEM Make sure your server is fully up to date using: # apt-get update && apt-get upgrade INSTALL APACHE To install Apache on your Debian 8 server, you need to execute the […]
A key theme of the MySQL Server 5.7 release is much improved security. Earlier releases of MySQL 5.7 have introduced features supporting this initiative including automatic generation and detection of TLS key material and client-side preference for TLS connections. The recent MySQL 5.7.8 release builds upon this and provides additional monitoring and audit capabilities that make it easy to answer the question: “How secure are my client connections?”.…
I have now released version 1.2 of MyOraDump, my Oracle
data extraction tool. This version has one new feature, which is
transaction support for MySQL format exports which does speed up
loading data a lot! Trust me, it really does! Also I have fixed a
bug that did cause a crash at the end of the run, I have no idea
why this didn't show up before, but there you go and now it is
fixed.
MyOraDump 1.2 can be downloaded sourceforge, and as usual there is also a pdf only
download if you want to read up on the tool before using
it.
/Karlsson
In our previous post, we discussed the different ways to collect data about slow queries - MySQL offers slow log, general log and binary log. Using tcpdump, you can grab network traffic data - a good and low-impact method of collecting basic metrics for slow queries. So, now that you are sitting on top of a large pile of data, perhaps tens of gigabytes of logs, how do you get a whole picture of the workload?
Mid to large size applications tend to have hundred of SQL statements distributed throughout a large code base, with potentially hundreds of queries running every second. That can generate a lot of data. How do we identify causes of bottlenecks slowing down our applications? Obviously, going through the information query by query would not be great - we’ll get drowned with all the entries. We need to find a way to …
[Read more]Oracle MySQL – News, Monitoring, Diagnostic and Backup Event Oracle MySQL (Session in French) – Lausanne / 29.09.2015
You work on MySQL and your needs evolve? ORACLE and dbi services invite you to a workshop dedicated to the monitoring, the diagnostic and the backup of your MySQL databases. We look forward to meeting you there!
ConFoo is once more seeking passionate speakers for the upcoming conference.
The event is happening in Montreal, Canada, between February 24th and 26th, 2016. It is an exciting conference for web developers with speakers from all over the world. It unites many web programming languages under one roof, as well as other topics related to web development. The call for papers closes on September 20th.
ConFoo renews 50% of its speakers each year. If you’re new to this conference, you should definitely submit.
If you would just like to attend, there is a discount until October 13th.
The MariaDB team released a GA version of MariaDB Galera Cluster 10 in June 2014. MariaDB 10 is the equivalent of MySQL 5.6, and therefore, packed with lots of great features.
In this blog post, we’ll look into how to perform an online upgrade to MariaDB Galera Cluster 10. At the time of writing, MariaDB 10.1 was still in beta so the instructions in this blog are applicable to MariaDB 10.0. If you are running the Codership build of Galera (Galera Cluster for MySQL), you might be interested in the online upgrade to MySQL 5.6 instead.
Offline Upgrade
An offline upgrade requires downtime, but it is more straightforward. If you can afford a maintenance window, this is probably a safer way to reduce the risk of upgrade failures. The major steps consists of stopping the cluster, upgrading all …
[Read more]
