Posts Tagged ‘skysql’

MariaDB Enterprise 1.0 is Here

Saturday, January 25th, 2014

I know it was officially announced Monday, but I just wanted to take a moment and let everyone know MariaDB Enterprise 1.0 is now available, in case you missed the previous article.

What does MariaDB Enterprise consist of?

“MariaDB Enterprise is composed of several components including MariaDB Manager, which is a set of management tools and an API with which you can easily provision, monitor, and manage a highly available MariaDB Galera Cluster for multi-master, synchronous replication. Galera is a powerful technology that can eliminate single points of failure for your database infrastructure, but it is relatively new and can be a challenge to configure for administrators who aren’t familiar with it.”

https://mariadb.com/..MariaDB Enterprise – Getting Started Guide…pdf

How does it do this?

“MariaDB Enterprise has an API layer as its foundation. The GUI tool which you use to provision, monitor and manage your cluster does all of its work through calls to the RESTful API, including provisioning cluster nodes on bare metal Linux boxes or newly instantiated virtual machines or AMIs. By packaging up the product’s capabilities in this API, we’ve both made it easy to manage Galera Clusters through our GUI, and also provided a powerful tool to simplify the automation of high availability within popular automation and configuration management frameworks.”

https://mariadb.com/blog/mariadb-enterprise-release-10-open-source-api-driven-ready-you

There is much more information about MariaDB Enterprise in the above 2 links as well, if interested.

And if you’d like, you can download it from here:

https://mariadb.com/downloads

 

Awesome to see the MySQL Ecosystem Flourishing

Saturday, March 30th, 2013

I just wanted to take a moment and thank, notice, what ever you want to call it, but share some love with all those and all things MySQL.

I read the post Let’s Celebrate MySQL 5.6 GA! – MySQL Community Reception by Oracle by Oracle MySQL Group and it got me to thinking of how proud I am of (and proud to be a part of) the whole MySQL Ecosystem.

We *should* all celebrate MySQL 5.6 GA! I well remember the 3.22 and 3.23 days, and there were many folks before me already using MySQL!!!

I love to see how it has continued to grow, the ecosystem and all things MySQL, that is. MySQL is better than ever. MariaDB is better than ever. Percona Server is better than ever. You have great Support options with MySQL/Oracle, SkySQL/MariaDB, and Percona as well – not to mention numerous others. I just love the fact that everyone is flourishing, and improving, and the technology continues to advance and most importantly, everyone is working together to provide a great software and service to all MySQL/MariaDB/InnoDB/XtraDB/etc-related users out there.

Not to mention the monitoring softwares, the various plugins and connectors, the numerous storage engines, the number of 3rd party apps & helpful scripts, User Conferences, local meet-ups, books, tutorials, the number of Community bloggers who freely and spiritedly share their knowledge, time, advice, ideas, concerns, and so on. It’s just a great Community to be a part of, and I’m thrilled to see how it’s grown, and continues to grow over the years. And that’s just a testament of the quality of all you great people out there involved and helping. :)

I won’t get too mushy, but it is great to see the MySQL Ecosystem and all of those in it flourish, and may it continue for many, many years to come! :)

Big thanks to everyone out there contributing! “It takes a village, and we are that village”, as my wife always says. :)

 

Tracking down strange “Can’t find file” (ER_FILE_NOT_FOUND) Errors

Saturday, March 9th, 2013

Ever see an error like this in your console or error log, respectively, and wonder where it originated from?

Console (5.5.30):

ERROR 1017 (HY000): Can't find file:
'.\test\select@0020@002a@0020from@0020t1.frm' (errno: 22)

Error Log (5.5.30):

130307 23:22:04 [ERROR] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: 
Can't find file: '.\test\select@0020@002a@0020from@0020t1.frm' (errno: 22)

(Fwiw, they are harmless, unless it is indicative of some sql injection – but you may want to sanitize your data better, unless it’s just a one-time user error. Also, if you’re seeing it from the command line, then you’ll likely realize what you did immediately, and thus no need to ‘figure out’ what happened. However, when you *only* see this entry in the error log, and you want to know how that happened after the fact, then this is more relevant.)

At any rate, after searching the code, one can see that “can’t fild file” can originate from several locations, two such being in ./sql/sql_show.cc and ./sql/sql_rename.cc (the code for SHOW CREATE TABLE and RENAME TABLE, respectively).

So, working backwards, I tried both a SHOW CREATE TABLE and RENAME TABLE (with bogus table names), and was able to reproduce the error (because I was wondering how this ended up in an error log I was analyzing):

mysql> SHOW CREATE TABLE `select * from t1`;
ERROR 1017 (HY000): Can't find file: 
'.\test\select@0020@002a@0020from@0020t1.frm' (errno: 22)

mysql> RENAME TABLE `select * from t1` to `t2`;
ERROR 1017 (HY000): Can't find file: 
'.\test\select@0020@002a@0020from@0020t1.frm' (errno: 2)

Note the first *does* get logged to the error log, whereas the second one does not. I’ve filed a bug report about this behavior:

http://bugs.mysql.com/bug.php?id=68618

The only difference between the two errors are the errno values are different for each (22 vs. 2). For reference, here are the meanings for codes 22 and 2 respectively:

C:\Windows\system32>perror 2
OS error code   2:  No such file or directory
Win32 error code 2: The system cannot find the file specified.

C:\Windows\system32>perror 22
OS error code  22:  Invalid argument
Win32 error code 22: The device does not recognize the command.

I will say that in 5.6, the error message is a bit more descriptive by mentioning the text of the “errno”:

Console (5.6.10):

mysql> show create table `select * from t1`;
ERROR 1017 (HY000): Can't find file: 
'.\test\select@0020@002a@0020from@0020t1.frm' (errno: 22 - Invalid argument)
mysql> rename table `select * from t1` to `t2`;
ERROR 1017 (HY000): Can't find file: 
'.\test\select@0020@002a@0020from@0020t1.frm' (errno: 2 - No such file or directory)

Error Log (5.6.10):

2013-03-09 10:33:38 6340 [ERROR]
C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld:
Can't find file: '.\test\select@0020@002a@0020from@0020t1.frm'
(errno: 22 - Invalid argument)

Hope this helps. :)

 

SkySQL – Looking for APAC Support Engineer

Monday, December 10th, 2012

SkySQL is looking for a great Support Engineer to join our Team and work the APAC shift. This means you do not need to reside in APAC, but just want to work those hours. :)

If interested, there is a full description of the position here:

http://www.skysql.com/company/careers/skysql-support-engineer-apac

And as the post says, if you are interested, please send your resume/CV to careers@skysql.com.

Also, if you’d like, please feel free to ping me as well [chris at skysql dot com] and I can try to get your resume looked at with a higher priority (and feel free to ask me any questions too).

Happy Holidays! :)

Database Marketing Manager Position Now Open at SkySQL

Tuesday, August 28th, 2012

SkySQL is Looking for a Senior Marketing Manager for North America!

If you or someone you know is looking for this kind of position, then this is a great opportunity.

I’ll spare all of the details, but if you’re interested, you can read more about the position here:

http://www.skysql.com/content/senior-marketing-manager-north-america

And as always, you can view all of SkySQL’s open positions here (as we’re also looking for Engineers and Consultants):

http://www.skysql.com/company/careers

 

SkySQL is Hiring!

Monday, June 25th, 2012

SkySQL is hiring! Would you like to join a fast-paced, high-growth company where you’re able to make a difference? Please email us your CV, today, at careers@skysql.com. We look forward to hearing from you!

Here are our current open positions:

QA Engineer

Senior Software Engineer

SkySQL Support Engineer – EMEA

Senior Sales Engineers – EMEA & North America

Senior Consultants – EMEA & North America

For those interested, our full careers page can be found here:

http://www.skysql.com/company/careers

 

SkySQL Raises Additional 2.5 Million Dollars From California Technology Ventures

Thursday, May 31st, 2012

Yesterday, it was announced that SkySQL has raised an additional 2.5 million dollars in Series A funding from California Technology Ventures.

This comes along with the news of the new CEO, Patrik Sallner, taking the CEO role at SkySQL on July 1st.

Here are some relevant snippets:

“SkySQL also announced today that CTV, a venture capital fund that makes direct investments in technology and life science companies globally, invested an additional $2.5 million as part of the company’s recent A round of funding. With this latest investment, SkySQL has collected EUR 6 million to fund further growth.”

“About California Technology Ventures, LLC
California Technology Ventures, LLC is a venture capital fund that makes direct investments in technology and life science companies. CTV has built a strong reputation for its entrepreneurial approach to investing and working with companies. They believe in guiding entrepreneurs through the strategic, operational, and management decisions critical to a company’s success. For more information, please view www.CTVentures.com.”

If interested, there are much more details on this round of funding here:

http://www.skysql.com/news-and-events/press-releases/…

 

SkySQL Soaring to New Heights

Thursday, May 31st, 2012

In case you may have overlooked yesterday’s post from Ulf Sandberg, I thought I’d go ahead and reiterate the main points, as it is big news, at least for those interested in SkySQL.

SkySQL has been like a rocket ship with it’s growth since we started, and now we’re making some even bigger changes to help accelerate that effort further.

As Ulf announced, we’ve named a new CEO, Patrik Sallner, to take over after the initial bootstrap period.

Patrik, a former executive at F-Secure, will officially become CEO on July 1st. “Patrik comes to SkySQL with demonstrated experience in building international software and services businesses, including delivering cloud storage solutions to the world’s largest telecommunications operators. The addition of Patrik to SkySQL’s Leadership Team is a tremendous boon to the company, and I have every confidence that he will be instrumental in catapulting SkySQL to the next level.”

Again, I just wanted to share the news for those who may have missed it.

For those interested, more on this can be found here:

http://www.skysql.com/blogs/ulf-sandberg/new-faces-and-funding-take-skysql-cloud

 

With InnoDB’s Transportable Tablespaces, Recovering Data from Stranded .ibd Files is a Thing of the Past

Thursday, April 26th, 2012

Being a data recovery specialist and having recovered countless GBs of corrupted, and/or stranded, InnoDB data in my days, I am very happy to hear about the new InnoDB Transportable Tablespaces coming in MySQL 5.6!

Back in the day, if you had a stranded .ibd file (the individual InnoDB data file with –innodb-file-per-table option), you basically had nothing (even though that file contained all of the data). This was because unless you had the original instance that that particular .ibd file (table) originated from, there was no way to load it, import, or dump from it. So it was not of much use, though all the data was *right* there.

Thus I created the method of Recovering an InnoDB table from only an .ibd file (I should note that this was before the InnoDB Recovery Tool had been released, which can also be used to recover data from a stranded .ibd file too).

However, if you’ve used either my method or the InnoDB Recovery Tool for such a job, it can be a bit of work to get the data dumped. For those experienced, it goes much faster. But still, you cannot get any faster than just being able to (roughly) import the individual tablespace right into any running MySQL 5.6 instance. :)

Nice work! :)

Note: Again, I must mention this is only in MySQL 5.6, so if you have a stranded .ibd file you need to recover data from pre-5.6, you’ll either need to use my method or the InnoDB Recovery Tool.

 

Create MariaDB Windows Service

Thursday, April 19th, 2012

I’d had some difficulty manually creating my own windows service for MariaDB (worked fine from the installer), but it was due to the way I was creating it, so I wanted to share the proper approach:

Old Way:

sc create "maria55" binpath= "\"C:/Program Files/MySQL/MariaDB 5.5/bin/mysqld\"
\"--defaults-file=C:/Program Files/MySQL/MariaDB 5.5/data/my.ini\""
DisplayName= "Maria55" start= "auto"

New Way:

sc create "maria55" binpath= "\"C:/Program Files/MySQL/MariaDB 5.5/bin/mysqld\"
\"--defaults-file=C:/Program Files/MySQL/MariaDB 5.5/data/my.ini\" maria55"
DisplayName= "Maria55" start= "auto"

The key is adding the name, maria55, after the –defaults-file=.. option, but still within the “” that belong to “binpath”.

This extra parameter exists so that mysqld knows whether or not it was started as a service or not.

Without it, the server does not know, and therefore didn’t realize it was running as a service, and thus since the service manager got no response from mysqld, it terminated the service after 30 seconds (though I could connect and issue any MySQL command or query within that 30 seconds).

Many thanks to Wlad for helping me to track this down!

For reference, here is my terminal output:

C:\>sc create "maria55" binpath= "\"C:/Program Files/MySQL/MariaDB 5.5/bin/mysqld\"
\"--defaults-file=C:/Program Files/MySQL/MariaDB 5.5/data/my.ini\" maria55"
DisplayName= "Maria55" start= "auto"
[SC] CreateService SUCCESS

C:\Users\Chris>net start maria55
The maria55 service is starting.
The maria55 service was started successfully.

With the initial service attempt, the service creates fine, but fails after 30 seconds:

C:\Users\Chris>net start maria55
The service is not responding to the control function.

More help is available by typing NET HELPMSG 2186.

Hope this helps.

 


Period Panties by Period Panteez Menstrual Underwear Menstruation PMS Panty