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 中文
Previous 30 Newer Entries Showing entries 61 to 90 of 1130 Next 30 Older Entries

Displaying posts with tag: Linux (reset)

MySQL PAM and Active Directory authentication
+0 Vote Up -0Vote Down

How-To configure your MySQL to use PAM and/or Active Directory authentication with percona-pam-authentication plugin.
Continuing articles about Two-Factor authentication or integrating Linux services with Active Directory, this How-To is one of my recent works that I have done these days, so I hope it may help the community with this guide to configure MySQL with PAM and subsequently using Active Directory to authenticate. If you are new here, please refer to SSH Two-Factor authentication, which explains how to install likewise and integrate your Linux with AD. However, we will have few exceptions to get MySQL working  [Read more...]
MySQL Backups, The Tools So Far
+1 Vote Up -0Vote Down

Backups is one of the most important part of any MySQL deployment, and nowadays, there’s a number of tools to choose from depending on how your organization implements them. The purpose of this post is to enumerate the main tools and some helpers that makes backing up and testing/restoring your backups more convenient. By all means this is not the complete list, I’m sure I am missing some, so feel free to add them through the comments.

The Core Tools

  • mysqldump – is a logical backup tool for MySQL. It creates plain text files with SQL statements which you can directly import back to the server. Some would say mysqldump is not really a backup tool as you cannot get a consistent backup without disrupting operations while the server is running. I’d say this is
  [Read more...]
ZFS on Linux and MySQL
+3 Vote Up -1Vote Down

I am currently working with a large customer and I am involved with servers located in two data centers, one with Solaris servers and the other one with Linux servers. The Solaris side is cleverly setup using zones and ZFS and this provides a very low virtualization overhead. I learned quite a lot about these technologies while looking at this, thanks to Corey Mosher.

On the Linux side, we recently deployed a pair on servers for backup purpose, boxes with 64 300GB SAS drives, 3 raid controllers and 192GB of RAM. These servers will run a few slave instances each of production database servers and will perform the backups.  The write load is not

  [Read more...]
Some LSI 9211-8i issues on Windows and Linux
+0 Vote Up -0Vote Down
tl;dr:
Make sure you flash an LSI-9211 to IT firmware rev#14 to get it to work 
with Linux and SSD trim.  You may have to downgrade from newer firmware
to older firmware to get the card to work.


Finding a SATA III controller with more than one PCI-e lane
After a recent hardware issue I decided to upgrade my computer to use new Intel 520 120MB SSD drives in RAID for improved performance.  The motherboard I use (an ASUS Rampage III extreme) has a Marvel SATA III controller with two ports, but I discovered that it is connected via only a single PCI-e lane (each lane can do at most 400MB/sec*).  This means that it can't effectively support even a single Intel 520 because one device can saturate the SATA III bus (An Intel 520 is rated at up to 550MB/sec sequential write).

So I went on a quest for a new SATA 3 controller.   To




  [Read more...]
#DBHangops for 5/15/13 — Filesystems, monitoring, settings, Oh my!
+0 Vote Up -0Vote Down

Here’s the recording!

Heyo!

Now that we’ve gone through the Percona Live MySQL Conference and Expo review and had an amazing turnout to talk about it, it’s time to open up the discussion around things that DBAs want to talk about and need to be conscientious of. Join us on Wednesday at 12:00pm PDT (19:00 GMT) to take part in the discussion and share your knowledge and experience with the following topics:

  • Filesystems and MySQL — Which do you use and why?
    • Do you handle I/O alignment? How do you do it?
    • Scheduler changes?
  • Nagios checks! — Any new checks you’ve added recently?
  • The worst settings in MySQL that you always change
  • What are the most important variables to you,

  [Read more...]
Storage caching options in Linux 3.9 kernel
+0 Vote Up -0Vote Down

