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 91 to 120 of 166 Next 30 Older Entries

Displaying posts with tag: ubuntu (reset)

When backups fail: A mysql binlog race condition
+0 Vote Up -0Vote Down

Today I ran into my first MySQL binlog race condition: The initial problem was quite simple: A typical MySQL master->slave setup with heavy load on the master and nearly no load on the slave, which only serves as a hot fallback and job machine, showed differences on the same table on both machines. The differences showed up from time to time: entries that have been deleted from the master were still on the slave.

After several investigations I started examining the MySQL binlog from the master – a file containing all queries that will be transferred to the slave (and executed there if they don’t match any ignore-db-pattern). I grepped for ids of rows that have not been deleted on the slave as I’s interested if the DELETE statement was

  [Read more...]
Creating MySQL Backups With AutoMySQLBackup On Ubuntu 9.10
+1 Vote Up -0Vote Down

Creating MySQL Backups With AutoMySQLBackup On Ubuntu 9.10

AutoMySQLBackup is a shell script that lets you take daily, weekly and monthly backups of your MySQL databases using mysqldump. It can back up multiple databases, compress the backups, back up remote databases, and email the logs. This tutorial explains how to install and use it on an Ubuntu 9.10 server.

Installing Cherokee With PHP5 And MySQL Support On Ubuntu 9.10
+0 Vote Up -0Vote Down

Installing Cherokee With PHP5 And MySQL Support On Ubuntu 9.10

Cherokee is a very fast, flexible and easy to configure Web Server. It supports the widespread technologies nowadays: FastCGI, SCGI, PHP, CGI, TLS and SSL encrypted connections, virtual hosts, authentication, on the fly encoding, load balancing, Apache compatible log files, and much more. This tutorial shows how you can install Cherokee on an Ubuntu 9.10 server with PHP5 support (through FastCGI) and MySQL support.

Poor Matt, poor Ken
+3 Vote Up -7Vote Down

