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 31 to 60 of 102 Next 30 Older Entries

Displaying posts with tag: centos (reset)

MariaDB 5.2 repository for RHEL/CentOS
+2 Vote Up -0Vote Down

Until now, MariaDB 5.2 was lacking a yum repository for easy installs and upgrades. It is now available, thanks to OurDelta.

Just follow our very simple installation instructions.

PostGIS 1.5 in Postgresql 9.0 install on CentOS 5.6
+2 Vote Up -0Vote Down

I love short and consist install instructions. I know this is a MySQL blog but our good friend PostGreSQL has a great GIS library. This is what I learned upgrading our PostGIS system to GIS 1.5. Much thanks to Jeremy Tunnell for give this document it’s start.

Start with CentOS 5.6 x86_64 basic install.

Add the PostgreSQL Yum repository to your system.

 $ wget http://yum.pgrpms.org/reporpms/9.0/pgdg-centos-9.0-2.noarch.rpm
 $ rpm -i pgdg-centos-9.0-2.noarch.rpm

Another location for these is DAG. I have to tried these so your results may very.

You will need to exclude the packages CentOS provide by added two lines to the BASE and UPDATE sections of /etc/yum.repos.d/CentOS-Base.repo. They are:

exclude=postgresql*
  [Read more...]
Installing Apache2 With PHP5 And MySQL Support On CentOS 6.0 (LAMP)
+1 Vote Up -0Vote Down

Installing Apache2 With PHP5 And MySQL Support On CentOS 6.0 (LAMP)

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

Installing Lighttpd With PHP5 And MySQL Support On CentOS 5.6
+0 Vote Up -1Vote Down

Installing Lighttpd With PHP5 And MySQL Support On CentOS 5.6

Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a CentOS 5.6 server with PHP5 support (through FastCGI) and MySQL support.

Installing Apache2 With PHP5 And MySQL Support On CentOS 5.6 (LAMP)
+0 Vote Up -3Vote Down

Installing Apache2 With PHP5 And MySQL Support On CentOS 5.6 (LAMP)

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

MySQL Workbench on CentOS
+0 Vote Up -0Vote Down
Every once in a while I use MySQL Workbench. First is was only for Windows, then it was unstable and now it is very well usable. Or at least that is the situation when you run on a recent Ubuntu machine.

I'm now using CenOS 5.5 in a VirualBox VM to do some testing. Unfortunately the download site for MySQL Workbench has RPMs for RedHat 6 and Fedora Core 14 and some other platforms. No CentOS, No RHEL5, only the latest Fedora en RHEL.

So I downloaded the RHEL6 RPMs and tried to install them with yum localinstall, but that failed. So they are not backwards compatible with 5.5.

Turns out that CentOS/RHEL 5 doesn't have the required libraries to support MySQL Workbench.

And unfortunately CentOS 5.5 is still the latest release. So an upgrade to CenOS 6 is not yet possible.
Using HandlerSocket Plugin for MySQL with PHP
+2 Vote Up -0Vote Down

This document was updated and tested for CentOS 6.0

In my last two posts I installed the HandlerSocket plugin into MariaDB and showed how to use it with Perl.  That’s good, but if you are thinking of using HandlerSocket  I’m guessing you have a very high traffic website and it’s written in PHP.  In this post I’m going to connect HandlerSocket with PHP.  In the next post I’ll discuss using HandlerSocket on a production system.

There are a couple of HandlerSocket php modules projects.  I tried each of them and I found PHP-HandlerSocket was the best.  Both of them are still rough and neither of them have documentation beyond their source code.  Maybe this will move things forward.

Here are the applications you need to have installed that where not installed in my last two posts.  Run this to

  [Read more...]
Installing HandlerSocket (NoSQL plugin) into MiariaDB on CentOS 5.5.
+8 Vote Up -1Vote Down

The title says it all. If you don’t know what HandlerSocket is or why you would want to use it you need to reads Yoshinori Matsunobu’s blog post.

Lets get started.

 login as root

Make sure you have these packages installed:

 yum install git perl libtool gcc make openssl-devel gcc-c++ perl-DBI perl-DBD-MySQL.x86_64

If you haven’t already, install MariaDB and it’s source do that first and make sure it works. Look here http://askmonty.org/wiki/MariaDB:Download#Packages for the packages.

I’m using CentOS 5.5 x64 so I used:

 wget http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.4/kvm-rpm-centos5-amd64/rpms/MariaDB-client-5.2.4-94.el5.x86_64.rpm
 wget
  [Read more...]