dm-cache is (albeit still classified “experimental”) is in the just released Linux 3.9 kernel. It deals with generic block devices and uses the device mapper framework. While there have been a few other similar tools flying around, since this one has been adopted into the kernel it looks like this will be the one that you’ll be seeing the most in to the future. It saves sysadmins the hassle of compiling extra stuff for a system.

A typical use is for an SSD to cache a HDD. Similar to a battery backed RAID controller, the objective is to insulate the application from latency caused by the mechanical device, the most laggy part of which is seek time (measured in milliseconds). Giventhe  relatively high storage capacity of an SSD (in the hundreds of GBs), this allows you to mostly disregard the mechanical latency for writes and that’s very useful for

  [Read more...]
2013 MySQL Conference and Expo — a #DBHangOps Review
+0 Vote Up -0Vote Down

Hey everybody!

The Percona Live MySQL Conference and Expo just wrapped up last week and we’re looking to get some conference in review talk from everyone! Talk about your favorite sessions, new things you learned, and your overall opinion of the conference!

Hop online Wednesday at 12:00pm PDT (19:00 GMT) to join the discussion and share your experience from the 2013 Percona Live: MySQL Conference and Expo.

Be sure to watch this twitter search or this blog post get a link for the google hangout tomorrow!

Some talks that were specifically called out:

  [Read more...]
Connecting your Linux to a Cisco AnyConnect (SSL) – part 3
+0 Vote Up -0Vote Down

Hi there !

 

This is the final part of using openconnect  - You can check the older ones below:

http://www.heitorlessa.com/connecting-your-linux-to-a-cisco-anyconnect-ssl-part-1/

http://www.heitorlessa.com/connecting-your-linux-to-a-cisco-anyconnect-ssl-part-2/

 

As mentioned previously, we will be covering here:

  • How to create a script to monitor such VPN using ICMP, and restart that VPN if it is down

 

I would say, this is very straight forward and does not require much knowledge, so we are going to follow the same procedure as part 2 – Show the script in


  [Read more...]
Connecting your Linux to a Cisco AnyConnect (SSL) – Part 2
+0 Vote Up -0Vote Down

Hey you!

As said in the part 1 of this article, I will be covering here:

  • How to create a openconnect init script

So, concerning the init script I will be posting parts of the script first, and then will put a link for download at the end.