Well, for Matt Asay, I should start by congratulating you for the new job and nice title! (Also, we learn some intelligence from Matt's blog: apparently Canonical is already close to the size of MySQL AB at the time of the Sun acquisition.)

Usually we are told to "ignore the trolls" and all that. The blogosphere unfortunately seems to be full of commentators who like to have share their opinion - even while they are entirely clueless. Sometimes, like the comments on Slashdot, it is ok and considered part of the entertainment. Sometimes it is harmless, because nobody reads that blog. And sometimes, it is just unacceptable:

read more

How To Set Up MySQL Database Replication With SSL Encryption On Ubuntu 9.10
+2 Vote Up -0Vote Down

How To Set Up MySQL Database Replication With SSL Encryption On Ubuntu 9.10

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.

CAOS Theory Podcast 2010.02.05
+0 Vote Up -0Vote Down

Topics for this podcast:

*Matt Asay moves from Alfresco to Canonical
*GPL fade fuels heated discussion
*Apple’s iPad and its enterprise and open source impact
*Open source in data warehousing and storage
*Our perspective on Oracle’s plans for Sun open source

iTunes or direct download (32:50, 9.2 MB)

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

Matt Asay joins Canonical. Paula Hunter joins the CodePlex Foundation. 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.”

# Matt Asay joined Canonical as chief operating officer.

# Paula Hunter was named executive director of the CodePlex Foundation.

# Actuate recorded $6.5m in BIRT-related business for Q4; annual BIRT-related business of $18.2m up 18%.

# Glyn Moody outlined The Great Oracle Experiment.

# The Symbian Foundation confirmed the 100% open source Symbian


  [Read more...]
Eleven Open Source Cloud Computing Projects to Watch
+0 Vote Up -0Vote Down

Last month cloud computing and systems management expert John Willis published his best of Cloud Computing for 2009 list he calls the Cloudies.  I am not an expert on the latest developments in cloud computing so it was nice to get a list of the best (in his expert opinion)

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

Monty turns his attention to the East. The value of JBoss to Red Hat. 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

# Monty Widenius predicted that the EU will clear Oracle-Sun “any moment”, turning his attention to Russia and China.

# Meanwhile the release candidate of MariaDB 5.1 is now ready


  [Read more...]
Ubuntu Karmic's Network Manager Issues
+1 Vote Up -1Vote Down
Since Ubuntu 8.04 aka Hardy Heron, I've had issues with every new release. As Ubuntu evolves into being a viable desktop OS alternative, its complexity has been growing and with the new and improved looks new challenges arise. This bug in particular has been very difficult to diagnose and I can't imagine anyone without enough Linux experience to overcome it on their own, so I decided to summarize the steps I took to fix it ... and vent my frustration at the end.

The Symptom

I came across the issue for the first time while trying Ubuntu's Karmic Netbook remix. After overcoming the typical Broadcom wifi driver, Network Manager would connect, but Firefox would fail to load the web pages 90% of the time. Using ping in the command line worked just fine. Maybe I needed to update the software packages to get the latest
  [Read more...]
How To Set Up Database Replication In MySQL On Ubuntu 9.10
+0 Vote Up -1Vote Down

How To Set Up Database Replication In MySQL On Ubuntu 9.10

This tutorial describes how to set up database replication in MySQL. 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.

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

VMware to acquire Zimbra? 2009’s open source legal developments. 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

# All Things D reported that VMware is buying Zimbra from Yahoo.

# Mike Hogan speculated on what else would be missing from VMware’s virtualized software stack.

#


  [Read more...]
Installing Lighttpd With PHP5 And MySQL Support On Ubuntu 9.10
+1 Vote Up -0Vote Down

Installing Lighttpd With PHP5 And MySQL Support On Ubuntu 9.10

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

Fixing a MariaDB package bug
+4 Vote Up -0Vote Down

One of the things that I am really happy about in MariaDB is that we have our releases available as apt (and yum for Centos) repositories. This is largely thanks to being able to build this on the OurDelta package build infrastructure (which again builds on things like the Debian packaging scripts for MySQL).

Something like the Debian apt-get package system (which is also used by Ubuntu) is one of the major innovations in the Free Software world in my opinion. Debian has spent many years refining this system to where it is today. Want to run the mysql client, but it isn't installed? Just try to run it on your local Ubuntu host:

    $ mysql
    The program 'mysql' can be found in the following packages:
     * mysql-client-5.0
     * mysql-client-5.1
    Try: sudo apt-get install <selected package>
    -bash: mysql:

  [Read more...]
51 Weeks since my book writing adventure began
+0 Vote Up -0Vote Down

In one week, on December 24th, it will be exactly one year since I was first contacted by Packt Publishing. After reading several posts from this blog they asked me if I’d be interested in writing a MySQL administration cookbook with hands-on recipes for those among us who have to make sure the MySQL servers are kept running and in good shape.

Funny thing, I almost deleted their email, because initially I thought GMail’s spam filter had not caught some sort of bulk or phishing email, because I had never heard of Packt Publishing before and at first only saw an unfamiliar sounding sender’s name. As I was one of very few people in the office on that day I decided to read it anyways. Turned out to be not so spammy after all…

What followed were several weeks of sending mails back and forth, convincing a colleague to

  [Read more...]
Installing Apache2 With PHP5 And MySQL Support On Ubuntu 9.10 (LAMP)
+1 Vote Up -0Vote Down

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

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

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 on Debian and Ubuntu
+3 Vote Up -0Vote Down

Debian Linux (the underlying foundation of Ubuntu) manages the startup/shutdown of MySQL quite differently from the ways I am used to. I am a long-time user of both the MySQL binary provided by Red Hat/SuSE (along with Fedora and clones like CentOS and Oracle Enterprise Linux) and the official binary from mysql.com (http://www.mysql.com). After the successful restore of a cold backup, I started mysqld using the Debian provided init script. The script said that mysqld failed to start up, but in reality it did start up. Similarly, stopping mysqld fails.

The output below demonstrates the outputs and the behavior seen on a Ubuntu 8.04 LTS Server:

root:~# ps -ef | grep mysqld
root     20165 19926  0 15:12 pts/4    00:00:00 grep mysqld
root:~# /etc/init.d/mysql start
 * Starting MySQL database server mysqld
  [Read more...]
MariaDB 5.1 packages for Debian and Ubuntu
+9 Vote Up -4Vote Down

You can now apt-get your way to MariaDB 5.1, courtesy of OurDelta and in close cooperation with Monty Program Ab. To get started, simple follow the info on the Debian and Ubuntu pages.

Quick overview

  • For MariaDB we use different repository directories to ensure that you can’t accidentally upgrade or revert major versions without you explicitly choosing to do so.
  • At this point we have Ubuntu Hardy, Intrepid, Jaunty and Karmic for you, as well as Debian 4 (Lenny). Etch (Debian 4) is waiting on a small fix (thanks to Antony Curtis for helping with that).
  • The package names start with mariadb*,
  [Read more...]
CAOS Theory Podcast 2009.10.30
+0 Vote Up -0Vote Down

Topics for this podcast:

*-DoD memo and official use and consideration of open source
*EnterpriseDB updates its Postgres Plus Server, gets Red Hat investment
*Latest in Linux from Canonical’s Ubuntu and Red Hat Enterprise Linux, Deltacloud
*Roundup of Oracle-Sun-MySQL developments and perspectives

iTunes or direct download (25:30, 5.8 MB)

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

Red Hat invests in EnterpriseDB. The White House goes open source. 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

In other news…

# EnterpriseDB confirmed Red Hat investment, partnership.

# Whitehouse.gov migrated to Drupal, as well as Linux, Apache,


  [Read more...]
How To Set Up Apache2 With mod_fcgid And PHP5 On Ubuntu 9.04
+0 Vote Up -0Vote Down

How To Set Up Apache2 With mod_fcgid And PHP5 On Ubuntu 9.04

This tutorial describes how you can install Apache2 with mod_fcgid and PHP5 on Ubuntu 9.04. mod_fcgid is a compatible alternative to the older mod_fastcgi. It lets you execute PHP scripts with the permissions of their owners instead of the Apache user.

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

Red Hat round-up. EC to review Oracle-Sun. Dedicated Ubuntu support. 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.”

Red Hat announcements round-up
Red Hat announced a whole heap of products and projects this week. They should have organized an event to coincide with all the announcements. Or something. The biggest news was probably the launch of Red Hat Enterprise Linux 5.4 including KVM and other virtualization capabilities, while Red Hat and HP partnered to optimize Red Hat Enterprise Virtualization for HP BladeSystem Matrix. The company also revealed that Red Hat Network


  [Read more...]
Building PHP 5.3 packages on Ubuntu 9.04 (Jaunty) for Apache 2
+0 Vote Up -0Vote Down

Goal: Build a PHP 5.3 package, that I can install and upgrade on new ubuntu slices as needed, without having to compile on each box.

This is an amalgamation of different blog posts that did certain things really well, but not everything I wanted. The post I refer to specifically Installing PHP 5.3 on Ubuntu by Brandon Savage .

Prep your system

Setup your development server to be able to compile things. By default, most installations will not come with compilers installed.

apt-get install checkinstall

Say yes, and let it follow the dependencies as needed.

Get the development headers for some of the extensions you’ll be compiling in.


apt-get install postgresql-8.3 postgresql-client-8.3
  [Read more...]
451 CAOS Links 2009.08.07
+0 Vote Up -0Vote Down

Monty Widenius dissects MySQL’s dual license. Intuit moves to the EPL. 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.”

# Monty Widenius blogged about the apparent changes to the dual licensing of MySQL.

# Intuit announced that its code.intuit.com will be moving from CPL to EPL.

# Matt Asay asked whether Google’s open source advocacy might be a scheme to lower the value of patents.

# Vision Mobile’s Andreas Constantinou explained the differences between open source licenses and governance models.


  [Read more...]
Installing Cherokee With PHP5 And MySQL Support On Ubuntu 9.04
+0 Vote Up -1Vote Down

Installing Cherokee With PHP5 And MySQL Support On Ubuntu 9.04

Cherokee is a very fast, flexible and easy to configure Web Server. It supports the widespread technologies nowadays: FastCGI, SCGI, PHP, CGI, TLS and SSL encrypted connections, virtual hosts, authentication, on the fly encoding, load balancing, Apache compatible log files, and much more. This tutorial shows how you can install Cherokee on an Ubuntu 9.04 server with PHP5 support (through FastCGI) 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...]
451 CAOS Links 2009.07.28
+0 Vote Up -1Vote Down

Intuit launches open source project. SFLC on Microsoft GPL violation accusations.

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

# Intuit launched open source projects and community to develop apps based on its Intuit Partner Platform, while Savio Rodrigues declared Intuit’s open source play is all business.

# SFLC’s Bradley Kuhn told SDTimes Microsoft was in violation of the GPL.

# MySQL and Memcached-based appliance vendor Schooner Info Tech has raised $20m in Series B funding.

# Novell


  [Read more...]
Previous 30 Newer Entries Showing entries 91 to 120 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.