Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 41 to 50 of 36258 10 Older Entries
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.

Table and tablespace encryption on MariaDB 10.1
+0 Vote Up -0Vote Down

Mon, 2016-06-13 08:15Jan Lindstrom

MariaDB has a wide set of security features to protect data (see MariaDB Enterprise Security Webinar). To encrypt the data in a MariaDB 10.1 database, you can enable data-at-rest encryption. MariaDB allows the option to select the most suitable level of the encryption in MariaDB: Temporary files, Aria tables, InnoDB tablespaces, InnoDB tables, InnoDB log files and Binlogs. In this article I will explain how to turn on encryption for InnoDB and discuss how encryption …

  [Read more...]
Percona XtraDB Cluster 5.6.30-25.16 is now available
+1 Vote Up -0Vote Down

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on June 10, 2016. Binaries are available from the downloads area or our software repositories.

Percona XtraDB Cluster 5.6.30-25.16 is now the …

  [Read more...]
Running Percona XtraDB Cluster in a multi-host Docker network
+0 Vote Up -0Vote Down

In this post, I’ll discuss how to run Percona XtraDB Cluster in a multi-host Docker network.

With our release of Percona XtraDB Cluster 5.7 beta, we’ve also decided to provide Docker images for both Percona XtraDB Cluster 5.6 and  …

  [Read more...]
Percona Monitoring and Management 1.0.1 Beta
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona Monitoring and Management 1.0.1 Beta on 10 June, 2016.

Like prior versions, PMM is distributed through Docker Hub and is free to download. Full instructions for download and installation of the server and client are available in the documentation.

Notable changes to …

  [Read more...]
Using Galera Replication to Create Geo-distributed Clusters on the WAN webinar video is now available!
+0 Vote Up -0Vote Down

We will show the advantages of having a geo-distributed database cluster and how to create one using Galera Cluster for MySQL. We will also discuss the configuration and status variables that are involved and how to deal with typical situations on the WAN such as slow, untrusted or unreliable links, latency and packet loss. We will demonstrate a multi-region cluster on Amazon EC2 and perform some throughput and latency measurements in real-time.

 

CHECK THE VIDEO

10 Newer Entries Showing entries 41 to 50 of 36258 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.