Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 121 to 130 of 36359 10 Older Entries
Scaling Percona XtraDB Cluster with ProxySQL in Docker Swarm
+1 Vote Up -0Vote Down

In this post, we’ll look at scaling Percona XtraDB Cluster with ProxySQL in Docker Swarm.

In my previous post, I showed how to employ Percona XtraDB Cluster on multiple nodes in a Docker network.

The intention is to be able to start/stop nodes and increase/decrease the cluster size dynamically. This means that we should track running nodes, but also to have an …

  [Read more...]
Understand what has changed between MySQL 5.6 and 5.7 before upgrading
+0 Vote Up -0Vote Down

MySQL 5.7 has been GA since October 2015. At the time of writing, it is still a very new release. But more and more companies are looking into upgrading, as it has a list of great new features. Schema changes can be performed with less downtime, with more online configuration options. Multi-source and parallel replication improvements make replication more flexible and scalable. Native support for JSON data type allows for storage, search and manipulation of schema-less data.

An upgrade, however, is a complex process - no matter which major MySQL version you are upgrading to. There are a few things you need to keep in mind when …

  [Read more...]
sync_binlog = 1 in MySQL 5.7
Employee +1 Vote Up -0Vote Down

As Morgan announced it his blog post related to new defaults in 5.7, in 5.7.7 and newer the default value of sync_binlog is now 1.

This of course has an impact on performance especially if you don’t have fast storage like a RAID controller with a cache for example.

Already in O’reilly High Performance MySQL, is was written that the most important setting for binary logging on the master is sync_binlog = 1.

And …

  [Read more...]
MySQL Workbench 6.3.7 GA has been released
Employee +1 Vote Up -0Vote Down
The MySQL developer tools team announces 6.3.7 as our GA release for MySQL Workbench 6.3. 

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/list.php?152

Download MySQL Workbench 6.3.7 GA now, for Windows, Mac OS X 10.9+, 
Oracle Linux 6 and 7, Fedora 23 and Fedora 24, Ubuntu 16.04 or sources, from:








  [Read more...]
MySQL Workbench 6.3.7 GA has been released
Employee_Team +1 Vote Up -0Vote Down

Dear MySQL users,

The MySQL developer tools team announces 6.3.7 as our GA release for
MySQL Workbench 6.3.

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?152

Download MySQL Workbench 6.3.7 GA now, for Windows, Mac OS X 10.9+,
Oracle Linux 6 and 7, Fedora 23 and Fedora 24, …




  [Read more...]
MySQL 5.7: New Audit Log Filtering Feature – Part 1
Employee_Team +3 Vote Up -0Vote Down

Security auditing plays important role in the process of securing a database system. Thanks to the MySQL Enterprise Audit extension, we can record all activities, such as client connections and execution of queries into a single log file, for later inspection.…

Restoring MySQL Database from xtrabackup – facepalm moments
+0 Vote Up -0Vote Down

Learning from facepalm moments of a MySQL database restore from Percona Xtrabackup.

MySQL Docker Containers: Understanding the basics
+1 Vote Up -0Vote Down

Docker is quickly becoming mainstream, as a method to package and deploy self-sufficient applications in primarily stateless Linux containers. But for a stateful service like a database, this might be bit of a headache. How do we best configure MySQL in a container environment? What can go wrong? Should we even run our databases in a container environment? How does performance compare with e.g. running on virtual machines or bare-metal servers? How do we manage replicated or clustered setups, where multiple containers need to be created, upgraded and made highly available?

So, welcome to our new blog series - “MySQL on Docker”. We will touch …

  [Read more...]
Advanced MySQL Slow Query Logging Part 2: pt-query-digest report
+0 Vote Up -0Vote Down

Proper MySQL Query Optimization starts with a proper Slow Query Logging session. And MySQL Query Optimization is where I spend 70-80% of my time when doing MySQL performance optimization.

Here in part 2, we will go over the pt-query-digest report, that we have prepared in part 1.

The post Advanced MySQL Slow Query Logging Part 2: pt-query-digest report appeared first on Speedemy.

How to Install ownCloud 9 with Nginx on OpenSUSE Leap 42.1
+0 Vote Up -0Vote Down

OwnCloud provides Self-hosted file syncing and sharing with a nice web interface and syncing apps for all major mobile and desktop platforms with a functionally like Dropbox, mega, etc. ownCloud makes it easy to access and sync files, calendars, and contacts across your devices. In this tutorial, I will guide you to create your own sync and share server platform with ownCloud. We will install ownCloud with Nginx as the web server, MariaDB (a MySQL fork) as the database and php-fpm to handle the request for php on Linux OpenSUSE Leap 42.1.

10 Newer Entries Showing entries 121 to 130 of 36359 10 Older Entries

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