- discuss - lists.mariadb.org

[Maria-discuss] MaxScale Multiple Masters
by Riz Plate 03 Mar '15

03 Mar '15

Hi I have a very basic scenario, we have one database which is running out of space. database have some tables with incremental primary key ids. 1- for new ids , we want to send read/write to new server and preferably , do id based statement routing i.e. if id%2=0 push to new-server1 , else read/write to new-server2. 2- some tables are created dynamically i.e. dynamic_table_123. we want to send 123%2=0 to new-server1 else read/write to new-server2. 3- all statements in above #1, #2 should go to same MaxScale abstraction i.e. application should not have logic for routing. Can we do this with MaxsScale? what are the configuraion readwriterouter or the cluster? Thanks for your insight and recommendations. Thanks

1 0

[Maria-discuss] New Question: ResultSetMetaData getColumnClassName accuracy for JDBC
by AskMonty KB 02 Mar '15

02 Mar '15

Hello, A new question has been asked in "Client Libraries" by tommy_pham_g. Please answer it at http://mariadb.com/kb/en/resultsetmetadata-getcolumnclassname-accuracy-for-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi folks, I'm having problems getting the getColumnClassName to return the correct information. I have a sample table: CREATE TABLE `datatypes` ( `mariadb_binary` binary(8) NULL, `mariadb_blob` blob NULL, `mariadb_boolean` tinyint(1) NULL, `mariadb_varbinary` varbinary(16) NULL, `mariadb_varchar` varchar(5) CHARACTER SET utf8 NULL, UNIQUE KEY `mariadb_serial` (`mariadb_serial`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; The ResultSetMetaData is not returning accurate GetColumnClassName information for some of the above columns: [INFO ] 2015-03-02 09:26:52.905 [main] c.d.d.AppDbTest.main - getColumnName mariadb_binary | getColumnLabel mariadb_binary. getColumnClassName [B. getColumnDisplaySize 8. getColumnType -2. getColumnTypeName BINARY. [INFO ] 2015-03-02 09:26:52.905 [main] c.d.d.AppDbTest.main - getColumnName mariadb_blob | getColumnLabel mariadb_blob. getColumnClassName [B. getColumnDisplaySize 65535. getColumnType -4. getColumnTypeName BLOB. [INFO ] 2015-03-02 09:26:52.905 [main] c.d.d.AppDbTest.main - getColumnName mariadb_boolean | getColumnLabel mariadb_boolean. getColumnClassName java.lang.Boolean. getColumnDisplaySize 1. getColumnType -7. getColumnTypeName TINYINT. getPrecision 1. [INFO ] 2015-03-02 09:26:52.998 [main] c.d.d.AppDbTest.main - getColumnName mariadb_varbinary | getColumnLabel mariadb_varbinary. getColumnClassName [B. getColumnDisplaySize 16. getColumnType -3. getColumnTypeName VARBINARY. getPrecision 16. [INFO ] 2015-03-02 09:26:53.014 [main] c.d.d.AppDbTest.main - getColumnName mariadb_varchar | getColumnLabel mariadb_varchar. getColumnClassName java.lang.String. getColumnDisplaySize 5. getColumnType 12. getColumnTypeName VARCHAR. getPrecision 5. Is the above by design? Is it bug within JDBC spec? I'm using MariaDB JDBC version 1.1.8. Thanks, Tommy -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/resultsetmetadata-getcolumnclassname-accuracy-for-…

1 0

[Maria-discuss] Serious problem with latest (10.0.16) Windows installer - destroys services.
by Peter Laursen 02 Mar '15

02 Mar '15

I have MariaDB 5.5, 10.0 and 10.1 installed (as Windows services named 'maria55'. 'maria10' and 'maria10_1' ) and always update them to latest soon after an update is available. Yesterday morning I installed 10.0.16 on top of 10.0.15 using the .msi installer. When I tried to connect to it a few hours later it was not possible. I thought the service might not be running. It wasn't. Actually it did not exist anymore at all! "net start maria10" returned "service does not exist" (and indeed it did not appear in Windows "services management" interface). I copied the /datadir, uninstalle , did a fresh install of 10.0.16d (choosing the option not to upgrade any existing server) and copied the old /datadir back. Now Maria 10.0(.16) works again. But now I see that the 'maria55' service is also gone from the system. Files are intact. I can repeat the exercise I did with 10.0 of course or install service again from commandline. Not a big problem, but very annoying and waste of time. MariaDB 10.1 installaton is not affected. 5 diiferent Oracle/MySQL servers (from 5.0 to 5.7) also are not. I need all those instances for application testing. Questions: * Has somebody else experienced this? * Has somebody replaced @wlad as maintainer of Windows installers? @wlad was the only person who ever was able to write reasonable MySQL/MariaDB installers. So I would regret that. It is perfectly legal on Windows to have multiple MariaDB servers simultaneously running as Windows services. They won't conflict as long as service name, port, basedir and datadir are all different. What happens with one should not affect another. I the installer does not respect this, it is a bug. -- Peter -- Webyog

