Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 36184 10 Older Entries
How to Install Nginx, PHP and MySQL (LEMP Stack) on OpenSUSE Leap 42.1
+0 Vote Up -0Vote Down

LEMP or Linux, Engine-x, MySQL, and PHP is a collection of software installed on the Linux operating system to get your PHP based web applications up and running on the fast Nginx web server. In this tutorial, I will show you how to install Nginx, MariaDB, and PHP-FPM on openSUSE leap 42.1. Then I will configure the OpenSUSE firewall with SuSEfirewall2 to allow access to the Nginx web server and show you how you can add a new virtual host configuration on the Nginx web server.

Press Release: Severalnines protects the UK insurance industry from risky bets
+0 Vote Up -0Vote Down

Fast, thorough database technology helps IIL handle over 100 million transactions a day

Stockholm, Sweden and anywhere else in the world - 31st May 2016 - Severalnines, the award-winning provider of database infrastructure management software, today announced its latest customer, IIL, a UK-based data and technology company. IIL specialises in providing pricing, fraud and compliance technology for insurance and credit providers.

Insurance providers rely on IIL to authenticate customer details …

  [Read more...]
How fall in love with Failing assertion: !m_fatal?
+0 Vote Up -0Vote Down

The story about real love.
Once upon a time there was a bug about resizing innodb buffer pool size online ->
#77564 which was fixed on version MySQL 5.7.9.
But you can not stop the real love. Suddenly she came up and truely surprised me,because I was recently freed from depression. And now the same thing is happening again. With MySQL 5.7.12 if you try to resize:

mysql> set global innodb_buffer_pool_size = 107374182400;
Query OK, 0 rows affected (0.01 sec)

2016-05-31 11:50:18 0x7f7926ba1740 InnoDB: …





  [Read more...]
Speaking in June 2016
+0 Vote Up -0Vote Down

I have a few upcoming speaking engagements in June 2016:

  • Nerdear.la – June 9-10 2016 – Buenos Aires, Argentina – never been to this event but MariaDB Corporation are sponsors and I’m quite excited to be back in Buenos Aires. I’m going to talk about the MySQL ecosystem in 2016.
  • SouthEast LinuxFest – June 10-12 2016 – Charlotte, NC, USA – I have a few talks here, a bit bummed that I’m going to be missing the speaker dinner, but I expect this to be another great year. Learn about …
  [Read more...]
Codership Galera Cluster Webinar – Using Galera Replication to Create Geo-distributed Clusters on the WAN-June 9th
+0 Vote Up -0Vote Down

Description

In this webinar, 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.

USA Time:  10-11 AM PDT (Pacific Standard Time), 9th of June

  [Read more...]
Become a ClusterControl DBA - SSL Key Management and Encryption of MySQL Data in Transit
+0 Vote Up -0Vote Down

Databases usually work in a secure environment. It may be a datacenter with a dedicated VLAN for database traffic. It may be a VPC in EC2. If your network spreads across multiple datacenters in different regions, you’d usually use some kind of Virtual Private Network or SSH tunneling to connect these locations in a secure manner. With data privacy and security being hot topics these days, you might feel better with an additional layer of security.

MySQL supports SSL as a means to encrypt traffic both between MySQL servers (replication) and between MySQL servers and clients. If you use Galera cluster, similar …

  [Read more...]
Codership Galera Cluster Webinar USA – Using Galera Replication to Create Geo-distributed Clusters on the WAN-June 9th
+0 Vote Up -0Vote Down

Description

In this webinar, 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.

Time:  10-11 AM PDT (Pacific Standard Time), 9th of June

  [Read more...]
Codership Galera Cluster Webinar EMEA – Using Galera Replication to Create Geo-distributed Clusters on the WAN-June 9th
+0 Vote Up -0Vote Down

Description

In this webinar, 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.

Time:  11-12 AM EEST (Eastern European Standard Time), 9th of June

  [Read more...]
systemd: a revolution gets used to itself
+0 Vote Up -0Vote Down

New versions of systemd (like in Ubuntu 16.04) are able to configure pid Cgroups (ulimit -u via Cgroups) using TasksMax.

Check the commit implementing TaksMax.

Author: Lennart Poettering <lennart@poettering.net>
Date:   Fri Nov 13 19:28:32 2015 +0100

    core: enable TasksMax= for all services by default, and set it to 512

    Also, enable TasksAccounting= for all services by default, too.

    See:

    http://lists.freedesktop.org/archives/systemd-devel/2015-November/035006.html

But not we’ve got silly defaults:

$ systemctl show -p TasksMax docker
TasksMax=512

$ …
  [Read more...]
Linux User-Group Console
+0 Vote Up -0Vote Down

This post shows you how to add the menu option and GUI to set users and groups. It’s quite a bit easier than mastering all the command-line syntax. It makes setting up the required user and group accounts for an Oracle Enterprise or MySQL database solution much easier.

You add the utility by calling the yum (Yellowdog Updater, Modified) utility like this:

yum installed -y system-config_users

You should see the following:

Loaded plugins: langpacks
adobe-linux-x86_64                                       |  951 B     00:00     
ol7_UEKR3 …
  [Read more...]
Showing entries 1 to 10 of 36184 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.