Kategorije:


02.01.2008.

MySQL Cluster + replication
Lokacija: Zanimljivi linkovi :: MySQL   |   Autor: cacan @ 3:00   |  

You may know about the MySQL Cluster, which is a complex architecture to achieve high availability and performance. One of the advantages of MySQL Cluster is that each node is a peer to the others, whereas in a normal replicating system you have a master and many slaves, and applications must be careful to write only to the master.

The main disadvantages of MySQL Cluster are (as of MySQL 5.0):

* The database is in memory only, thus requiring more resources than a normal MySQL database. (MySQL 5.1 introduces table spaces, with the capability of storing nonindexed data on disk.)
* Some normal features are not available, such as full-text searches, referential integrity, and transaction isolation levels higher than READ COMMITTED.

There are some cases where the MySQL Cluster is the perfect solution, but for the vast majority, replication is still the best choice.

Replication, too, has its problems, though:

* There is a fastidious distinction between master and slaves. Your applications must be replication-aware, so that they will write on the master and read from the slaves. It would be so nice to have a replication array where you could use all the nodes in the same way, and every node could be at the same time master and slave.
* There is the fail-over problem. When the master fails, it’s true that you have the slaves ready to replace it, but the process of detecting the failure and acting upon it requires the administrator’s intervention.

Fixing these two misfeatures is exactly the purpose of this article. Using features introduced in MySQL 5.0 and 5.1, it is possible to build a replication system where all nodes act as master and slave at the same time, with a built-in fail-over mechanism.

Read more: Setting Up a Multimaster Replication System