First of all, we need the shebang (#!/bin/bash) and then global variables that will be used along the script:

# Path variables
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"

# VPN Variables
IFACE="sslvpn"
VPN_USER="vpn_user"
VPN_HOST="sslvpn.yourdomain.com"
VPN_PASS="vpn_password"
PID="/var/run/openconnect.pid"
  [Read more...]
Check (Rough) Progress of Your CSV Import to MySQL
+0 Vote Up -0Vote Down

If you are importing large CSV or SQL dumps to MySQL, chances are you were looking for ways to see how far the import has gone. If you know how many rows there are from the file being imported, you can do a SELECT COUNT(*) but that would take sometime for the query to finish especially on really big imports.

Using lsof, you can monitor the current file offset to which a process is reading from using the -o option. Knowing the size of the file and some snapshots of the offset, you can get a somewhat rough idea of how fast the import goes. Note though that this is only file-read-pace not actual import speed as MySQL import can vary depending on a number of conditions i.e. table growth, secondary indexes, etc.

Let’s say I am importing a 1.1G CSV file into a table.

[revin@forge msb_5_5_300]$ ls -al
  [Read more...]
How To Run Your Own Web SMS Portal With PointSMS
+0 Vote Up -0Vote Down

How To Run Your Own Web SMS Portal With PointSMS

This tutorial will show you how you can set up an SMS web site on CentOS using PointSMS.

#DBHangOps 3/27/13!
+0 Vote Up -0Vote Down

Hi everyone!

Here’s a video of this week’s #DBHangOps:

March 27th at 12:00pm PDT (19:00 GMT) is when the next #DBHangOps is gonna go down. Check out the twitter search and hop on the google hangout to contribute some discussion! This week’s topics are:


  [Read more...]
How to fix the Percona repo failure when installing Percona Toolkit
+0 Vote Up -0Vote Down

Here’s a solution to the not-so-long-standing issue of the Percona yum repo being broken for the CentOS 6 x86_64 version of the Percona-toolkit package. The repo listing is reporting an older version of the RPM which is not available on the site, so to fix this you just have to download the newer file and tell yum to add it locally. The side benefit is that you can use Yum to manage the RPM without adding the Percona repo, since the default settings for their repo could/have/had caused conflicts with Base Repo versions of MySQL packages; the Percona repo instructions set ‘enabled=1′ — not a great idea if you’re not setup to use the Yum priorities method of repo weighting.

So, if you see this after installing the repo via the instructions on their site:
Downloading Packages:


  [Read more...]
Cloudflare, now offering to be your Single Point of Failure
+0 Vote Up -0Vote Down

There have been many articles about the downtime issue with Cloudflare last week, so I won’t get into the technical details of that. However, there’s the fine print to remember. Consider this a subtle reminder that core Internet infrastructure services like Cloudflare’s DNS-based “Always Online” caching and packet inspection security services do not come with Service Level Agreements even at the “Pro” account level. Even with a Pro account you are paying for a service with no uptime guarantee and you must only hope that it resolves your sites the majority of the time. This is fine, this is what the contract says: no SLA unless you pay for the Business account. An odd naming convention given that most Professionals are using their websites for business and would want the SLA, but I digress.

So,

  [Read more...]
openSUSE 12.3 released with MariaDB as default
+5 Vote Up -4Vote Down

Congratulations to the openSUSE community on a successful release of openSUSE 12.3. A highlight worth mentioning is that MariaDB is now the default as opposed to MySQL. What are you waiting for, download it!

From the features list, here’s an excerpt focusing on MariaDB & MySQL:

openSUSE has moved from MySQL to MariaDB as default. MariaDB was first shipped with openSUSE 11.3 back in 2010. Over the years it proved itself and starting with 12.3 openSUSE is replacing default MySQL implementation with MariaDB. This means that whole distribution is compiled against MariaDB and in ‘M’ in LAMP means MariaDB from now. As

  [Read more...]
Using MariaDB on CentOS 6
+4 Vote Up -0Vote Down

This is just for testing purposes, but you might want to play around with MariaDB 5.5.29 coming via the CentOS 6 repositories as mentioned in this post. Please test it out and report bugs if required. The process was simple on a fresh install:

yum update
cd /etc/yum.repos.d/
wget http://dev.centos.org/centos/6/mariadb/mariadb.repo
yum list mariadb\*
yum install mariadb-server mariadb
/etc/init.d/mysqld start

That’s it, it just works. It comes with MEMORY, CSV, MRG_MYISAM, BLACKHOLE, MyISAM, PERFORMANCE_SCHEMA, ARCHIVE, FEDERATED, InnoDB (XtraDB) and Aria.

Remember this replaces mysql-libs, and is set to replace MySQL in your install. Here’s hoping it hits mainline CentOS soon.

Related posts:

  •   [Read more...]
    Is MySQL bigger than Linux?
    +0 Vote Up -0Vote Down

    I’m going to take the numbers from my previous post, MySQL Modularity, Are We There Yet? for the “kernel” size of MySQL – that is, everything that isn’t a plugin or storage engine.

    For Linux kernel, I’m just going to use the a-bit-old git tree I have on my laptop. I’ve decided that the following directories are for “plugins” drivers/ arch/ sound/ firmware/ crypto/ usr/ virt/ tools/ scripts/ fs/*/* and everything else is core kernel code.

    Version Total LoC Total Plugin LoC Remaining (kernel) MySQL 5.6.10 1,049,344 265,189 784,155 (74% kernel) MariaDB 5.5 1,142,118  [Read more...]
    Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Scientific Linux 6.3
    +0 Vote Up -1Vote Down

    Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Scientific Linux 6.3

    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 a Scientific Linux 6.3 server with PHP5 support (through PHP-FPM) and MySQL support.

    Building a MySQL Private Cloud: Step 1
    +1 Vote Up -0Vote Down

    Building clusters is usually a fun time. Here’s one of my setups at the Equinix LAX1 facility that is being used for VPN services, OpenVZ clustering, and general RADIUS and MySQL clustering integration. Once the clustering design is finalized, it’s still in flux state while I try out different setups, I’ll post some physical+logical architecture diagrams to show “How to Build a Fault Tolerant Infrastructure for Virtualized MySQL NDB Cluster + Python-based VPN systems.” Stay tuned for more.

    Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
    +0 Vote Up -2Vote Down

    Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet

    Following Roel’s post, Percona Server on the Raspberry Pi: Your own MySQL Database Server , I thought what other crazy gadget can I run Percona Server on? And having an Asus Nexus 7 Android tablet I decided to give it a try.

    Anything below contains a risk that you break your tablet if

      [Read more...]
    Installing Apache2 With PHP5 And MySQL Support On Scientific Linux 6.3 (LAMP)
    +0 Vote Up -0Vote Down

    Installing Apache2 With PHP5 And MySQL Support On Scientific Linux 6.3 (LAMP)

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

    OpenVZ and Amazon S3: how to solve the dreaded connection throttle failure
    +0 Vote Up -0Vote Down

    Sometimes we encounter odd application responses that seem to make no sense. One of these such issues is related to running virtual server instances (OS Containers not Para-Virtualized VMs) and attempting to back up their data to Amazon’s S3 cloud storage. For moderately sized virtual machines running MySQL databases or Python/PHP based websites and code repositories this can be an inexpensive, quickly provisioned, and easy way to provide disaster recovery backups in numerous geographic locations, since we generally want DR content to be located in a physically distant location. Nevertheless, we can encounter errors if using an S3 mount in a distance location from our server if the timezone/sync data is incorrect.

    The commonly seen error is as follows – and it doesn’t give much information for

      [Read more...]
    #DBHangOps 02/27/13
    +1 Vote Up -0Vote Down

    EDIT: Video from today’s #DBHangOps!

    Hey there peeps!

    February 27th at 12:00pm PST it is! Check back here for more info and keep a watchful eye on the twitter search (and feel free to join the conversation!). The topics we’re looking to cover this week are:

    • Day-to-day pain points (what takes more time than it should?)
      • rolling restarts and upgrades
      • Performing checksums on your data
        $ /usr/bin/pt-table-checksum \
        --quiet \
        --ignore-databases=mysql,percona,information_schema,per
        formance_schema \
        --lock-wait-time=50 \
        --chunk-size-limit=0 \
        --no-check-plan \
        --no-check-binlog-format \
        --max-lag=1 \
        --replicate percona.checksums \
        h=database.example.com











      [Read more...]
    Installing a driver for Microsoft SQL Server and Sybase ASE in Linux and Mac
    Employee_Team +3 Vote Up -0Vote Down

    In a recent post we showed you how to migrate a SQL Server database to MySQL. There, we used the oficial Microsoft ODBC driver and that’s OK if you are running MySQL Workbench in Windows. But what if your desktop OS is some Linux variant or Mac OS X?

    It turns out that Microsoft has recently released an ODBC driver for Linux. However, you can’t use this driver with MySQL Workbench for Linux. (Actually you can, but you would have to rebuild Workbench). The main reason is that this ODBC driver was linked against unixODBC (an ODBC driver manager), while Workbench uses another ODBC driver manager: iODBC and the two of them

      [Read more...]
    The InnoDB Quick Reference Guide is now available
    +3 Vote Up -0Vote Down

    I’m pleased to announce that my first book, the InnoDB Quick Reference Guide, is now available from Packt Publishing and you can download it by clicking here. It covers the most common topics of InnoDB usage in the enterprise, including: general overview of its use and benefits, detailed explanation of seventeen static variables and seven dynamic variables, load testing methodology, maintenance and monitoring, as well as troubleshooting and useful analytics for the engine. The current version of MySQL ships with InnoDB as the default table engine, so whether you program your MySQL enabled applications with PHP, Python, Perl or otherwise, you’ll likely benefit from this

      [Read more...]
    MySQL Performance: MySQL 5.6 GA -vs- MySQL 5.5 tuning details
    Employee +7 Vote Up -0Vote Down

    This post is the next part following the initial article about MySQL 5.6 vs 5.5 benchmark results (and MySQL 5.6 scalability).

    The focus in this article is on the "tuning impact" used during the published tests, and also I have for you few more test results to present which were missed initially -- Sysbench tests using 8 tables instead of a single one (as it does by default).

    All my.conf setting I've used during the tests was already presented within an initial article, so let's go directly to details about special tuning setting.

      [Read more...]
    MySQL Performance: MySQL 5.6 GA and MySQL 5.5 scalability
    Employee +9 Vote Up -0Vote Down

    As promised, this is the first part of details about MySQL 5.6 vs 5.5 benchmark results I've published earlier last week. The following graphs are representing scalability results obtained for both MySQL versions on the published tests (and I have yet more test results to present to you, but these test's are still running)..

    Few remarks based on comments and discussions I've got since then:

    • I'm using a "true" 32cores server (true 32 cores, each one yet has 2 threads (HT), so 64 threads in total)
    • I'm not using "CPU threads" terminology as I'm finding it confusing (for ex. when you're reading "16 CPU
      [Read more...]
    #DBHangOps on 1/30/13 \o/
    +1 Vote Up -0Vote Down

    UPDATE: Here’s the recording, enjoy!

    Hello everybody!

    #DBHangOps coming at you this week, Wednesday 1/30/12 at 12:00pm PST. Be sure to check out this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout.

    This week’s topics were:
    * bug fixes in recent versions
    * Plugins
    ** authorization plugins (e.g. LDAP)
    ** audit plugin API — http://dev.mysql.com/doc/refman/5.5/en/writing-audit-plugins.html
    *** state transitions of records in MySQL with a plugin?
    * InnoDB Status variables from twitter — https://github.com/twitter/mysql/wiki/InnoDB-Status-Variables
    * Table alters/schema changes
    ** Twitter patch for non-blocking alter table (throws a different error than









      [Read more...]
    MySQL Performance: InnoDB heavy I/O RW workloads limits in 5.6
    Employee +7 Vote Up -0Vote Down

    This article was initially planned to follow the previous posts about RW (Read+Write) workloads on MySQL & Linux (part#1, part#2)... But, when I've started to run real MySQL/InnoDB IO-bound tests on the Fusion-io card, I've quickly realized that I'm hitting so hot internal contentions within InnoDB code, that I'm simply unable to use storage capacity on its full power.. So, I've moved to another server (having SSD only), and then continued with it (as to explain RW limits it'll be pretty enough). Also, curiously, on this server XFS performance on writes is way better than EXT4 (while on the the

      [Read more...]
    Packages to get MariaDB and tests up and running
    +0 Vote Up -0Vote Down

    yum

    It’s often pain to guess package names when you need to install stuff on, lets say, CentOS. So there is a list, although maybe not full, of what I needed to get another VM build and run MariaDB server and to execute at least some tests on it (all done via yum install):

    cmake
    gcc
    ncurses-devel
    bison
    g++
    gcc-c++
    aclocal
    automake
    libtool
    perl-DBD-MySQL
    gdb
    libaio-devel
    openssl-devel

    Same in one line, for lazy me:
    sudo yum install cmake gcc ncurses-devel bison g++ gcc-c++ aclocal automake libtool perl-DBD-MySQL gdb libaio-devel openssl-devel

    To install bzr:

    su -c ‘rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-2.noarch.rpm’
    (check the architecture)

    and then can use yum















      [Read more...]
    Previous 30 Newer Entries Showing entries 61 to 90 of 1130 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.