Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 123 10 Older Entries

Displaying posts with tag: centos (reset)

How to Enable MySQL Event Scheduler
+0 Vote Up -0Vote Down

You may think that you already know what's the opposite of "DISABLED", but with MySQL Event Scheduler you'll be wrong.

In fact MySQL Event Scheduler may have three different states[1][2]:

DISABLED -  The Event Scheduler thread does not run [1]. In addition, the Event Scheduler state cannot be changed at runtime.
OFF (default) - The Event Scheduler thread does not run [1]. When the Event Scheduler is OFF it can be started by setting the value of event_scheduler to ON.
ON - The Event Scheduler is started; the event scheduler thread runs and executes all scheduled events.

So if you're going to find it in the DISABLED state …



  [Read more...]
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: […]

Public DNS resolve for VM instances hosted at OpenStack nova compute grizzly edition
+0 Vote Up -0Vote Down

Issue – the OpenStack instances hostnames are not resolved at the moment by their floating IPs.

Fast solution – use PowerDNS
Short story:
1. Boot an instance , assign it a floating IP, open tcp ports 22 8001 and udp port 53.
2. Install PowerDNS, the particular yum package is named pdns.
3. install the mysql backend for PowerDNS, its available as yum package as well.
4. Install MariaDB , set the proper configuration, the initialize it at the default location.
5. Set the pdns user, create the pdns database and create the tables needed.
6. Configure the pdns …






  [Read more...]
On operating system upgrades and a packager’s nightmare
+1 Vote Up -0Vote Down

A fairy tale

Once upon a time I did an operating system upgrade, a minor one that should do no harm, but just get me up to date by fixing any bugs in the version I had been using. It seemed like a good idea.

All seemed to be fine. I use a package provided by an external vendor and not the one produced by the operating system provider as this vendor provides a newer version of the package and I need that. The vendor has to make his package fit in the os environment his package is built for and normally does a pretty good job.

I use automation to build my systems and when I built a new one some issues …

  [Read more...]
MariaDB 10.0.3: installing the additional engines
+4 Vote Up -0Vote Down

So MariaDB 10.0.3 Alpha is out. Download it and remember to provide feedback.

When you run SHOW ENGINES by default, you don’t get CassandraSE or the CONNECT engine. Make sure you do a yum install …

  [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.

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 …

  [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 …

  [Read more...]
Migrating MySQL 5.5.25a jiradb ERROR 2013 (HY000) on huge single db import
+0 Vote Up -0Vote Down

well, I incremented max_allowed_packet from 16M to 512M
anyway, I got the same error on the next clean import.
so decided to find a workaround.
so, how to get the data separated from the ddl statements:

# get the tables names into the insert statement, its better to have that in file for future usage
sed '/^INSERT INTO/!d;s/ VALUES.*$//' jiradb.20130118.sql | sort | uniq > tablas.como.nombres.txt

then how to get the data separated:

root@jiragg:[Fri Jan 18 15:26:33]:[/usr/local/BACKUP]$ cat make.inserts.sh
#!/bin/sh
# trim function thank to …



  [Read more...]
Install MySQL at non default data directory on different drive on CentOS6.3/RHEL 6
+0 Vote Up -0Vote Down

We assume the new disk is /dev/sdb1 formatted as ext3
and it will be mounted as /data

# 0. make sure there is no mysqlm mysql data directory :
yum remove mysql mysql-server -y 
test -d /data/mysql/ && rm -rf /data/mysql/
test -d /var/lib/mysql/ && rm -rf /var/lib/mysql/

# 1. install Mysql
yum install mysql mysql-server -y

# 2. check the mysql  status
service mysqld status

# 3. start the mysqld if not started
service mysqld start

# 4. check the mysql status again
service mysqld status

# 5. stop mysqld in case its started, and check thre is n mysql process:
service mysqld stop
ps axu | grep …

  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 123 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.