Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 71 to 80 of 34437 10 Older Entries
Upgrading Directly From MySQL 5.0 to 5.6 With mysqldump
Employee_Team +2 Vote Up -0Vote Down

Upgrading MySQL

Upgrading MySQL is a task that is almost inevitable if you have been managing a MySQL installation for any length of time. To accomplish that task, we have provided a utility and documentation to upgrade from one version of MySQL to another. The general recommendation is to perform the upgrade by stepping from one major release to the next, without …

  [Read more...]
Announcing VividCortex's Free Network Analyzer Tools for MySQL and PostgreSQL
+0 Vote Up -0Vote Down

We have released two free tools that will help MySQL and PostgreSQL DBAs understand the queries their database servers execute. As you probably know, we have spent nearly 3 years building the most advanced and efficient network traffic capture and decoding tools for MySQL and PostgreSQL. With the release of these free tools, we’re placing all the power of our traffic analysis libraries in your hands.

In our initial release, the tools sniff the network traffic and print out queries, with microsecond-resolution timing information, in a format that …

  [Read more...]
Network Analyzer for PostgreSQL
+0 Vote Up -0Vote Down

VividCortex’s network traffic analyzer tool for PostgreSQL is an easy-to-use way to gain insight into your server’s activity. Built for PostgreSQL servers running on Linux operating systems, it is a non-intrusive, safe way to understand your query workload.

This commandline tool captures TCP traffic on your server and decodes the protocol. It decodes and times queries, and outputs them in a standard log format. You can use standard log analysis tools such as Percona Toolkit’s pt-query-digest to analyze the output and build insight into queries and server performance.

The tool is built on VividCortex’s advanced network traffic capture …

  [Read more...]
Network Analyzer for MySQL
+0 Vote Up -0Vote Down

VividCortex’s network traffic analyzer tool for MySQL is an easy-to-use way to gain insight into your server’s activity. Built for MySQL servers running on Linux operating systems, it is a non-intrusive, safe way to understand your query workload.

This commandline tool captures TCP traffic on your server and decodes the protocol. It decodes and times queries, and outputs them in a standard log format. You can use standard log analysis tools such as Percona Toolkit’s pt-query-digest to analyze the output and build insight into queries and server performance.

The tool is built on VividCortex’s advanced network traffic capture technology and is …

  [Read more...]
Getting Started Galera with Docker, part 2
+0 Vote Up -0Vote Down

By Erkan Yanar

In the previous article of this series, we described how to run a multi-node Galera Cluster on a single Docker host.

In this article, we will describe how to deploy Galera Cluster over multiple Docker hosts.

By design, Docker containers are reachable using port-forwarded TCP ports only, even if the containers have IP addresses. So we will set up port forwarding for all TCP ports that are required for Galera to operate.

The following TCP port are used by Galera:

  • 3306-MySQL port
  • 4567-Galera Cluster
  • 4568-IST port
  • 4444-SST port

  [Read more...]
MySQL in Dockerland
Employee_Team +2 Vote Up -0Vote Down

Around 18 months ago, we launched the first MySQL Linux package repos, marking an important milestone in our efforts to modernize and improve the way we package and deliver MySQL products to our user community. MySQL product development had gone through radical improvements in terms of quality, dependability and sheer output, but the way we […]

ClusterControl on Docker
+0 Vote Up -0Vote Down

Today, we’re excited to announce our first step towards dockerizing our products. Please welcome the official ClusterControl Docker image, available on Docker Registry Hub. This will allow you to evaluate ClusterControl with a couple of commands:

$ docker pull severalnines/clustercontrol

The Docker image comes with ClusterControl installed and configured with all of its components, so you can immediately use it to manage and monitor your existing databases. Supported database servers/clusters:

  • Galera Cluster for MySQL
  [Read more...]
MySQL 5.7.7 RC & Multi Source Replication 40 to 1.
Employee +1 Vote Up -0Vote Down

One of the cool new features in 5.7 Release Candidate is Multi Source Replication, as I previously looked into in 5.7.5 DMR.

I’ve had more and more people like the idea of this, so here’s a quick set-up as to what’s needed and how it could work.

1. Prepare master environments.
2. Prepare 40 masters for replication.
3. Create slave.
4. Insert data into the Masters.

* I originally tried running 50 mysql’s but I just ran out of resources on my old pc, so it’s at …




  [Read more...]
MySQL LogRotate script
+0 Vote Up -0Vote Down

Did you ever try to use log rotate facility in Linux with MySQL?
There is no need to script one for this purpose, it is already installed.
From MySQL spec file, it looks for logrotate.d folder:

# Ensure that needed directories exists
install -d $RBR%{_sysconfdir}/{logrotate.d,init.d}

As well as there is dedicated mysql-log-rotate.sh script for installing logrotate script.
The script path is: /mysql-5.6.24/support-files/mysql-log-rotate.sh

Again from spec file:

# Install logrotate and autostart
install -m 644 $MBD/release/support-files/mysql-log-rotate $RBR%{_sysconfdir}/logrotate.d/mysql …



  [Read more...]
Re: MySQL Enterprise Backup 3.11.0 has been released!!
Employee +0 Vote Up -0Vote Down

Yes, MEB is supported on MAC version macosx10.6.

10 Newer Entries Showing entries 71 to 80 of 34437 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.