5 10

[Maria-discuss] MariaDB 10.0.17 and 10.1.3 released
by Daniel Bartholomew 02 Mar '15

02 Mar '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.17 & 10.1.3 MariaDB 10.0.17 is a Stable (GA) release. MariaDB 10.1.3 is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.17 - Release Notes: https://mariadb.com/kb/en/mariadb-10017-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10017-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.17 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ MariaDB 10.1.3 - Release Notes: https://mariadb.com/kb/en/mariadb-1013-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1013-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.3 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Giving up on dynamic columns
by Tom Worster 02 Mar '15

02 Mar '15

I discovered this showstopper on Friday while working with real data in development of a new app. I managed to narrow it down today and filed the bug report. https://mariadb.atlassian.net/browse/MDEV-7650 Looks like Maria saves an illegally formatted dyncol string if a dynamic column is longer than 64kB and is not alphabetically last by name among the dynamic column in the blob. Tbh, even is this were fixed tomorrow so I could proceed with my work, I'm not sure I would use dyncols. My confidence in the feature has been shaken. It's a pity because the Active Record ORM extension I wrote was working. Tom

4 6

[Maria-discuss] myisam_use_mmap unstable in MariaDB 10.0.x
by Reindl Harald 01 Mar '15

01 Mar '15

historical: http://lists.mysql.com/mysql/226361 after it turned out to be stable in 2013/2014 upgrade to MariaDB 10.0.17 yesterday and the logs started with "table corrupt", "table not closed properly" and so on for tables which where not only read this time not with 'mysqld got signal 11' but "only" corrupted MyISAM files and after disable 'myisam_use_mmap' all is clean and stable over hours BTW a 'repair table' don't delete the TMM file leading in a 'optimize table' later failing until you delete the file manually from disk __________________________________________________________________ this configuration is unchanged for years and so my only conclusion is that Oracle managed to kill the feature again, this is also confirmed for Percona Server 5.6 where even queries fail confirmed from another sysadmin which found out that playing with my settings leaded to problems while here MariaDB 5.5.x was in use and hence no troubles - given that 'myisam_use_mmap' is borked at MariaDB 10.x and Percona 5.6 it's likely a backport from MySQL 5.6 delay-key-write = ALL concurrent_insert = 2 open-files-limit = 750000 myisam-recover-options = "FORCE" myisam_use_mmap = 0 wait_timeout = 300 interactive_timeout = 300 max_allowed_packet = 200M max_connections = 500 max_tmp_tables = 150 max_connect_errors = 250 max_delayed_threads = 32 flush_time = 0 query_cache_limit = 256K query_cache_min_res_unit = 1K query_cache_size = 1280M query_cache_type = 1 table_cache = 10000 table_definition_cache = 10000 thread_cache_size = 400 tmp_table_size = 256M max_heap_table_size = 256M key_buffer_size = 256M sort_buffer_size = 256K myisam_sort_buffer_size = 15M join_buffer_size = 1M preload_buffer_size = 128K read_buffer_size = 128K read_rnd_buffer_size = 128K

1 0

[Maria-discuss] warning from binary tarball file installation.
by Peter Boston 28 Feb '15

28 Feb '15

