Embedded MySQL version

6 posts / 0 new
Last post
ssheremeta
ssheremeta's picture
Offline
Last seen: 3 months 2 weeks ago
Joined: Apr 16 2014
Junior Boarder

Posts: 1

Sergey Sheremeta
Embedded MySQL version

Hello!

Does anybody know how to upgrade embedded MySQL to 5.6 version?
 

radams
radams's picture
Offline
Last seen: 3 days 8 hours ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
 InfiniDB 4.5 includes the 5

 

InfiniDB 4.5 includes the 5.1.73 version of MySQL. This can not be configured to a different version.

 

Thanks!

 

 

 

 

 

taraso
taraso's picture
Offline
Last seen: 2 months 5 days ago
Joined: Jun 17 2014
Junior Boarder

Posts: 6

Taras Onishchuk
InnoDB engine

I attempted to enable InnoDB engine with the embedded MySQL, but had no luck with that, so had to stuck with MyISAM for classic relational tables.

 

Does anybody know how to make InnoDB work with InfniDB eninge (for cross-engine joins, obviously)?

radams
radams's picture
Offline
Last seen: 3 days 8 hours ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
InnoDB engine

 

The show engine command will display the available engines.

 

# idbmysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.1.73 InfiniDB 4.6.0-1
 
Copyright (c) 2014, InfiniDB, Inc. and/or its affiliates. All rights reserved.
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
 
InfiniDB is a registered trademark of InfiniDB, Inc. and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> show engines;                                                                                                                                          
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                    | Transactions | XA   | Savepoints |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
| CSV        | YES     | CSV storage engine                                         | NO           | NO   | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables  | NO           | NO   | NO         |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance     | NO           | NO   | NO         |
| InfiniDB   | YES     | InfiniDB storage engine                                    | YES          | NO   | NO         |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                      | NO           | NO   | NO         |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
6 rows in set (0.00 sec)

 

 

 

The InfiniDB engine gets created as part of running postConfigure. postConfigure will run 2 scripts, which will create the engine as well as setup the system-catalog.

 

If you have run postConfigure and for some reason the engine didn't get created, you can try doing the following steps:

 

# /etc/init.d/mysql-Calpont stop

# /usr/local/Calpont/bin/post-mysqld-install

# /usr/local/Calpont/bin/post-mysql-install

# /etc/init.d/mysql-Calpont start

 

 

Thanks,

 

Robert

 

 

taraso
taraso's picture
Offline
Last seen: 2 months 5 days ago
Joined: Jun 17 2014
Junior Boarder

Posts: 6

Taras Onishchuk
Hi Robert,
Hi Robert,
 
Thanks for getting back to me. Here is the list of the engines available:
 
mysql> show engines; 
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                   | Transactions | XA   | Savepoints |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                     | NO           | NO   | NO         |
| CSV        | YES     | CSV storage engine                                        | NO           | NO   | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables | NO           | NO   | NO         |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance    | NO           | NO   | NO         |
| InfiniDB   | YES     | InfiniDB storage engine                                   | YES          | NO   | NO         |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
 
If I uncoment InnoDB options in my.cnf, mysql won't start.
 
What chances the data which is already in InfniDB will be erased if I run the commands? Will data root be retained?
 
# /usr/local/Calpont/bin/post-mysqld-install
# /usr/local/Calpont/bin/post-mysql-install
 
 
bdempsey
bdempsey's picture
Offline
Last seen: 1 month 4 weeks ago
Joined: Oct 27 2009
Platinum Boarder

Posts: 194

Robert Dempsey
Can you try from the mysql>

Can you try from the mysql> prompt:

 

install plugin innodb soname 'ha_innodb_plugin.so';