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 中文
Showing entries 1 to 30 of 60 Next 30 Older Entries

Displaying posts with tag: Wordpress (reset)

WordPress and UTF-8
Employee +2 Vote Up -0Vote Down

For many years, MySQL had only supported a small part of UTF-8, a section commonly referred to as plane 0, the “Basic Multilingual Plane”, or the BMP. The UTF-8 spec is divided into “planes“, and plane 0 contains the most commonly used characters. For a long time, this was reasonably sufficient for MySQL’s purposes, and WordPress made do with this limitation.

It has always been possible to store all UTF-8 characters in the latin1 character set, though latin1 has shortcomings. While it recognises the connection between upper and lower case characters in Latin alphabets (such as English, French and German), it doesn’t recognise the same connection for other alphabets. For example, it doesn’t know that ‘Ω’ and ‘ω’ are the upper and lower-case

  [Read more...]
On rumors of "PHP dropping MySQL"
Employee +1 Vote Up -0Vote Down

Over the last few days different people asked me for comments about PHP dropping MySQL support. These questions confused me, but meanwhile I figured out where these rumors come from and what they mean.

The simple facts are: No, PHP is not dropping MySQL support and we, Oracle's MySQL team, continue working with the PHP community.

For the long story we first have to remember what "PHP's MySQL support" includes. There key part are four extensions which are part of the main PHP tree:

  • ext/mysql
  • ext/mysqli
  • ext/pdo_mysql
  • ext/mysqlnd

The first one, ext/mysql provides the mysql_* functions. This is the classic interface taught in many (old) books and used by lots of (old) software. mysqli is "mysql improved", this is a younger

  [Read more...]
OblakSoft Cloud Storage Engine Newsletter, June 2013
+0 Vote Up -0Vote Down

ClouSE 1.0b.1.8 is released

OblakSoft is pleased to announce the release of ClouSE Beta version 1.0b.1.8.  This is a minor maintenance release that addresses a couple pain points, while we’re working on a release candidate that will bring the built-in point-in-time recovery and other major features.

Here is the summary of changes:

  • Improved caching for Weblobs

Now ClouSE sets the cache control headers for Weblobs.  The cache control headers specify the max-age directive that allows caching content for one year.  This makes proxies and content delivery networks (CDN) more efficient.  The change resolves this support issue.

  • Improved error handling on startup

Now database requests


  [Read more...]
MySQL on Cloud Storage: ClouSE upgrade made easy
+0 Vote Up -0Vote Down

Updating ClouSE can now be done with one command

With more than a thousand registered users worldwide, guiding customers through the upgrade process is getting hard, so we decided to automate the servicing steps.  Now the update-clouse script can be used to update ClouSE binaries to the current version.  This script ships with the ClouSE binary distribution.

Here is an example of updating ClouSE using the Webmin console.

First, download ClouSE 64-bit binaries from http://www.oblaksoft.com/downloads/.  Then upload and extract the binaries to the /home/ec2-user directory. In


  [Read more...]
MySQL on Cloud Storage: do it yourself with one command
+1 Vote Up -0Vote Down

Cloud Storage Engine (ClouSE) installation and configuration is now fully automated. Try new ClouSE installer and you’ll have cloud storage access configured in no time.

OblakSoft is pleased to announce the release of Cloud Storage Engine (ClouSE) installer that can be used to deploy and configure ClouSE with your MySQL server. Now ClouSE can be deployed with just one command. The installer will guide the user through the configuration process, prompt for Cloud Storage connection parameters, and install ClouSE into MySQL.

Presented is a step-by-step guide for ClouSE installation and configuration, from downloading the binaries to running the installer. The guide was designed by request of WordPress-to-Cloud users, however it is fully applicable to any generic ClouSE installation.

The slides have notes, they are a little hard to discover with the

  [Read more...]
OblakSoft Cloud Storage Engine Newsletter, March 2013
+2 Vote Up -0Vote Down

ClouSE 1.0b.1.7 is released

OblakSoft is pleased to announce the release of Cloud Storage Engine (ClouSE) for MySQL Beta version 1.0b.1.7.  In this release we added support for a variety of environments to address the platform diversity of our growing customer base.

