Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 166 Next 30 Older Entries

Displaying posts with tag: ubuntu (reset)

Reference architecture for a write-intensive MySQL deployment
+0 Vote Up -0Vote Down

We designed Percona Cloud Tools (both hardware and software setup) to handle a very high-intensive MySQL write workload. For example, we already observe inserts of 1bln+ datapoints per day. So I wanted to share what kind of hardware we use to achieve this result.

Let me describe what we use, and later I will explain why.

Server:

  • Chassis: Supermicro SC825TQ-R740LPB 2U Rackmount Chassis
  • Motherboard: Supermicro X9DRI-F dual socket
  • CPU: Dual Intel Xeon Ivy Bridge E5-2643v2 (6x 3.5Ghz cores, 12x HT cores, 25M L3)
  • Memory: 256GB (16x 16GB 256-bit quad-channel) ECC registered DDR3-1600
  • Raid: LSI MegaRAID 9260-4i 4-port 6G/s hardware RAID controller, 512M buffer
  • MainStorage: PCIe SSD HGST FlashMAX II 4.8TB
  • Secondary
  [Read more...]
Getting Started with Sphinx?
+0 Vote Up -0Vote Down
Here are a few videos those of you who are just getting started with Sphinx may find useful. The first video demonstrates a very simple implementation with Ubuntu, PHP, and MySQL. The second video is also about installing on Ubuntu. And, the last video discusses fulltext query syntax. Check ‘em out. Quick Start with Ubuntu [...]
Installing Apache2 With PHP5 And MySQL Support On Ubuntu 14.04LTS (LAMP)
+0 Vote Up -0Vote Down

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 14.04LTS (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on anUbuntu 13.04 server with PHP5 support (mod_php) and MySQL support.

Installing Lighttpd With PHP5 (PHP-FPM) And MySQL Support On OpenSUSE 13.1
+0 Vote Up -0Vote Down

Installing Lighttpd With PHP5 (PHP-FPM) And MySQL Support On OpenSUSE 13.1

Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on an OpenSUSE 13.1 server with PHP5 support (through PHP-FPM) and MySQL support. PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busier sites. I use PHP-FPM in this tutorial instead of Lighttpd's spawn-fcgi.

How To Run privacyIDEA With Apache2 And MySQL On Ubuntu 14.04 LTS
+0 Vote Up -0Vote Down

Howto run privacyIDEA with Apache2 and MySQL On Ubuntu 14.04 LTS

We use the latest 1.0dev0of privacyIDEA. It is available via the python package index or via github.

Installing Lighttpd With PHP5 (PHP-FPM) And MySQL Support On Ubuntu 14.04LTS
+0 Vote Up -0Vote Down

Installing Lighttpd With PHP5 (PHP-FPM) And MySQL Support On Ubuntu 14.04LTS

Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on an Ubuntu 14.04 server with PHP5 support (through PHP-FPM) and MySQL support. PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busier sites. I use PHP-FPM in this tutorial instead of Lighttpd's spawn-fcgi.

Using Percona Server 5.6 with the Docker open-source engine
+0 Vote Up -0Vote Down

There are a couple of posts about setting up Percona XtraDB Cluster on Vagrant and Percona Server on MySQL Sandbox – those are two of the top tools used by the Percona Support team for testing and bug processing among other things.

In this post, however, I will show you how to use Docker with Percona Server on Ubuntu 12.04.

As per Docker’s official site:

Docker is an open-source engine that automates the deployment of any application as a lightweight, portable, self-sufficient container that will run virtually

  [Read more...]
Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 14.04 LTS
+1 Vote Up -0Vote Down

Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 14.04 LTS

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 14.04 server with PHP5 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP) .

The Perfect Server - Ubuntu 14.04 (nginx, BIND, MySQL, PHP, Postfix, Dovecot and ISPConfig 3)
+0 Vote Up -0Vote Down

The Perfect Server - Ubuntu 14.04 (nginx, BIND, MySQL, PHP, Postfix, Dovecot and ISPConfig 3)

