Some may not be aware, but there's nothing special about he
'root' user. Unlike unix 'root', in MySQL there doesn;t have to
be such an account. It's just a convention.
In fact, many delete the 'root' user and create an 'admin' user,
or something similar, in order to tighten their security.
Some of you already know since you helped us move, we recently shifted Open Query’s main office to Fifth Avenue, next door to Elizabeth’s. The new place is comfortable, I really like it so far. Anna is also happy with her new admin space and cat Figaro has found an empty spot on a bookshelf to stretch out on!
The lease costs are a bit steep, as is common these days… chances are we’ll just buy our next place.
Follow-Up yes this was an April 1st post. But, everything in the above post is the truth, it’s just phrased to be very open for a bit of mis-interpretation
I find that the real world provides plenty of fun and unbelievable yet true tidbits, so why bother making up nonsense!
Working at Percona has taught me to love being disruptive and creating innovative pricing models. In particular, their pay-as-you-go pricing in 15-minute increments, plus the ability to go from first contact to having them logged in and working in a few minutes with just a credit card, has been game-changing. I’ve always wanted to take that to the next level and create a new business, offering MySQL services with a radically simple pricing model.
I see that “Big Data” has become the new buzzword with a spike of hype around it. Everyone’s jumping on it. Companies are eager to promote their products as “Big Data,” just as they were eager to be associated with Web 2.0, Service-Oriented Architectures, and all the rest. Predictably, there’s basically zero agreement on what it means.
I’ve seen “Big Data” mentioned in the context of 1TB, which I think is rather moderate sized. But worse yet, I’ve seen 100GB labeled Big Data. I’ve even seen 5GB labeled Big Data. No links — I don’t want to draw attention to them.
I don’t know what Big Data is, but the stick-of-gum-sized flash drive in my pocket holds 16GB. It’s pretty Small. I mean, I forget it’s even there — it’s definitely not Big. I don’t know where I’d draw the line, but if it fits in a commodity server’s memory, which 100GB can do easily these days, it’s not Big Data. I don’t even …
[Read more]
Developers, DBAs and Consultants take MySQL training courses to
learn the latest functionalities and gain confidence on MySQL
database and tools. Oracle's MySQL curriculum has been updated by
Oracle University to support the latest MySQL 5.5 GA release. To
help you get started, we recently created a new one-day seminar -
Introduction to MySQL 5.5. Attend the course
and learn all the new features and key enhancements to MySQL 5.5
and the MySQL Enterprise Edition!
For more MySQL training course details and schedules, visit
oracle.com/education/MySQL.
Many people have a master/slave MySQL environment of various
different topologies, and many use the slave as a backup.
Is your slave schema identical to your production schema? As long
as an SQL statements completes without an error, your slave
schema can differ. Common examples are different indexes or
storage engines for example. However if you use the slave as
backup, you want to ensure when you recover, you are recovering a
production environment, not a slave environment.
While the changes may be small, the can lead to different results. For a client I found that the default value of a price field was 10.00 in one schema and 0.00 in another. Not withstanding using defaults for important fields and not defining in an INSERT is a different issue, it highlighted the different schemas can easily exist.
My tool of choice is SchemaSync. The reason why I like this command is …
[Read more]Letting data speak for itself through analysis of entire data sets is eclipsing modeling from subsets. In the past, all too often what were once disregarded as "outliers" on the far edges of a data model turned out to be the telltale signs of a micro-trend that became a major event. To enable this advanced analytics and integrate in real-time with operational processes, companies and public sector organizations are evolving their enterprise architectures to incorporate new tools and approaches.
Whether you prefer "big," "very large," "extremely large," "extreme," "total," or another adjective for the "X" in the "X Data" umbrella term, what's important is accelerated growth in three dimensions: volume, complexity and speed.
Big data is not without its limitations. Many organizations need to revisit business processes, solve data silo challenges, and invest in visualization and collaboration tools to make big data understandable and …
[Read more]
Developers, DBAs and Consultants take MySQL training courses to
learn the latest functionalities and gain confidence on MySQL
database and tools. Oracle's MySQL curriculum has been updated by
Oracle University to support the latest MySQL 5.5 GA release. To
help you get started, we recently created a new one-day seminar -
Introduction to MySQL 5.5. Attend the course
and learn all the new features and key enhancements to MySQL 5.5
and the MySQL Enterprise Edition!
For more MySQL training course details and schedules, visit
oracle.com/education/MySQL.
MySQL Search facility is gone …
Well it happens, after a long period of time without one second of relax The MySQL Dolphin Search, nick name Fetch for the friends, decide to go on vacation.
He was already not working as expected, and I remember times when together with other colleagues we were pushing on him to be more precise, and less restrictive, more “concept” oriented than “word” oriented. Not really accepting comments he was his way, and in any case we were loving him.
What happen recently I don't know, from when I left I didn't had the chance to talk with him too much, but just recently I was in the need to have his support, but he was not there... instead there was a message, saying that a search for “InnoDB” :
“Skip navigation links
Oracle Secure Enterprise Search
* …
[Read more]
MySQL Search facility is gone …
Well it happens, after a long period of time without one second of relax The MySQL Dolphin Search, nick name Fetch for the friends, decide to go on vacation.
He was already not working as expected, and I remember times when together with other colleagues we were pushing on him to be more precise, and less restrictive, more “concept” oriented than “word” oriented. Not really accepting comments he was his way, and in any case we were loving him.
What happen recently I don't know, from when I left I didn't had the chance to talk with him too much, but just recently I was in the need to have his support, but he was not there... instead there was a message, saying that a search for “InnoDB” :
“Skip navigation links
Oracle Secure Enterprise Search
…
[Read more]