Here is the summary of changes that are included into 1.0b.1.7:

  • Support for ClouSE on Microsoft Windows (limited preview)

Now ClouSE builds are available both for Linux and Microsoft Windows.  The cloud data format is the same across all platforms: Linux and Windows, 32-bit and 64-bit.  This allows for seamless transitions between machines, platforms and clouds.  ClouSE for Windows is currently available to a group of limited preview customers.  If you would like to sign up for the limited preview program please


  [Read more...]
OblakSoft Cloud Storage Engine Newsletter, December 2012
+2 Vote Up -0Vote Down

ClouSE version 1.0b.1.6 is released

OblakSoft is pleased to announce the release of ClouSE version 1.0b.1.6.  In this release we fixed some of the known ClouSE Beta limitations as well as performance and functional bugs reported by our users.

Here is the summary of changes that are included into 1.0b.1.6:

  • Support for latest MySQL 5.5

Now ClouSE supports MySQL thru 5.5.29.  To keep the distribution small, we don’t build binaries for MySQL prior to 5.5.19 anymore.  If you need one, please contact us.

  • DECIMAL keys support

Now ClouSE supports using DECIMAL fields in keys.  Previously neither the primary key nor indices could include DECIMAL fields.  This fixes the following Beta limitation: DECIMAL fields cannot be


  [Read more...]
General: new site theme based on Twitter Bootstrap
+0 Vote Up -1Vote Down

Just a quick note to say that the site has been updated to a new theme which is based on the super awesome Twitter Bootstrap UI framework. To make life easier, since this site is also using WordPress at the core, I’ve made use of the WordPress Bootstrap plugin which allows for very simple integration. However, that wasn’t enough because the Bootstrap plugin comes with rather basic and boring generic styles; so I added the plugin for Google Font support and then modified the CSS accordingly.

You will also notice that the site is undergoing some reorganization of categories and content tags. This should help clean up search results as

  [Read more...]
OblakSoft Cloud Storage Engine Newsletter, November 2012
+1 Vote Up -0Vote Down

MySQL and WordPress welcome Google Cloud Storage

OblakSoft is pleased to announce that the Cloud Storage Engine for MySQL (ClouSE) now supports Google Cloud Storage.  Using MySQL to store data directly in Google Cloud Storage becomes a simple deployment choice: pick your Google Cloud Storage bucket and migrate any or all of your tables to the cloud.  We would like to thank Google storage team for their support and contributions.

This functionality opens Google Cloud Storage to millions of MySQL-based applications – cloud storage becomes a better alternative to local storage, no matter where you host the application, on premise or in the cloud.  Applications can now store data on Google’s infrastructure, and enjoy high availability, high durability and high

  [Read more...]
OblakSoft Cloud Storage Engine Newsletter, October 2012
+2 Vote Up -0Vote Down

MySQL on Amazon S3: ClouSE version 1.0b.1.4 is released

OblakSoft is pleased to announce the release of ClouSE version 1.0b.1.4.  In this release we fixed some of the known ClouSE Beta limitations that required workarounds in some configurations.

In particular, now the popular BuddyPress WordPress plugin can store its tables in ClouSE without a patch that worked around the missing features.  If you’re using the patched version of BuddyPress 1.6.1 provided by us, you can now upgrade ClouSE and use the original BuddyPress sources.  Thank you for your patience and commitment!

Here is the summary of changes:

  • Support for latest MySQL 5.5

Now ClouSE supports MySQL thru 5.5.28.  To keep the distribution small, we don’t build binaries for MySQL prior to


  [Read more...]
MySQL BLOB meets Amazon S3: advanced Weblob features
+1 Vote Up -0Vote Down

Advanced Weblob operations help to use Weblobs most effectively.

Weblob recap

In an earlier post I introduced Weblobs.  Weblob is a new data type that is supported by the Cloud Storage Engine for MySQL (ClouSE).  To a database developer, a WEBLOB behaves (almost) like a regular BLOB.  However, in addition to the regular BLOB functionality, Weblobs can be downloaded directly from Amazon S3 by HTTP URLs.

In MySQL, a Weblob is expressed via a pair of BLOB fields that have a special naming convention: field_name$wblob and field_name$wblob_info.  The latter field is what provides the Weblob functionality.  It can be used to retrieve the direct Amazon S3 URL for the BLOB

  [Read more...]
OblakSoft Cloud Storage Engine Newsletter, August 2012
+1 Vote Up -0Vote Down

ClouSE version 1.0b.1.3 and 64bit WordPress on S3 / Yapixx refresh is released

OblakSoft recommends upgrading ClouSE to the latest version 1.0b.1.3 that fixes an issue with some SELECT statements.  Previously some SELECT statements (e.g. using index_merge w/intersect query execution plans) may mistakenly miss records.

OblakSoft is also pleased to announce that 64-bit AMI of WordPress on S3 / Yapixx is now available.  We’ve got requests from customers who’d like to use the AMI in production, but didn’t want to run a 32-bit AMI, and had to build their own 64-bit AMI using our AMI as a reference.  Now they can use our standard fully configured ready-to-run 64-bit AMI directly as a starting platform for their WordPress on S3 production websites.

The software can be downloaded at

  [Read more...]
OblakSoft Cloud Storage Engine Newsletter, June 2012
+1 Vote Up -0Vote Down

ClouSE version 1.0b.1.2 and WordPress on S3 / Yapixx refresh is released

OblakSoft is pleased to announce the release of ClouSE version 1.0b.1.2 and WordPress on S3 / Yapixx refresh.

This release addresses performances and usability issues reported by our early adopters.  Thank you all for your feedback.

  • Support for MySQL 5.5.25

Now ClouSE supports MySQL thru 5.5.25.  To keep the distribution small, we don’t build binaries for MySQL prior to 5.5.14 anymore.  If you need one, please contact us.

  • Weblob content type improvement

Now the content type for Weblobs is set based on their name.  Previously, the content type for all Weblobs was set to application/octet-stream, which could lead to undesirable Web Browser

  [Read more...]
WordPress on S3: run it anywhere
+2 Vote Up -1Vote Down

Where to host a dynamic website that stores all its content on Amazon S3? Anywhere you choose to.

OblakSoft is pleased to announce availability of an OVF Virtual Appliance with ready-to-run WordPress on S3: Yapixx.  Now WordPress on S3 can run anywhere, not just in Amazon EC2.

Any web server

The virtual appliance is distributed in the Open Virtualization Format that is supported by most major hypervisor software vendors (such as VMware, VirtualBox, Oracle VM, etc.).  The virtual appliance (one-file OVA package) contains the same software components as the corresponding Yapixx Amazon Machine Image (AMI).

The Yapixx VM has the

  [Read more...]
WordPress on S3: no more backups
+2 Vote Up -1Vote Down

WordPress on S3: no more backups

How much trouble will it be if your webserver failed?  No trouble at all, if your website keeps its content on reliable Amazon S3 storage.

There are a lot of nuances in ensuring proper backups and restores of websites. When was the last backup taken? How much data might have been lost? How long will it take to recover it? When was the last time you tested restore? Do you even have an offsite backup?

Now that you can run dynamic websites off Amazon S3 storage, we’ll demonstrate why you no longer need to worry about backing up and restoring your website data. Losing the webserver is no longer a disaster. Cloud storage offers almost unsurpassable reliability a lot of website owners (small & large) would benefit from. In a way you get an

  [Read more...]
WordPress on S3: the beauty of simplicity
+2 Vote Up -1Vote Down

My first computer program was written almost quarter a century ago on a BK-0010 computer.  It was very simple: the program asked the user to enter their name and then greeted the user using the entered name, like “Hello, Artem!”.  I was fascinated.  A couple of lines written in Vilnius BASIC transformed a piece of metal and silicon into a considerate thing that cared about a person’s name enough to remember it :-).  Of course, the first experience doesn’t represent the day-to-day routine of software development, but the moments when I see a couple of lines making an amazing transformation still enchant me, and remind me why I’ve been writing code all this time.

I’ve just experienced this very same first-time feeling as we’ve released

  [Read more...]
“WordPress on Amazon S3″, OblakSoft Cloud Storage Newsletter, May 2012
+2 Vote Up -0Vote Down

WordPress on S3: run a beautiful website on Amazon S3 cloud storage

OblakSoft is proud to introduce the 1st ever dynamic WordPress site running on top of Amazon S3: Yapixx.  Now you too can launch your own beautiful website on Amazon S3.

While Yapixx stands for Yet Another Picture Sharing Site, it is actually one of a kind.  Yapixx is WordPress that was moved to run on top of Amazon S3 storage without changing a line of code in the WordPress core engine.

  [Read more...]
WordPress on S3: how it works
+2 Vote Up -0Vote Down

OblakSoft is pleased to showcase how simple it is to run LAMP applications on the cloud storage.  OblakSoft configured the WordPress web publishing platform to run on Amazon S3 storage and made the recipe available for anyone to replicate.  A ready-to-run WordPress site (configured as Yapixx) – is available for public use for FREE.  Yapixx is WordPress configured as a picture sharing website that runs on top of Amazon S3 (Yapixx stands for Yet Another Picture Sharing Site).

 

  [Read more...]
Site update with a welcome news
+0 Vote Up -2Vote Down

As I updated my website, migrating from Drupal to WordPress, a welcome news followed in the evening when Swansea beating Manchester City 1-0. The female assistant to the referee, Sian Massey, gladly judging Micah Richards for an offside. United had a rough time taking over WBA, but ensuring a relatively comfortable 2-0.

Moved to a new hosting provider
+0 Vote Up -0Vote Down

Again, I have moved to a new hosting provider after my free-tier with Amazon EC2 expired.  As usual I was looking for a good VPS provider with a decent price, providing good support and in particular a provider supporting FreeBSD, my favorite OS for server (for desktop I still prefer GNU/Linux.)

This time I have carefully reviewed many options and have finally settled with RootBSD, one of the reputed VPS hosting providers if you are choosing FreeBSD as your server OS.  One of the prime reasons for choosing FreeBSD is its performance, stability and the

  [Read more...]
New! Cloud-based MySQL Database Monitoring from Monitis
+0 Vote Up -0Vote Down

New feature provides significantly faster insight and root cause analysis

SAN JOSE, Calif., February, 15, 2012Monitis, the leading cloud and web application monitoring software provider, today announces that it has added comprehensive MySQL database monitoring to its award-winning Application Performance Management & Monitoring platform. The robust Software-as-a-Service (SaaS) tool enables users to gain significantly faster insight when conducting root cause analysis.

The MySQL monitoring feature includes 246 monitoring variables and more than 21 different metrics to provide one of the easiest to use, yet comprehensive database monitoring tools

  [Read more...]
5 Tips to Cache Websites and Boost Speed
+0 Vote Up -0Vote Down

Read the original article at 5 Tips to Cache Websites and Boost Speed

Often when we think about speeding up and scaling, we focus on the application layer itself.  We look at the webserver tier, and database tier, and optimize the most resource intensive pages.

There's much more we can do to speed things up, if we only turn over the right stones.  Whether you're using WordPress or not, many of these principals can be applied.  However we'll use WordPress as our test case.

Test Your Website speed

There are web-based speed testing tools that will help with this

  [Read more...]
Facebook Open Graph Meta WordPress Plugin
+0 Vote Up -0Vote Down

Have you ever noticed that, if you implemented Facebook like or Facebook Share in wordpress blog and when people click Like the shared post on user wall looks not good most of the time. This is because you didn’t implement the facebook open graph meta data in your blog post or page. As a result when facebook parse the link sometimes they can’t parse it properly that you expected.

To solve the situation you’ve to add open graph meta data in your site. Some days ago I manually added this in my blog’s theme, but later I decided to make a wordpress

  [Read more...]
Partitioning the WordPress Comments Table
Employee +4 Vote Up -0Vote Down

WordPress sites can get big. Really big. When you’re looking at a site of Cheezburger, Engadget or Techcrunch proportions, you get hundreds of comments per post, on dozens of posts per day, which adds up to millions of comments per year.

In order to keep your site running in top condition, you don’t want to be running queries against tables with lots of rarely accessed rows, which is what happens with most comments – after the post drops off the front page, readership drops, so the comments are viewed much less frequently. So, what we want to do is remove these old comments from the primary comment table, but keep them handy, for when people read the archives.