I am installing mariadb-10.0.15 on Fedora 20 from a binary tarball file. After several changes on .my.cnf file, I minimized the installation warning to three. I am using the default my-large.cnf file from the release. How can I eliminate them, particularly the last one: Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist. Thanks, [root@dev2 mysql]# ./scripts/mysql_install_db --defaults-file=~/.my.cnf --user=mysql Installing MariaDB/MySQL system tables in './data' ... 150225 10:37:35 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150225 10:37:35 [Note] InnoDB: The InnoDB memory heap is disabled 150225 10:37:35 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150225 10:37:35 [Note] InnoDB: Memory barrier is not used 150225 10:37:35 [Note] InnoDB: Compressed tables use zlib 1.2.3 150225 10:37:35 [Note] InnoDB: Using Linux native AIO 150225 10:37:35 [Note] InnoDB: Not using CPU crc32 instructions 150225 10:37:35 [Note] InnoDB: Initializing buffer pool, size = 384.0M 150225 10:37:35 [Note] InnoDB: Completed initialization of buffer pool 150225 10:37:35 [Note] InnoDB: The first specified data file /usr/local/mysql/data/ibdata1 did not exist: a new database to be created! 150225 10:37:35 [Note] InnoDB: Setting file /usr/local/mysql/data/ibdata1 size to 2000 MB 150225 10:37:35 [Note] InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 150225 10:37:42 [Note] InnoDB: Data file /usr/local/mysql/data/ibdata2 did not exist: new to be created 150225 10:37:42 [Note] InnoDB: Setting file /usr/local/mysql/data/ibdata2 size to 10 MB 150225 10:37:42 [Note] InnoDB: Database physically writes the file full: wait... 150225 10:37:42 [Note] InnoDB: Setting log file /usr/local/mysql/data/ib_logfile101 size to 100 MB InnoDB: Progress in MB: 100 150225 10:37:43 [Note] InnoDB: Setting log file /usr/local/mysql/data/ib_logfile1 size to 100 MB InnoDB: Progress in MB: 100 150225 10:37:43 [Note] InnoDB: Renaming log file /usr/local/mysql/data/ib_logfile101 to /usr/local/mysql/data/ib_logfile0 150225 10:37:43 [Warning] InnoDB: New log files created, LSN=45782 150225 10:37:43 [Note] InnoDB: Doublewrite buffer not found: creating new 150225 10:37:43 [Note] InnoDB: Doublewrite buffer created 150225 10:37:43 [Note] InnoDB: 128 rollback segment(s) are active. 150225 10:37:43 [Warning] InnoDB: Creating foreign key constraint system tables. 150225 10:37:43 [Note] InnoDB: Foreign key constraint system tables created 150225 10:37:43 [Note] InnoDB: Creating tablespace and datafile system tables. 150225 10:37:43 [Note] InnoDB: Tablespace and datafile system tables created. 150225 10:37:43 [Note] InnoDB: Waiting for purge to start 150225 10:37:43 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.21-70.0 started; log sequence number 0 150225 10:37:43 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 150225 10:37:43 [Note] InnoDB: FTS optimize thread exiting. 150225 10:37:43 [Note] InnoDB: Starting shutdown... 150225 10:37:45 [Note] InnoDB: Shutdown completed; log sequence number 1616698 OK Filling help tables... 150225 10:37:45 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150225 10:37:45 [Note] InnoDB: The InnoDB memory heap is disabled 150225 10:37:45 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150225 10:37:45 [Note] InnoDB: Memory barrier is not used 150225 10:37:45 [Note] InnoDB: Compressed tables use zlib 1.2.3 150225 10:37:45 [Note] InnoDB: Using Linux native AIO 150225 10:37:45 [Note] InnoDB: Not using CPU crc32 instructions 150225 10:37:45 [Note] InnoDB: Initializing buffer pool, size = 384.0M 150225 10:37:45 [Note] InnoDB: Completed initialization of buffer pool 150225 10:37:45 [Note] InnoDB: Highest supported file format is Barracuda. 150225 10:37:45 [Note] InnoDB: 128 rollback segment(s) are active. 150225 10:37:45 [Note] InnoDB: Waiting for purge to start 150225 10:37:45 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.21-70.0 started; log sequence number 1616698 150225 10:37:46 [Note] InnoDB: FTS optimize thread exiting. 150225 10:37:46 [Note] InnoDB: Starting shutdown... 150225 10:37:48 [Note] InnoDB: Shutdown completed; log sequence number 1616708 OK

2 1

[Maria-discuss] Default privileges for anon. user.
by dE 26 Feb '15

26 Feb '15

Hi! I've realized that by default MariaDB allow full access to a database for anon. users. $ mysql --user asdfasdf test MariaDB [test]> insert into test (sr) values (1); Query OK, 1 row affected (0.12 sec) I tried to revoke but -- Revoke all on test.test from ''@''; ERROR 1141 (42000): There is no such grant defined for user '' on host '%' Is there anyway to disallow all types of access to anon. users?

2 2

[Maria-discuss] questions from a new user
by Peter Boston 25 Feb '15

25 Feb '15

