Showing entries 20421 to 20430 of 44045
« 10 Newer Entries | 10 Older Entries »
Some may not be aware, but there's nothing spe...

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.

Open Query, new on Fifth Ave

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!

My new startup: 1-900-SELECT

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.

Big Data is how big exactly?

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]
New MySQL Training Course - Introduction to MySQL 5.5

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.

Use Replication for backups? Are you schemas consistent?

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]
Outliers and coexistence are the new normal for big data

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]
New MySQL Training Course - Introduction to MySQL 5.5

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

 

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

 

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]
Showing entries 20421 to 20430 of 44045
« 10 Newer Entries | 10 Older Entries »