SQuaLe is a glib based SQL query load balancer over persitent database connections.
Be the first to post a text review of SQuaLe. Rate and review a project by clicking thumbs up or thumbs down in the right column.
2009-02-27 Julien Moutte <julien@fluendo.com> * configure.in: Release 0.1.12 * src/squaleclient.c: (squale_client_read_string): * src/squalejoblist.c: (squale_joblist_giveup_job): Random fixes. * src/squaleoracleworker.c: (squale_oracle_worker_disconnect), (squale_oracle_worker_run), (squale_oracle_worker_set_property), (squale_oracle_worker_get_property), (squale_oracle_worker_init), (squale_oracle_worker_class_init): * src/squaleoracleworker.h: Introduce a parameter to tweak the way commits get done in the Oracle worker. Indeed in a scenario where massive inserts are done, having a commit for each of them is very expensive for the database. This "commit-every" parameter will allow to configure after how many queries that affected rows (insert, delete, update) a commit should be done. A commit will be done when the worker is cycling the database connection as well.
2008-09-26 Julien Moutte <julien@fluendo.com> * TODO: Updated. * src/squalejoblist.c: (squale_joblist_giveup_job): * src/squalejoblist.h: Introduce a new function to give up on a job and put it back in the joblist. * src/squalemysqlworker.c: (squale_mysql_worker_run): * src/squalepgsqlworker.c: (squale_pgsql_worker_run): Implement a give up scenario on a job when we lost connection. Indeed some other workers could have a working connection and could handle the job.
2007-09-27 Julien MOUTTE <julien@moutte.net> * src/squaleoracleworker.c: * src/squalepgsqlworker.c: Fix compilation warnings for missing headers. 2007-09-27 Julien MOUTTE <julien@moutte.net> * contrib/python/SQuaLe.py: Patch by: Michael Smith <msmith@fluendo.com> * src/squalejoblist.c: (squale_joblist_assign_pending_job): * src/squalemysqlworker.c: (squale_mysql_worker_run): * src/squaleoracleworker.c: (squale_oracle_worker_run): * src/squalepgsqlworker.c: (squale_pgsql_worker_run): Fix a race when a job is being assigned to a worker and the client disconnects at that same time. Indeed the refcounting was getting to zero while the worker was using that job making it crash on random stuff like the query string being NULL. 2007-06-07 Julien MOUTTE <julien@moutte.net> * lib/squaleclient.c: (squale_run_query): Fix a potential leak/crash when select indicates no error but there's nothing to read from the socket and variables were not initialized. Patch by: Michael Smith <msmith@fluendo.com> 2006-10-05 Julien MOUTTE <julien@moutte.net> * src/squaleoracleworker.c: (squale_oracle_worker_run): Fix broken connections recovery. * src/squaleworker.c: * src/squale.c: (main): * src/squalexml.c: Fix compilation warnings. 2006-10-04 Julien MOUTTE <julien@moutte.net> * conf/squale.xml.in: Put some example config parameters. * src/squaleworker.c: (squale_worker_class_init): Change parameter name with dash to be coherent with others. 2006-10-02 Julien MOUTTE <julien@moutte.net> * .cvsignore: * src/squale.c: (squale_stats_client), (squale_accept_new_client), (squale_check_mem_block), (squale_set_log_level), (squale_set_log_file), (main): Fix indentation. * src/squaleclient.c: (squale_client_send_result), (squale_client_execute_system_order), (squale_client_job_io_watch), (squale_client_execute), (squale_client_read_string), (squale_client_client_io_watch), (squale_client_dispose), (squale_client_class_init), (squale_client_set_fd), (squale_client_handle), (squale_client_get_type): Fix indentation, Fix a big issue when read_string could disconnect client, and then SIGHUP will try to disconnect it as well. * src/squalelistener.c: (squale_listener_count_clients), (squale_listener_open): Fix indentation. 2006-09-27 Julien MOUTTE <julien@moutte.net> * src/squalejoblist.c: (squale_joblist_add_job): * src/squalemysqlworker.c: (squale_mysql_worker_run): * src/squaleoracleworker.c: (squale_oracle_worker_run): * src/squalepgsqlworker.c: (squale_pgsql_worker_run): * src/squaleworker.c: (squale_worker_set_property), (squale_worker_get_property), (squale_worker_init), (squale_worker_class_init), (squale_worker_cycle_connection), (squale_worker_get_type): * src/squaleworker.h: Introduce database connection cycling per worker after a number of processed jobs. 2006-09-26 Julien MOUTTE <julien@moutte.net> * conf/squale.xml.in: Add max-pending-block-level parameter * configure.in: Bump to 0.1.10 * src/squalejoblist.c: (squale_joblist_add_job): Block jobs on that list when the blocking level is reached. 2006-09-26 Julien MOUTTE <julien@moutte.net> * src/squalejoblist.c: (squale_joblist_init), (squale_joblist_class_init), (squale_joblist_get_stats), (squale_joblist_add_job), (squale_joblist_assign_pending_job), (squale_joblist_set_max_pending_warn_level), (squale_joblist_set_max_pending_block_level), (squale_joblist_get_type): Prepare for job blocking when a maximum number of pending jobs is reached. * src/squalejoblist.h: * src/squalexml.c: (squale_xml_sigint_handler), (squale_xml_start_document), (squale_xml_start_element), (squale_xml_end_element), (squale_xml_new): Prepare for parsing that new option.
Be the first person to add a text review.
Copyright © 2010 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?
Thanks for your review!
Get credit for your review by logging in via OpenID. Click your account provider: