Well. This is going to be interesting. If you are certified Oracle Database Administrator, you can receive the special treatment from MySQL. You can some free stuff, training and FREE LUNCH. All you have to is be the first 100 users to signup their MySQL Bootcamp.
Are you interested in the FREE MySQL certification? Be an Oracle DBA first.
Well. After my post yesterday about MediaTemple.net’s fast response to my blog. My client was down this morning for unknown period of time. According to their webblog.
Network upgrades, FTP
May 23rd, 2007 at 10:04 amDue to today’s outage (mt) engineers will be performing upgrades to several on our load balancers. These rolling upgrades may cause disruptions of FTP service especially when transferring large files, webmail may also be affected. HTTP and email services should not be affected by this maintenance, customers on other product lines are also unaffected.
We expect to have these upgrades done by no later than 1:00pm PDT at which time we will update this thread with any further news.
You can read more about their “System Incidents” blog here. It seems to me there are issues with their GS – Grid Services all the time since they starts it. With MySQL running on different shared server, there is chance to get bottle neck on connection to MySQL. You can search google blog and find many post related to their GS. So should I switch to other hosting company for my client?
Most of the Linux hosting company host their MySQL on the same server as “Localhost”, which avoids the network traffic. However, it has limited scalability. Compare with what my client was getting few weeks ago from other hosting company, MT is still standing solid. At least they do admit there was a problem and downtime, and post the message accordingly to their web site for people to see and making comments. You don’t see that often from other hosting company. Some of the hosting company don’t even bother to tell you there was a problem. They just wipe out your entire account and restore it from a week old backup.
Why do I so care about MediaTemple.net? No! I don’t care! What I care is to give my client the best service and ensure they are happy with what their web site brings to them. MediaTemple, please keeps up the good works and don’t let me down.
Now FindyPages.com has added the fulltext search features for searching pages. It creates a better search results on page keywords, page description, page name and page url.
However, as far as I can tell that MySQL 4.0 is having some restriction on the fulltext search.
A few restrictions affect MySQL FULLTEXT indices. Some of the default behaviors of these restrictions can be changed in your my.cnf or using the SET command.
FULLTEXT indices are NOT supported in InnoDB tables.stopwords file that has a list of common words (i.e., the, that, has) which are not returned in your search. In other words, searching for the will return zero rows.AGAINST() must be a constant string. In other words, you cannot search for values returned within the query.select count(members_pages.pageid) as record_count
from members
inner join members_pages on members.memberid = members_pages.memberid
where members.status_access = 1
and members_pages.status_access = 1
and members_pages.status_viewable_by = 1
and (
MATCH(members_pages.page_name, members_pages.page_keywords, members_pages.page_desc, members_pages.page_url) AGAINST (‘” . trim(strtolower(addslashes($keywords))) . “‘ IN BOOLEAN MODE)
or lower(members_pages.page_url) like ‘%” . trim(strtolower(addslashes($keywords))) . “%’)”;