Downloading, compiling, and installing MySQL Server from source code
+0 Vote Up -0Vote Down

This content has been updated and moved to a new place.


If you are running any GNU/Linux server operating system like RHEL 5 or CentOS 5, you may probably install MySQL server that comes with the operating system packages either during the initial setup or later using yum(8). The advantage being addition/removal of packages either using the GUI package manager or rpm(8), yum(8). Fair enough. But unfortunately the MySQL package (mysql-server) that comes bundled with RHEL 5.5 or CentOS 5.5 is fairly old (5.0.77). What if you want to install the latest stable version of MySQL yet have the advantage of removing/re-installing the software using rpm(8)?


In this blog post, I will guide you with compiling MySQL from source code yet installing the software through rpm(8) so that we tune and



  [Read more...]
[CentOS] OpenVZ – container based virtualization quick guide. Part 1 of 2
+0 Vote Up -0Vote Down

This quick guide will walk you through setting up OpenVZ on CentOS. I followed these steps on CentOS release 5.5 x64 version. If you want more detail on install via different methods and/or have different flavor of CentOS and run into an issue, you can follow instructions provided by OpenVZ site. Once you are done with this guide, you will have CentOS container running for you to play with.

For my purposes, I started with very basic installation of CentOS 5.5. I have done this on existing installations of CentOS without any issues as well. Ok so let’s start with getting the OpenVZ repository added to our system. This means that we will be going down “yum” path instead of “rpm” path. This is the quickest and easiest way to get OpenVZ installed.

cd

  [Read more...]
[Bash] Performing array intersection with Bash
+0 Vote Up -0Vote Down

I am currently working on a project to deploy new website builds to a
small number of servers. I needed something simple and reliable that could
be built in a very short period of time. I decided to whip something up in
bash with the intent of refining it in Python later.

As I began to write this code, I realized that it probably would have been
quicker to do it in Python from the start. I decided to stick with bash as
somewhat of an academic exercise. The vast majority of these deployment
scripts were trivial; check the code out of git, create a manifest, package
it up, spew it to the servers, etc, etc. The problem came during the last
step. We decided to use a symlink to point to the active build out of a
number of builds that could be available on the server at any given time.
Since all of our servers should be









  [Read more...]
MySQL HA with DRDB and Heartbeat on CentOS 5.5
+1 Vote Up -1Vote Down

This is one of a few MySQL High Availability strategies.  I have used this for years and found it work great.  If you don’t know about DRBD and MySQL you should read Peter’s comments.

These are step by step instructions for Redhat 5 or CentOS.

If you need more details please refer to:
http://www.drbd.org/users-guide/

Configuring MySQL for DRBD
http://dev.mysql.com/doc/refman/5.1/en/ha-drbd-install-mysql.html

Getting started:

The OS in this example is CentOS 5.5.  I added a new disk (/dev/sde) to the four disk RAID-5 and RAID-1 I was already using.   I’m only



  [Read more...]
Sphinx As MySQL Storage Engine (SphinxSE)
+0 Vote Up -0Vote Down

Sphinx As MySQL Storage Engine (SphinxSE)

SphinX is a great full-text search engine for MySQL. Installing the Sphinx daemon was straightforward as you can compile it from the source or use a .DEB/.RPM package but SphinxSE was a little bit tricky since it needed to be installed as a plugin on a running MySQL server. So if you use Debian or Centos and install your MySQL from a .deb or .rpm package this is how you do it.

How to install MongoDB on CentOS 5.4 / RHEL5 and interface with PHP 5
+0 Vote Up -1Vote Down

If you’ve been reading up on the various NoSQL offerings and have wanted to try out one but don’t know how to get started, this is one of the easiest ways. I chose MongoDB for this example because I’m going to start using it for a project that needs features that MySQL isn’t as fast at: namely denormalized data with billions of rows. MongoDB has plenty of drivers for other scripting and high-level languages but I’ll focus on the PHP driver today. If there is interest I can do a write up on Python usage later. This example is limited to CentOS, Fedora, and Redhat 5 servers that use the yum package management system. For more information you can reference their download page: http://www.mongodb.org/display/DOCS/Downloads

First install the prerequisites:

  • sudo yum
  [Read more...]
Install MariaDB on RedHat 5.4
+0 Vote Up -0Vote Down

Tweet

