- discuss - lists.mariadb.org

[Maria-discuss] New Question: Percona XtraBackup restore
by AskMonty KB 09 Aug '16

09 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/percona-xtrabackup-restore/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do i restore a single database from a full backup or from a single database backup?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/percona-xtrabackup-restore/

1 0

[Maria-discuss] Help on ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
by Karthick Subramanian 07 Aug '16

07 Aug '16

Dear Experts, I almost tried all sort of combinations that I think of very difficult to crack, but repeatedly failed to satisfy MariaDB not throw this error. Can anyone guide me on what is the specific needs for successful password. Warning message: +---------+------+----------------------------------------------------------------+ | Level | Code | Message | +---------+------+----------------------------------------------------------------+ | Warning | 1819 | cracklib: error loading dictionary | | Error | 1819 | Your password does not satisfy the current policy requirements | +---------+------+----------------------------------------------------------------+ Regards, Karth

2 2

[Maria-discuss] Discrepancy with innodb table statistics
by Mark Wadham 05 Aug '16

05 Aug '16

Can anyone explain this? http://pastebin.com/Zctaj8BE TL;DR index sizes seem to differ drastically in size depending on how you request them. Thanks, Mark

1 1

[Maria-discuss] New Question: 2 node replication failover/recovery
by AskMonty KB 04 Aug '16

04 Aug '16

Hello, A new question has been asked in "MariaDB Community" by greg_brownell_g. Please answer it at http://mariadb.com/kb/en/2-node-replication-failoverrecovery/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there a way to automate the following: 1. 2 node system set up as master-master replication 2. node 1, master 1 fails. 3. node 2 master 2 is now the active instance. Up to here, all works well. Replication is fast enough. We detect failure and code now uses master 2 on node 2. The problem is sync'ing master 1 when the node 1 restarts, perhaps 5 minutes later. Requirement is: 1. node 2 master 2 continues to run without interruption 2. node 1 master 1 must sync as quickly as possible with node 2 master 2 3. this must be done without human intervention (using scripts, programs, whatever) Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/2-node-replication-failoverrecovery/

1 0

[Maria-discuss] New Question: MariaDB Backup using Percona XtraBackup
by AskMonty KB 03 Aug '16

03 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-faq-mariadb-backup-using-percona-xtrabacku… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Percona suggests to use the xtrabackup script for taking backup but it does not have anything to take compressed backup.The compact backup reduces the size of 48gb database to 47gb which is of no use. How to acheive compressed backup using percona xtrabackup utility?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-faq-mariadb-backup-using-percona-xtrabacku…

1 0

[Maria-discuss] New Question: How to trace events status?
by AskMonty KB 03 Aug '16

03 Aug '16

Hello, A new question has been asked in "Events" by dzlsnw53r4_60336. Please answer it at http://mariadb.com/kb/en/how-to-trace-events-status/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, I want to trace the events last results and fail events at 3 days, how can i do this? Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-trace-events-status/

1 0

[Maria-discuss] Orphaned TokuDB tables
by Rich Prohaska 03 Aug '16

03 Aug '16

Hello All, Sometimes, TokuDB gets left in a state where it thinks that parts of a table exist (as observed in TokuDB's file map), but not all of the underlying files (the TokuDB data files and/or the frm file) exist. This probably occurs due to the interaction between the non-transactional DDL that MySQL/MariaDB uses to create or drop tables, and the transactional TokuDB engine underneath. There is some bug there. So, what can one do to remove broken TokuDB file maps? There is an internal fractal tree called the tokudb.directory that names high level data names to an underlying file that the data is stored in. The tokudb_file_map information schema dumps out the contents of this tree. The key to this tree is the high level data name (called a dname). In TokuDB, this data name consists of the database name, the table name, and the index name. There is also a tree for the table (called status) that contains table wide metadata. I added the tokudb_delete_dnames_from_directory tool to the https://github.com/prohaska7/mariadb-server/tree/fix-tokudb-filemap branch. This standalone tool can be used to delete dnames from the tokudb.directory. Standalone means that MariaDB must have been previously shutdown cleanly (which puts the tokudb recovery logs in a nice clean state so that the tool does not have to run crash recovery). The input to the tool is the MariaDB data directory with nice and clean tokudb recovery logs along with a sequence of dname's. The tool transactionally deletes rows from the tokudb.directory fractal tree, which updates the recovery logs. Building the tool requires a MariaDB build environment a simple compile sequence something like this: gcc -g -o tokudb_delete_dnames_from_directory tokudb_delete_dnames_from_directory.cc -I$TFT/buildheader -L$TFT/src -ltokufractaltree Running the tool looks something like this: Get the dnames of interest from the tokudb_file_map. In this case, they are ./test/s-main and ./test/s-status. shutdown MariaDB ./tokudb_delete_dnames_from_directory ~/projects/mariadb-server-install/data ./test/s-main ./test/s-status

2 2

[Maria-discuss] New Question: Missing CentOS7 RPM: MariaDB-10.1.16-centos7-x86_64-cassandra-engine.rpm?
by AskMonty KB 02 Aug '16

02 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by justin.w.calloway_60714. Please answer it at http://mariadb.com/kb/en/missing-centos7-rpm-mariadb-10116-centos7-x86_64-c… as the person asking the question may not be subscribed to the mailing list. -------------------------------- It appears the rpm for the Cassandra storage engine is not available in your repository for centos7 or rhel7. The package exist in in centos 6 repository but not 7, is this on purpose? Is the Cassandra storage engine supported on CentOS7? Example of Cassandra storage engine rpm in the CentOS6 repo: http://yum.mariadb.org/10.1/centos6-amd64/rpms/ Example of the CentOS7 repo not containing the Cassandra storage engine rpm: http://yum.mariadb.org/10.1/centos7-amd64/rpms/ -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/missing-centos7-rpm-mariadb-10116-centos7-x86_64-c…

1 0

[Maria-discuss] New Question: MONyog Monitoring
by AskMonty KB 02 Aug '16

02 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-monitoring/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is MONyog capable of monitoring INNODB table locks and mutex locks?? Also can it monitor binary logs of MariaDB database.?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-monitoring/

1 0

[Maria-discuss] New Question: MONyog Table Alert
by AskMonty KB 02 Aug '16

02 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-table-alert/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do i set up an alert for all the tables in all databases if they grow more than specified size ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-table-alert/

1 0