I am new to use mariadb on linux machine. I am using Fedora 20 and I have downloaded the mariadb 10.0.15 tar.gz file and its instruction. I removed the existing mariadb from my Fedora 20. I have installed the mariadb on my machine by following the official instruction. It seems successful (without error) but I cannot start it as expected. I also have few other basic questions. Some background information here: this database will be accessed by a local application. This local application may be running under a general user account, user1. I installed it in /var/local as a root user. Questions: 1. How to uninstall it completely? I want to try again to see if I did anything wrong before. 2. Because it will be accessed by a local application and the local application will be running by a general user, user1, should I install it with user1? 3. Basically I am confused with these three users: user1, mysql and root. "user1" will be used to run the application and login the machine. "mysql" will be used to connect the mariadb. "root" will be used to install mariadb into /usr/local. Who will start the mariadb? It will be "root", I guess. But if "root" starts the service, "user1" and "mysql" don't have problem to access its resources? 4. If I don't want to install it as root, can I still install it under the /usr/local directory? 5. I renamed the my-large.cnf to .my.cnf and uncomment the InnoDB table section. Is this only change I need to make if I want to use InnoDB? should I disable the myisam? how? 6. where should I put the .my.cnf file? put into the home directory of the user who starts the mariadb or the user who logon the system if they are different? 7. there is a my.cnf file from the Fedora 20 installation, when I start mariadb without the "--defaults-file=~/.my.cnf" option, I will get the following error from the log: [ERROR] mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2 "No such file or directory") I have to manually create the mysqld folder inside the /var/run folder each time after reboot. how to avoid this? 8. After started with that "old" my.cnf, I try to stop the mariadb but cannot because I cannot find its service name: [user1@dev2 mysql]$ ./bin/mysqladmin -u root -p status Enter password: Uptime: 685 Threads: 1 Questions: 3 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 62 Queries per second avg: 0.004 [user1@dev2 mysql]$ sudo systemctl status mariadb.service mariadb.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) [user1@dev2 mysql]$ sudo systemctl status mysql.service mysql.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) [user1@dev2 mysql]$ sudo systemctl status mysqld.service mysqld.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) how stop it? 9. if I start mariadb with the renamed my-large.cnf ([root@dev2 mysql]# ./bin/mysqld_safe --defaults-file=~/.my.cnf --user=mysql), I got the following error: 150225 0:09:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 150225 0:09:28 [Note] Recovering after a crash using mysql-bin 150225 0:09:28 [Note] Starting crash recovery... 150225 0:09:28 [Note] Crash recovery finished. 150225 0:09:28 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 150225 0:09:28 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 150225 0:09:28 [Note] Server socket created on IP: '::'. 150225 0:09:28 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 150225 00:09:28 mysqld_safe mysqld from pid file /usr/local/mysql/data/dev2.pid ended Then I try do upgrade as suggested above: [root@dev2 mysql]# ./bin/mysql_upgrade Version check failed. Got the following error when calling the 'mysql' command line client ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2 "No such file or directory") FATAL ERROR: Upgrade failed so I think I need to make the mariadb running first, I use above 7 to make server running and then do upgrade, I got the following errors: [user1@dev2 mariadb-10.0.15-linux-x86_64]$ sudo ./bin/mysql_upgrade [sudo] password for user1: Phase 1/5: Checking mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.gtid_slave_pos Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine status : Operation failed mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.innodb_index_stats Error : Table 'mysql.innodb_index_stats' doesn't exist in engine status : Operation failed mysql.innodb_table_stats Error : Table 'mysql.innodb_table_stats' doesn't exist in engine status : Operation failed mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mapping OK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Repairing tables mysql.gtid_slave_pos Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine status : Operation failed mysql.innodb_index_stats Error : Table 'mysql.innodb_index_stats' doesn't exist in engine status : Operation failed mysql.innodb_table_stats Error : Table 'mysql.innodb_table_stats' doesn't exist in engine status : Operation failed Phase 2/5: Running 'mysql_fix_privilege_tables'... ERROR 1932 (42S02) at line 580: Table 'mysql.innodb_index_stats' doesn't exist in engine ERROR 1932 (42S02) at line 583: Table 'mysql.innodb_table_stats' doesn't exist in engine FATAL ERROR: Upgrade failed why I cannot run mariadb with the my.cnf which comes with this version of mariadb? The old my.cnf doesn't have innoDB section and I cannot enable it. Is this the reason? does the Fedora 20 support mariadb 10.0.15? Thanks, Peter

3 4

[Maria-discuss] New Question: other connectors
by AskMonty KB 24 Feb '15

24 Feb '15

Hello, A new question has been asked in "Client Libraries" by ferreirah. Please answer it at http://mariadb.com/kb/en/other-connectors/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Any plans for connectors for the dot net framework? H.F. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/other-connectors/

1 0