Enter partitioning.

The idea of MySQL partitioning is that it splits tables up into multiple logical tablespaces, based on your criteria. Running a query on a single partition of a

  [Read more...]
Using WordPress 3.1 on Drizzle
+5 Vote Up -2Vote Down

Since the GA release of Drizzle7 I’ve had several people asking me about how to convert their MySQL sites to use Drizzle instead.  By far the most common one to crop-up is WordPress.  This is aimed to be a simple guide to starting a new blog using WordPress 3.1 and Drizzle.

Initial Problems

WordPress by design is very MySQL orientated, for the most part this is good thing, but when trying to switch to another database for it there can be complications.  An attempt has been made to create a plugin to use Drizzle, but unfortunately it has side-effects such as modifying your content if you happen to blog about anything related to MySQL or Drizzle.  For the purposes of this blog post I have create a patch and will give instructions on how to use it below.  If any WordPress guru has a way to make this into a good plugin, please get in touch!

Conversions Needed

Almost all the

  [Read more...]
Using Wordpress 3.1 on Drizzle
+0 Vote Up -0Vote Down
Since the GA release of Drizzle7 I've had several people asking me about how to convert their MySQL sites to use Drizzle instead.  By far the most common one to crop-up is Wordpress.  This is aimed to be a simple guide to starting a new blog using Wordpress 3.1 and Drizzle.

Initial Problems


Wordpress by design is very MySQL orientated, for the most part this is good thing, but when trying to switch to another database for it there can be complications.  An attempt has been made to create a plugin to use Drizzle, but unfortunately it has side-effects such as modifying your content if you happen to blog about anything related to MySQL or Drizzle.  For the purposes of this blog post I have create a patch and will give instructions on how to use it below.  If any Wordpress guru has a way to make this into a good plugin, please get in touch!

Conversions


  [Read more...]

New year & new blog
Employee_Team +2 Vote Up -0Vote Down

The new year is here and I have moved my (so far quite silent) blog to use WordPress and MySQL 5.5 GA (http://www.mysql.com/downloads/mysql/).

Since I am using Ubuntu I downloaded a compressed tar archive. I installed it in a custom directory and for starting I wrote a little upstart script.

$ cat /etc/init/mysql-5.5.conf
start on startup
stop on shutdown

env basedir=/opt/mysql/mysql-5.5
env defaults=/etc/mysql-5.5/my.cnf

script
        cd $basedir
        $basedir/bin/mysqld_safe --defaults-file=$defaults
end script

In wp-config.php I have set:

  [Read more...]
Tech Messages | 2011-01-04
+0 Vote Up -0Vote Down

A special extended edition of Tech Messages for 2010-12-22 through 2011-01-04:

  [Read more...]
MySQL 5.5 GA launchd issues with Snow Leopard
+2 Vote Up -0Vote Down

I did a clean install on my Macbook Pro this morning, part of the clean install means, re-downloading things like MySQL.

When I installed it, I noticed that the pref-pane wouldn’t start MySQL. Even when it asked for my admin password. I thought maybe it was a boot up issue, so I rebooted, and got an error telling me that the permissions for the start up item were in secure.

Here’s what I did to debug/fix the problem.

  • Change permission of /Library/StartupItems/MySQLCOM/MySQLCOM
  • edit /usr/local/mysql/support-files/mysql.server and edited line 46 and 47 to say
chown -R root:wheel /Library/StartupItems/MySQLCOM
x

[content_box style="yellow-box" title="Edit mysql.server file"]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
[/content_box]

[break]
There is already a bug filed for this..

How to test your WordPress Cache
+0 Vote Up -0Vote Down

How I lost 30 pounds in 2010 – a weight loss guide for developers

Posted on December 30th, 2010 in blog, personal, zippykid.

2010 was a great year for me, I started a new company, and it’s been profitable since month 2, I closed my consulting company, and most importantly, I lost 30 pounds, and am more mobile/agile than I was in college. I’m 32 and I feel better than I did when I was 24. I’ve talked [...]

View  [Read more...]
Showing entries 1 to 30 of 60 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.