Posts tagged: MySQL

Say No2SQL or NoSQL – MongoDB

Listen to this Post. Powered by iSpeech.org

One year ago ( or even more ) I found which was called MongoDB. This database  concept is designed around “NoSQL”. The first time I saw it i thought: Uh, why the hell should I use it? And even the syntax it is used to get access to the stored data locked weird to me. You access your data like an array ( In general ). And I thought: It must be slow, if you compare MySQL, for example, against MongoDB. The idea was, as every language when you remove int, string and so on, the engine must first find out, which type of data is stored. But after reading a few benchmarks and tutorials about it. I can´t admit, that this database “type”. Is pretty powerful, easy to use and amazingly fast.

But you might still think: Why should I use, learn or even keep an eye on it?

Well, most users forgot, or at least: don’t want to know what happened to the MySQL developers. ( They were bought by SUNSun reviewsSun reviews/ OracleOracle reviewsOracle reviews ) They promised to keep MySQL alive as it is. And want to keep it opensource. But we all know that this is just a promise… The EU still keep an on SUN/ Orcale and MySQL. Cause they fear the same thing as many users fear. I dont think they could “close” MySQL now or later. But they could do other things. Reduce resources, introduce buggy versions. Stopping to work with the community and much more.

But now I don´t fear the death of MySQL, MongoDB is getting better and better. And if MySQL lose users, MongoDB will get more users :)

LinkLink reviewsLink reviews: http://www.mongodb.org/

The tutorial/ blog, which opened my eyes: PHP-Classes-MongoDB

mysql.sock vanished on my vserver

Listen to this Post. Powered by iSpeech.org

ManMan reviewsMan reviews,

the horror story no one wants. My mysql server stopped working. And I got a warning message from my “server watch” service.
First I thought, ok lets see whats up.  And browsed to my site. To see:

The mysqli error was: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2).

Man, and then I tried to fix this problem, but something must gone wild. Cant reinstall mysql, no way to purge it. Or remove it.
Every time I tried to reinstall a new problem went up. Nothing worked. The problem stays. Try to link it, recreate it, reinstalled, purged,
copied and so on. No chance…. I have no clue whats wrong. Even the “almighty” google wasnt a help. All solutions doesnt worked. so I have
to reinstall my vserver :(

And I still dont know why my mysql.sock vanished. I dont touched the server in the time where it could happened….

LouiseBrooks theme byThemocracy