Vezani blogovi:
  • Wampserver - WAMP5 + WAMP4 - Win32 Apache MySQL PHP
  • MySync - MySQL - Synchronisation without ODBC-Connection
  • Migrating from Microsoft Access to MySQL
  • WOS - WebServer on Stick - Apache, MySQL, PHP - USB stick
  • PHP, Apache, MySQL - direktno s CD-a
  • MySQL regular expression search engine
  • Appserv Open Project - one click install Apache PHP MySQL Zend phpMyAdmin






    • Was this article helful to you? If so, please click on the (+) [plus] sign below! It's Croatian digg ;-) Tnx!

    24.11.2005.

    Oracle PHP Cookbook
    Lokacija: WebDev :: PHP :: Database :: Razno   |   Autor: cacan @ 10:54   |  

    O tome sto Oracle misli o PHPu moze se vidjeti na potonjoj adresi… pogodno za sve nadri-enterprise mambodzamboe koji vole pljuckati po PHPu…. ;-)

    The Oracle+PHP Cookbook

    Explore a broad range of HowTos for leveraging Oracle’s PL/SQL APIs in PHP applications.

    Welcome to the Oracle+PHP Cookbook! Whether you are a Web developer or enterprise developer looking to combine the robustness of the Oracle engine with the simplicity, performance, and ease-of-use of PHP, you are bound to find several interesting “recipes” here, each contributed by PHP coders, that will help you take full advantage of both technologies.




    Vezani blogovi:
  • PHP Oracle editor
  • php ADOdb (+ ADOdb lite) - DB abstraction layer
  • Database Designer - fabforce.net
  • PHP code generatori - code generators -phpCodeGenie - EZPDO
  • Online personality tests - testovi osobnosti






    • Was this article helful to you? If so, please click on the (+) [plus] sign below! It's Croatian digg ;-) Tnx!

    23.11.2005.

    TurboDbAdmin - Ajax MySQL DB admin
    Lokacija: WebDev :: PHP :: Database :: MySQL :: Razno   |   Autor: cacan @ 10:11   |  

    TurboDbAdmin - Ajax MySQL DB admin

    single-page solution for exploring and editing databases from a browser. Edit data just like you would in a desktop application, without submit buttons or page refreshes. Built using cutting-edge TurboWidgets and the Dojo Toolkit.
    We are proud to release our first public Beta version. TurboDbAdmin is free to download and install on any standard web server.



    Vezani blogovi:
  • AjaxCore: PHP Ajax Framework
  • Wampserver - WAMP5 + WAMP4 - Win32 Apache MySQL PHP
  • MySQL Cluster + replication
  • meebo.com - web instant messaging - ajax
  • MySync - MySQL - Synchronisation without ODBC-Connection
  • Migrating from Microsoft Access to MySQL
  • Ajax - PHP - Asynchronous JavaScript And XML - intro, tutorials, manuals, examples






    • Was this article helful to you? If so, please click on the (+) [plus] sign below! It's Croatian digg ;-) Tnx!

    08.11.2005.

    php ADOdb (+ ADOdb lite) - DB abstraction layer
    Lokacija: WebDev :: PHP :: Comp & Internet :: Database :: Razno   |   Autor: cacan @ 15:51   |  

    Koristim ga vec neko vrijeme… predivno… a od nedavno i predivno lite ;-)

    PHP ADOdb

    php ADOdb lite

    ADOdb is a database abstraction library for PHP. There is also a Python version; see the ADOdb for Python docs.

    The PHP version currently supports an amazing number of databases, thanks to the wonderful ADOdb community: MySQL, PostgreSQL, Interbase, Firebird, Informix, Oracle, MS SQL, Foxpro, Access, ADO, Sybase, FrontBase, DB2, SAP DB, SQLite, Netezza, LDAP, and generic ODBC, ODBTP. The Sybase, Informix, FrontBase and PostgreSQL, Netezza, LDAP, ODBTP drivers are community contributions.



    Vezani blogovi:
  • PRADO PHP5 Framework
  • PHP code generatori - code generators -phpCodeGenie - EZPDO
  • WAMP - Windows Apache MySQL PHP - one click install solution
  • HDR tutorial
  • Tech Info Pages - zgodni prirucni alati - net tools
  • Anti-rootkit, antirootkit tools, scanners






    • Was this article helful to you? If so, please click on the (+) [plus] sign below! It's Croatian digg ;-) Tnx!

    06.06.2005.

    MySync - MySQL - Synchronisation without ODBC-Connection
    Lokacija: WebDev :: MySQL   |   Autor: cacan @ 14:51   |  

    MySync - MySQL - Synchronisation without ODBC-Connection

  • MySync
    Do they know the problem? You have a MySQL data base with your Web account and need the data also at home on your client PC to work on there. For safety reasons it is mostly not possible to access the Web MySQL data base with a ODBC connection.
    MMySync is the solution
    MySync needs no ODBC connection, because it synchronizes the MySQL data base by ftp and PHP access. They can define as many as desired jobs, which synchronize the data automatically between the client and the Web data base. In addition the possibility exists to call also other php documents time-steered, in order to thus update server data. itig Daten zu aktualisieren.



    • Vezani blogovi:
  • Wampserver - WAMP5 + WAMP4 - Win32 Apache MySQL PHP
  • TCPing - small utility za ping-over-tcp connection
  • MySQL Cluster + replication
  • Migrating from Microsoft Access to MySQL
  • php ADOdb (+ ADOdb lite) - DB abstraction layer
  • WOS - WebServer on Stick - Apache, MySQL, PHP - USB stick
  • PHP, Apache, MySQL - direktno s CD-a






    • Was this article helful to you? If so, please click on the (+) [plus] sign below! It's Croatian digg ;-) Tnx!

    05.05.2005.

    PHPfreaks, Apachefreaks, MySQLfreaks - odlican freaks sites network ;-)
    Lokacija: WebDev :: PHP :: Database :: MySQL :: Hosting   |   Autor: cacan @ 11:08   |  

    PHPfreaks.com

    This website exists to provide you with information to use while learning or developing PHP and MySQL. If you need PHP Help or you would like to provide PHP Help to other developers, you are in the right place. Additionally, we offer Apache Help, MySQL Help, Javascript Help, CSS Help, XML Help and much more.

    MySQLfreaks.com

    MySQL Freaks is an online community built to help each other with MySQL. This community is completely Free to use and get the information you need to solve your MySQL problems.

    Apachefreaks.com

    Apache Freaks is an online community built to help each other with the ever so popular Apache Web Server. This community is completely Free to use and get the information you need to solve your Apache Web Server problems.



    Vezani blogovi:
  • Network IP calculator
  • Clanak: Security Aspects of a PHP-MySQL-based Login System for Web Sites
  • Windows2000 - gasenje servicea i nepotrebnih portova - Minimization of network services on Windows systems
  • Network view (scanner)
  • PHPcap - Pcap and Network extension for php - packet sniffing
  • Warez scene info - About The Scene
  • Desksoft BWmeter (bandwidth meter) - complete trash!






    • Was this article helful to you? If so, please click on the (+) [plus] sign below! It's Croatian digg ;-) Tnx!

    20.03.2005.

    Migrating from Microsoft Access to MySQL
    Lokacija: WebDev :: Database :: MySQL   |   Autor: cacan @ 17:07   |  

    Prebacivanje podataka iz Microsoft Access baze u MySQL… zgodne upute…

    Migrating from Microsoft Access to MySQL

    Tnx Bert za link…




    Vezani blogovi:
  • MySync - MySQL - Synchronisation without ODBC-Connection
  • Wampserver - WAMP5 + WAMP4 - Win32 Apache MySQL PHP
  • MySQL Cluster + replication
  • Best Free Web Hosting
  • WOS - WebServer on Stick - Apache, MySQL, PHP - USB stick
  • PHP, Apache, MySQL - direktno s CD-a
  • Modsecurity audit_log analysis






    • Was this article helful to you? If so, please click on the (+) [plus] sign below! It's Croatian digg ;-) Tnx!

    26.12.2004.

    PHP Oracle editor
    Lokacija: WebDev :: PHP :: Database :: Razno   |   Autor: cacan @ 13:33   |  
  • PHP Oracle editor
    • OracleEditor.php is a standalone PHP script which allows you to browse your Oracle database tables and insert, update and delete rows in any table. It requires no installation and no configuration.

  • http://tim.digicol.de/oraedit/



    • Vezani blogovi:
  • Oracle PHP Cookbook
  • WYSIWYG HTML Area Editor - TinyMCE
  • Usability news - najbolji site za web usability
  • php ADOdb (+ ADOdb lite) - DB abstraction layer
  • Database Designer - fabforce.net
  • Disable USB autorun
  • MultiEX commander - game editor






    • Was this article helful to you? If so, please click on the (+) [plus] sign below! It's Croatian digg ;-) Tnx!

    13.09.2004.

    MySQL regular expression search engine
    Lokacija: WebDev :: Database :: MySQL   |   Autor: cacan @ 12:44   |  

    Clanak o jednostavnom google-like search engineu za MySQL

    Searching with PHP and MySQL

    Na siteu iamcal publishing empire se nalazi jos zanimljivih clanaka napisanih od istog autora (Cal Henderson), ovo su neke od tema:

    Basic Javascript
    Variable scoping [pdf]

    Practical Javascript
    Fixing common bugs [pdf]
    Working with cookies [pdf]

    Advanced Javascript
    Amazon library [pdf]
    Google Highlighting [pdf]
    Javascript E-Commerce [pdf]

    PHP
    Human Readable Numbers [pdf]
    Processing HTML [pdf]
    Processing HTML, Part 2 [pdf]
    Search term highlighting [pdf]
    Searching with PHP and MySQL [pdf]
    Writing cleaner code [pdf]
    Writing secure and portable PHP applications [pdf]

    Web Security
    Designing user authentication systems [pdf]
    The problem with cookie authentication systems [pdf]



    Vezani blogovi:
  • Search engine map
  • SEO Tools - Search Engine Position Tool
  • PHP & regular expressions (regexps) tutorial
  • Pagerank.net - odlican SEO tool
  • Google.com - originalni rad - kako je nastao
  • Wampserver - WAMP5 + WAMP4 - Win32 Apache MySQL PHP
  • SEO Analyzer - A Web Standards & SEO Page Analyzer






    • Was this article helful to you? If so, please click on the (+) [plus] sign below! It's Croatian digg ;-) Tnx!

    16.07.2004.

    Database Designer - fabforce.net
    Lokacija: WebDev :: Database :: MySQL   |   Autor: cacan @ 12:53   |  

    Zanimljiv i zgodan freeware (open source) database designer i admin:

    Database Designer screenshot

    Link: Database Designer
    Link na PHP code maker plugin: SimpleWebFront
    DBdesigner Forum

    O samom proizvodu:

    General Information - What is DBDesigner 4?

    DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment.

    It combines professional features and a clear and simple user interface to offer the most efficient way to handle your databases.

    DBDesigner 4 compares to products like Oracle’s Designer©, IBM’s Rational Rose©, Computer Associates’s ERwin© and theKompany’s DataArchitect© but is an Open Source Project available for Microsoft Windows© 2k/XP and Linux KDE/Gnome. It is release on the GPL.



    Vezani blogovi:
  • M42 - lenses - lens database - objektivi
  • Web Design is 95% Typography
  • PHP code generatori - code generators -phpCodeGenie - EZPDO
  • MySQL Cluster + replication
  • Download free books online
  • Online personality tests - testovi osobnosti
  • Kako ce izgledati buducnost Interneta? Future of Internet






    • Was this article helful to you? If so, please click on the (+) [plus] sign below! It's Croatian digg ;-) Tnx!

       9 korisnika online   
    August 2020
    S M T W T F S
    « May    
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  
    Za korisnike:

    153 queries. 0.284 seconds. Powered by Blog385.com