Is MariaDB really a drop in replacement for MySQL?   I’m running CentOS 5.4.  What happens if…

  • Use “mysqldump –all-databases > FullBackup.sql” to make a full backup. (Better safe then sorry)
  • Go to http://askmonty.org/wiki/MariaDB:Download and download the CentOS 5 packages.
  • Stop msql “service mysqld stop”
  • Pull MySQL out by the roots with “rpm -e mysql-server mysql –nodeps”
  • Install Maria with “rpm -i Maria-*”
  • And the install start mysql up again.  Wow.  That’s “Drop in”.

    If your

      [Read more...]
    How do you print number of files for each folder in a directory [Linux]
    +0 Vote Up -2Vote Down

    I have been annoyed by the fact that I couldn’t easily print file count for all of the folders in certain directory.  Most of the time I just want to see what space each folder is using (du -hs *) but there are times when I need to know how many files are in each folder (checking cache folder, session folders etc).   So I whipped together a command line which does just that for me:

    for i in `find -maxdepth 1 -type d`; do  echo -n $i " ";find $i|wc -l; done

    I am sure there are many different ways to show file count for each folder in a directory and I am curious to see what people do so please do post comments with what you do.

    Above command is pretty simple and can be expanded to do whatever you need.  For example, you can throw it into a bash script and be able to pass parameters.  For example:  count_files /home/  In this case your command

      [Read more...]
    How To Set Up MySQL Database Replication With SSL Encryption On CentOS 5.4
    +1 Vote Up -0Vote Down

    How To Set Up MySQL Database Replication With SSL Encryption On CentOS 5.4

    This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred between the master and slave). MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

    Installing Lighttpd With PHP5 And MySQL Support On CentOS 5.4
    +0 Vote Up -0Vote Down

    Installing Lighttpd With PHP5 And MySQL Support On CentOS 5.4

    Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a CentOS 5.4 server with PHP5 support (through FastCGI) and MySQL support.

    PHP: Curl being slow from php call on CentOS 5.4
    +0 Vote Up -0Vote Down

    I ran into an issue where curl request run within few ms from command line but same url fetch was taking over 10 secs. After doing some debugging and research it turned out that call to check (getaddr ipv6 was timing out. Obviously you can do multiple things to fix this (including enabling ipv6 support) but since I did not have a need for ipv6 (it is disabled in my network configuration), I decided to recompile curl and disable ipv6. Here is the command for recompiling curl and installing into /usr/local/curl directory with ipv6 disabled.

    ./configure –prefix=/usr/local/curl –disable-ipv6

    ————————————-
    DISCLAIMER: Please be smart and use code found on internet carefully. Make backups often. And yeah.. last but not least.. I am not responsible for any damage caused by this posting. Use at your own risk.


      [Read more...]
    451 CAOS Links 2009.12.01
    +0 Vote Up -0Vote Down

    Banking on open source. Open source as a business model. And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
    “Tracking the open source news wires, so you don’t have to.”

    For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

    Banking on open source
    # CIOL.com reported on the benefits of Standard Chartered Bank’s open source-based core banking system.

    Open source as a business model
    The “open source has



      [Read more...]
    MariaDB 5.1.39 for Debian, Ubuntu, RHEL/CentOS
    +1 Vote Up -0Vote Down

    You can now yum (RPM) or apt-get (DEB) MariaDB 5.1.39, courtesy of OurDelta and in close cooperation with Monty Program Ab. Simply follow the info on the CentOS, Debian or Ubuntu pages.

    (note: give the mirrors some hours to sync up)

    Quick overview

    • See the Release Notes for relevant bugfixes.
    • Drop-in replacement for stock MySQL 5.0 or 5.1 (If you’re coming from stock MySQL, see the MariaDB extras/differences overview).
    • If you are upgrading from 5.0, please review the
      [Read more...]
    MySQL 5.0.87-d10 OurDelta packages
    +1 Vote Up -0Vote Down

    MySQL 5.0.87-d10 OurDelta builds are now available (32 and 64-bit):

    Apart from the 5.0.87 upstream fixes there were a few minor fixes in the build environment, and one updated Percona patch. The -sail builds now include the OQGRAPH engine. Source packages are with the respective distro repos, and there are base source  [Read more...]
    MySQL in RHEL5/CentOS5 gets an update
    +1 Vote Up -0Vote Down

    It’s worth noting that Red Hat Enterprise Linux (RHEL) 5 has had an update to MySQL in the last month. This naturally means that CentOS 5 also had a similar update. It’s now bumped up to MySQL 5.0.77 (goodbye 5.0.45!; which is what RHEL5 shipped with). This is a moderate security release, so consider updating, if you can afford a mysqld restart.

    Read more about the 4 CVE bugs fixed. CentOS followed suit within two weeks.



      [Read more...]
    Building 5.1.38-maria packages
    +2 Vote Up -2Vote Down

    We’ve been able to do MySQL 5.1 binary tarballs for a bit now (great working together with Kristian Nielsen of Monty Program), but packages are bit more tricky. Peter has been working on Debian/Ubuntu while I’ve focused on RH/CentOS. The following is from an OurDelta (trial build run) RPM install on CentOS 5 x64:

    $ mysql -u root
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 1
    Server version: 5.1.38-maria-beta1-ourdelta (OurDelta - http://ourdelta.org/)
    
    mysql> CREATE TABLE test.t1 (i int) ENGINE=PBXT;
    Query OK, 0 rows affected (0.10 sec)
    
    mysql> SHOW CREATE TABLE test.t1\G
    *************************** 1. row ***************************
    Table: test.t1
    Create Table: CREATE TABLE `test.t1` (
    `i` int(11) DEFAULT NULL
    ) ENGINE=PBXT DEFAULT CHARSET=latin1
    1 row in set (0.00 sec)
    
    mysql> INSERT INTO test.t1 values (1);
      [Read more...]
    Installing Apache2 With PHP5 And MySQL Support On CentOS 5.3 (LAMP)
    +1 Vote Up -0Vote Down

    Installing Apache2 With PHP5 And MySQL Support On CentOS 5.3 (LAMP)

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

    451 CAOS Links 2009.08.04
    +0 Vote Up -0Vote Down

    OIN offers cash for patents. CentOS crisis averted. Microsoft denies GPL violation. And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
    “Tracking the open source news wires, so you don’t have to.”

    # Open Invention Network offered individual inventors cash for patents, and acquired patents from V_Graph.

    # The H Open reported that the management problems at CentOS are now resolved.

    # Sam Ramji told Network World in detail why Microsoft believes its Linux IC code did not violate the GPL (from 15m 30s).

    # Canonical delivered an on-premise version of its Landscape systems management


      [Read more...]
    451 CAOS Links 2009.07.31
    +0 Vote Up -0Vote Down

    When open source goes bad. Is open source a success or failure? And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
    “Tracking the open source news wires, so you don’t have to.”

    When open source goes bad

    The H reported on the apparent turmoil at the CentOS project, while Jay Lyman offered the CAOS perspective. Meanwhile Slashdot reported that Alan Cox has quit as Linux TTY subsystem maintainer.

    Success or failure?
    Danny Windham, Digium CEO, responded to Peter Yared’s





      [Read more...]
    Microsoft contributes to Linux kernel: a CAOS Theory Q&A
    +4 Vote Up -0Vote Down

    Microsoft has announced that it is to contribute code to the Linux kernel development effort under the GNU General Public License (GPL) v2. What on earth does it all mean? Here’s our take on the situation. With thanks to Jay Lyman for his contribution to the following:

    Q. This is a joke, right?

    A. Not at all, although if any announcement is better suited to the image above, we can’t think of one. Microsoft has announced that it is going to contribute code to Linux under the GPLv2.

    Q. What code is Microsoft

      [Read more...]
    Linux and open source no puff in the clouds
    +0 Vote Up -0Vote Down

    UPDATED - I had to update this post after a conversation with RightScale founder and CTO Thorsten von Eicken and for Sun’s Open Cloud announcement, which are both now included below.

    There has been some substantial technology and news regarding open source software in cloud computing lately. More proof that open source is reaching into nearly all aspects of enterprise and broader IT, and also reinforcement of the idea that open source software will continue to have a pervasive and disruptive impact on the way organizations of all shapes and sizes do their computing and deal with their data.

    First up is RightScale, which as detailed by 451 colleague and Principal Analyst William Fellows, is up and running across the pond on

      [Read more...]
    Testing environment: Installing CentOS 5.2 on VirtualBox
    +0 Vote Up -0Vote Down
    In the previous post of this series we installed and set up VirtualBox. We prepared it for a default install of CentOS 5.2. This time, we cover the installation of the OS itself. Changes since the last article are an upgrade from v2.0 to v2.1, and the fact that I’m running VirtualBox on my Asus [...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 102 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.