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 109 Next 30 Older Entries

Displaying posts with tag: centos (reset)

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

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

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

Stop Disabling SELinux!
+0 Vote Up -1Vote Down

I see a lot of people coming by #centos and similar channels asking for help when they’re experiencing a problem with their Linux system. It amazes me how many people describe their problem, and then say something along the lines of, “and I disabled SELinux...”. Most of the time SELinux has nothing to do with the problem, and if SELinux is the cause of the problem, why would you throw out the extra security by disabling it completely rather than configuring it to work with your application?

read more

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

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

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

Open Query looking for new colleagues!
+1 Vote Up -1Vote Down
My colleagues and I are looking for extra talent – is that you? What we do:help clients prevent problems (rather than being the fire department), we work on a subscription basis although we also do some ad-hoc consulting, and training. Apart from MySQL/MariaDB query and DBA work, we do quite a bit of system administration. Mainly Red Hat and Debian based distros, and expect to see replication and the MySQL-MMM multi-master system. You’d work from home, whereever it might be, so you will need to be self-motivating (but we do keep in touch online). What we’re not: a full-time employer. With us, you make a life rather than a living. Everybody is contracted part-time. You can make enough to live comfortably, but that has nothing to do with hours. If you’re stressed about not filling all hours in your week with work-work-work, we’re not  [Read more...]
Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On CentOS 6.0
+0 Vote Up -0Vote Down

Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On CentOS 6.0

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 CentOS 6.0 server with PHP5 support (through PHP-FPM) and MySQL support.

The Full Monty – Scientfic Linux 6.1, drbd, PaceMaker, MySQL, Tunsten Replication and more
+0 Vote Up -0Vote Down

PART 1 – This will be a multi part post.

THIS DOCUMENT IS BEING UPDATED – PLEASE WATCH FOR CHANGES!

After years of supporting MySQL, for many different companies, I’ve seen this story played out again and again.
The company:

  • chooses a Database Management System (MySQL)
  • installs the DBMS on a computer with other processes
  • writes many programs to access the data (Without concern on how the queries are written.)
  • moves DBMS to a computer of its own and writes more programs
  • buy bigger computer to run the DBMS and writes more programs
  • tires of DBMS response times and outages caused by developers working on production systems and hires a Database Administrator to fix the mess

This is a step by step description of  how I


  [Read more...]
Installing Nginx With PHP5 And MySQL Support On CentOS 5.6
+0 Vote Up -0Vote Down

Installing Nginx With PHP5 And MySQL Support On CentOS 5.6

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 CentOS 5.6 server with PHP5 support (through FastCGI) and MySQL support.

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

      [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

      [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...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 109 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.