This tutorial shows how to prepare an Ubuntu 14.04 (Trusty Tahr) server (with nginx, BIND, Dovecot) for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache or nginx web server, Postfix mail server, Courier or Dovecot IMAP/POP3 server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. This setup covers nginx (instead of Apache), BIND (instead of MyDNS), and Dovecot (instead of Courier).

Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 14.04LTS)
+0 Vote Up -0Vote Down

Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 14.04LTS)

This document describes how to install a Postfix mail server that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier (Courier-POP3, Courier-IMAP), so that Courier can authenticate against the same MySQL database Postfix uses.

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 13.10 (LAMP)
+0 Vote Up -0Vote Down

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 13.10 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on anUbuntu 13.04 server with PHP5 support (mod_php) and MySQL support.

The Perfect Server - Ubuntu 14.04 (Apache2, PHP, MySQL, PureFTPD, BIND, Dovecot, ISPConfig 3)
+0 Vote Up -0Vote Down

The Perfect Server - Ubuntu 14.04 (Apache2, PHP, MySQL, PureFTPD, BIND, Dovecot, ISPConfig 3)

This tutorial shows how to prepare an Ubuntu 14.04 (Trusty Tahr) server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache or nginx web server, Postfix mail server, Courier or Dovecot IMAP/POP3 server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. This setup covers Apache (instead of nginx), BIND (instead of MyDNS), and Dovecot (instead of Courier).

Ubuntu 14.04 – some MySQL ecosystem notes
+1 Vote Up -0Vote Down

Following my previous post on the launch, I just rolled Ubuntu 14.04 LTS on an Amazon EC2 t1.micro instance (not something you expect to run a database server on, for sure – 1 vCPU, 0.613GiB RAM). If you do an apt-cache search mysql you get 435 return result sets with the default configuration (trusty: main & universe).

If you do apt-get install mysql-server, you get MySQL 5.5. You enter the password of choice, and before you know it, MySQL is installed (a SELECT VERSION() will return 5.5.35-1ubuntu1).

Next you decide to install MariaDB. I run an apt-get install mariadb-server. It pulls in libjemalloc (for TokuDB) and I expect future releases to ship this engine by default. You enter the password, and

  [Read more...]
Congratulations Ubuntu, for the wide choice!
+1 Vote Up -0Vote Down

Inspired by Yngve Svendsen’s post, I too think it makes absolute sense to congratulate Ubuntu on the 14.04 LTS release (some server notes - MySQL has a section dedicated to it). Ubuntu users have a lot of server choice today (that’s from all major MySQL ecosystem vendors):

  • MySQL 5.5.35 ships in main. It is the default MySQL. Oracle has committed to providing updates to 5.5 throughout the LTS release cycle of Ubuntu (which is longer than the planned EOL for 5.5). This is why the grant of a
  [Read more...]
Percona Software in Ubuntu 14.04 LTS (Trusty Tahr) release
+0 Vote Up -0Vote Down

I’d like to congratulate Canonical with the new Ubuntu 14.04 LTS (Trusty Tahr) Release, it really looks like a great release, and I say it having my own agenda It looks even more great because it comes with a full line of Percona Software.
If you install Ubuntu 14.04 and run aptitude search you will find:


  [Read more...]
Ubuntu 14.04 LTS first impressions
+0 Vote Up -0Vote Down

The Trusty Tahr is out with support for 5 years. Here are the first thoughts about it…

Stupid Browser comes up when searching “Appearance”
  • Unity feels more responsive than ever, especially the Alt+Tab.
  • New Desktop environments these days (also read as Cinnamon, GNOME Shell) take up a lot of RAM, I wanted to test 14.04′s unity, after few hours usage it too scooped up 320 MB worth of RAM… I expected better
  • One thing that definitely annoyed me a lot
  [Read more...]
