I'm on the website, so now it's official:
I’m excited about joining Percona as a consultant, which took effect last week. Learning a lot, and I’m looking forward the challenge of filling a ton of gaps in my mysql and systems knowledge.
I’m hoping to start blogging soon about stuff I’m learning.
I'm on the website, so now it's official:
I’m excited about joining Percona as a consultant, which took effect last week. Learning a lot, and I’m looking forward the challenge of filling a ton of gaps in my mysql and systems knowledge.
I’m hoping to start blogging soon about stuff I’m learning.
I've been doing lately quite many database clustering implementations; Oracle RAC and since we have many MySQL instances in production, had to find a good way to make MySQL instances highly available also.
One good solution for this is managing MySQL instances with clusterware and since we are planning to use Oracle RAC on Oracle Enterprise Linux anyway, then Oracle Clusterware is an excellent candidate for this task. Also... Oracle Clusterware is included with Oracle Enterprise Linux at no additional charge.
Requirements I had:
Dr. Dobb’s published yesterday an article by Jimmy Yang and John Russel about Full-Text Search with InnoDB:
"MySQL's latest InnoDB engine can now do extensive, high-performance, full text search. A quick primer delivers all the goodies.
Oracle recently provided access to many new MySQL 5.6 features
through http://labs.mysql.com for the user community to
test and comment on. One notable feature is the InnoDB Full-Text
Search (FTS) engine. It lets users build FULLTEXT
indexes on InnoDB tables to represent text-based content and
speed up searches for words and phrases. Combining full-text
search with InnoDB tables opens up text capability to
transactional applications, where the textual data is frequently
inserted, updated, and deleted. Given the importance of this
feature to the MySQL audience, this article explains the design
of InnoDB FTS and …
The mysqli quickstart series is coming to an end. Today, the post is about non-prepared statements. You may also want to check out the following related blog posts:
Using mysqli to execute statements
Statements can be executed by help of the
mysqli_query(), mysqli_real_query() and
mysqli_multi_query() function. The
mysqli_query() …
Dr. Dobb’s published yesterday an article by Jimmy Yang and John Russel about Full-Text Search with InnoDB:
"MySQL's latest InnoDB engine can now do extensive, high-performance, full text search. A quick primer delivers all the goodies.
Oracle recently provided access to many new MySQL 5.6 features
through http://labs.mysql.com for the user community to
test and comment on. One notable feature is the InnoDB Full-Text
Search (FTS) engine. It lets users build FULLTEXT
indexes on InnoDB tables to represent text-based content and
speed up searches for words and phrases. Combining full-text
search with InnoDB tables opens up text capability to
transactional applications, where the textual data is frequently
inserted, updated, and deleted. Given the importance of this
feature to the MySQL audience, this article explains the design
of InnoDB FTS and …
If you use the God gem to manage your Ruby on Rails application server (Unicorn, for example), you will have to restart the application server using God after deploying a new version.
I found a solution that polls the application’s tmp directory for restart.txt (like Phusion Passenger does) from within the god configuration and restarts the app if the file is touched. However, it didn’t work well for me because the ps syntax varies on different systems and the method is not very reliable (it triggered when I didn’t want it to, and vice versa).
So I thought about it and now I think that the best solution to restart an app via god is to do (surprise):
god restart YOUR-APP
And it should be done exactly if capistrano deploys, and …
[Read more]
So this is a simple free example of how to check a phone number
via a mysql database. Yes more complete validation options are
available, some even have to pay for, but this is better than no
check at all.
The data is available here : wget -q http://www.telcodata.us/custom/telcodata.dump
It loads a table like this: CREATE TABLE `telcodata` ( `npa`
int(3) NOT NULL, `exchange` int(3) NOT NULL, `thousands` int(3)
NOT NULL DEFAULT '-1', `company` text, `ratecenter` text, `clli`
text, `type` text, `emaildomain` text, `parentco` text, `state`
text, `zip` text, `lat` float(9,5) DEFAULT NULL, `lon` float(9,5)
DEFAULT NULL, `latanum` int(11) DEFAULT NULL, `ocn` varchar(4)
NOT NULL, `ilec` varchar(4) DEFAULT NULL, `ilecname` text,
`tandem` text, KEY `rcstate` (`ratecenter`(11),`state`(2)), …
Most of you are all aware of the lack of microsecond support in MySQL.
This has been a long-standing issue:
http://bugs.mysql.com/bug.php?id=8523
*cringe* .. sorry, just my normal reaction after seeing that bug, err feature request, again and again over the past 6+ years ..
However, I think many people do not realize that microseconds are supported by MariaDB in version 5.3+, which for all intensive purposes is a drop-in replacement for MySQL.
So if you need microsecond support for MySQL, you should definitely check out MariaDB.
“In MariaDB 5.3, the TIME, DATETIME, and TIMESTAMP types, along with the temporal functions, CAST and dynamic columns, now support microseconds. The datetime precision of a column can be specified when creating the table with CREATE TABLE”
Also:
“Generally, the precision can be …
[Read more]
Howdy everyone!
I'm very happy to announce that very soon XtraBackup Manager will
be released in an initial alpha capacity.
The command-line configuration and management interface is very
close to completion and I'll be working on some documentation
soon too.
This alpha will serve as a way to get some early adopters testing
the tool as well as help collate feedback on necessary features
that I may have missed including so far.
Stay tuned!…
The first completely FREE/OSS management software for XtraBackup
will be available soon!
Cheers,
Lachlan