Percona server 5.5/5.6 installation failed on Ubuntu 13.04/13.10(amd64)
+0 Vote Up -0Vote Down
While installing Percona Server 5.5/5.6 on Ubuntu 13.04/13.10, I got some weird errors, which I never faced before. Errors were something like, dpkg: error processing /var/cache/apt/archives/libmysqlclient18_1%3a5.5.35-rel33.0-611.raring_amd64.deb (–unpack):   libmysqlclient18:amd64 1:5.5.35-rel33.0-611.raring (Multi-Arch: no) is not co-installable with libmysqlclient18 which has multiple Continue reading →   [Read more...]
Correcting mysql.sock connection error
+0 Vote Up -0Vote Down

I write this post over to have a quick access to this tutorial than to promote the blog. The problem For Several times this has happened to me, always install a new server, or personal machine. I install mysql ,… Continue Reading →

Continue reading Correcting mysql.sock connection error

Related posts:
  • Corrigindo erro de conexão com mysql.sock
  • zend framework 2 with lighttpd
  • Main Subversion commands
  • MariaDB & distributions update, Dec 2013
    +1 Vote Up -0Vote Down

    A few things to note recently, amongst MariaDB in distributions. 

  • Ubuntu keeps MySQL 5.5 despite MariaDB’s success. There’s a lot of reasons for this, but remember the key takeaway here is MySQL 5.5 & the fact that MariaDB wasn’t even in Debian yet when the decision was made.
  • MariaDB is now inside of Debian/sid – check out the packages.
  • RHEL 7 comes with MariaDB 5.5 as a default; this is a good thing.
  • Now, from a distribution standpoint, we’re looking at starting to ship

      [Read more...]
    Using the PAM authentication plugin
    +2 Vote Up -0Vote Down
    The procedure for using the PAM authentication plugin as documented doesn't work flawlessly on Ubuntu.

    So here is how it works on Ubuntu (and probably also on other Debian based systems).

    Please note that the PAM authentication plugin is an enterprise feature.

    1. Make sure the plugin is loaded

    This can be done by adding the following to the mysqld section of my.cnf (Don't forget to restart). You could also use INSTALL PLUGIN to load it without restart.
    plugin-load=authentication_pam.so
    2.  Add a user which will use the plugin

    mysql> CREATE USER 'dveeden'@'localhost' IDENTIFIED WITH authentication_pam;
    Query OK, 0 rows affected (0.00 sec)
    3. Add a pam config file for 'mysql':
    Create












      [Read more...]
    Percona Server 5.6.14 with TokuDB 7.1 Experimental build
    +1 Vote Up -0Vote Down

    We just announced Percona Server 5.6.14 release, and I decided to make this build with the TokuDB 7.1 engine.
    The build is available here in the TESTING area.

    You are welcome to play with these binaries, but keep in mind:

    • This is an experimental build and not supposed to be used in production environment
    • The binaries built on Ubuntu 12.04 LTS server and may not work on other Linux distributions

    The post Percona Server 5.6.14 with TokuDB 7.1 Experimental build appeared first on MySQL Performance Blog.

    Installing MySQL on Ubuntu and CentOS
    +0 Vote Up -0Vote Down
    MySQL is one of the most famous Open Source Relational Database Management System (RDBMS) created by Michael Widenius. Default choice in systems as WordPress and used by top companies as Google and Wikipedia. Due its simplicity and large community, it is largely used by developers and webmasters around the world. MySQL is under dual license: […]
    An Ubuntu PPA of daily builds of Percona XtraBackup
    +1 Vote Up -0Vote Down

    Run Ubuntu and want to try new features of Percona XtraBackup? Well, now you can. We have a Personal Package Archive (PPA) percona-daily/percona-xtrabackup. Every time code is pushed to our main source code repository, the PPA is updated.

    We are currently building for Ubuntu lucid (10.04LTS), Precise (12.04), Quantal (12.10) and Raring (13.04).

    To add the repository to your Ubuntu system, simply run:

    sudo add-apt-repository ppa:percona-daily/percona-xtrabackup

    You will now have daily builds of Percona XtraBackup available to install.

    Currently, we are in the process of working on the 2.1.4 release. The daily builds currently include some code that is destined

      [Read more...]
    Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 13.04
    +0 Vote Up -0Vote Down

    Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 13.04

    Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 13.04 server with PHP5 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP) .

    Installing Apache2 With PHP5 And MySQL Support On Ubuntu 13.04 (LAMP)
    +0 Vote Up -0Vote Down

    Installing Apache2 With PHP5 And MySQL Support On Ubuntu 13.04 (LAMP)

    LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 13.04 server with PHP5 support (mod_php) and MySQL support.

    On big technical meetings, or why the end of the UDS is a bad idea
    +0 Vote Up -0Vote Down

    Canonical has just announced that the Ubuntu Developer Summit will no longer be face to face and every six months. Instead it will be entirely online and virtual, using Google Hangouts. (Here is the announcement.)

    On the surface, this seems like a good idea: It's cheaper monetarily, it appears to open things up to people who are unable to travel, and it makes it easier to make complete records.

    However, I think it's a bad idea, for several interrelated reasons.

    Some decision making needs face-time to happen. For whatever reasons, internet-only communication is not enough for a good enough "meeting of the minds" for sticky or subtle engineering and design decisionmaking.

    The IETF, who probably



      [Read more...]
    AppArmor and MySQL
    Employee +0 Vote Up -0Vote Down

    MySQL accesses files in various places on the file system, and usually this isn't something to worry about. For example, in a standard MySQL 5.5 installation on Ubuntu, the data goes in /var/lib/mysql, and the socket is a file in /var/run/mysqld. It puts configuration files in /etc, logs and binaries in various locations, and it even needs to access some operating system files such as /etc/hosts.allow.

    This is all very well until you start trying to be clever and get MySQL to access other parts of the file system. After all, you can configure the location of data, log files, socket, and so on, so why shouldn't you use those settings to optimize your system? Unfortunately, on many modern Linux distributions, it's not that always easy.

    Take Ubuntu, for example. Ubuntu comes with something called AppArmor, a kernel-integrated application security system that controls how

      [Read more...]
    Upgrading to MySQL 5.5 on Ubuntu 10.04 LTS
    +4 Vote Up -0Vote Down

    Ubuntu does not provide an apt-get repository package for MySQL 5.5 on this older OS, however this is still a widely used long term support version. The following steps will upgrade an existing MySQL 5.1 apt-get version to a standard MySQL 5.5 binary.

    Step 1. Remove existing MySQL 5.1 retaining data and configuration

    sudo su -
    service mysql stop
    cp -r /etc/mysql /etc/mysql.51
    cp -r /var/lib/mysql /var/lib/mysql.51
    which mysqld
    dpkg -P mysql-server mysql-server-5.1 mysql-server-core-5.1
    which mysqld
    which mysql
    dpkg -P mysql-client-5.1 mysql-client-core-5.1
    which mysql
    dpkg -P libdbd-mysql-perl libmysqlclient16 mysql-common
    # This will not remove /etc/mysql if any other files are in the directory
    dpkg -l | grep mysql
    [ -d /etc/mysql ] && mv /etc/mysql /etc/mysql.uninstall
    cp -r /etc/mysql.51 /etc/mysql
    

    2. Prepare configuration  [Read more...]

    How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10
    +1 Vote Up -0Vote Down

    How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10

    mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. This article shows how to use it on an Ubuntu 12.10 server.

    How To Install Percona Server 5.5 On Ubuntu 12.10
    +0 Vote Up -1Vote Down

    How To Install Percona Server 5.5 On Ubuntu 12.10

    Percona Server is a drop-in replacement for MySQL. It offers more performance and scalability than the default MySQL server coming with your Linux distribution, while it uses the same init scripts and command line tools which makes it easy to use. This tutorial explains how to install Percona Server 5.5 on Ubuntu 12.10.

    Showing entries 1 to 30 of 166 Next 30 Older Entries

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