There have been recently many requests on adapting the multi store contribution to the latest Creloaded version. As the Creloaded and OSCommerce structure are quite different, it’s somehow tricky to do this. There are even some existing files templates in the template folder that the default Osc MS2.2 does not have. But basically, you need to compare first files in multi-store_v2.0\catalog folder with Creloaded and insert the instances of (M-S_,M-S_multi-stores, M-S_pricing, M-S-fixes). We recommend using Beyond Compare to do this.

If you successfully installed it, then you should have something like this:

1. Create a store:

You must enter Information of store, which you want to create. Then, you click “Save” button to create the store or click Cancel button to delete Information, which you have inputted.

2. Categories/products to store:

3. Create Administrators:

We have also made many changes to improve the current multi store mod. If you want to implement this on your store, please contact us for more information.

Rascator, SmartOSC’s CTO, has shared some top firefox plugins extremely useful for website development.

Firstly, install MR Tech Disable XPI Install Delay to remove Counter every time installing Extension ( it often take us from 3 to 5 seconds to complete this).

• MR Tech Disable XPI Install Delay 2.3 by Mel Reyes (aka: mrtech)

Then, please install next extension. However, it is not necessary to install all extensions to avoid making computer overloaded. It is because there are some extensions with the same option, so you only need to install one. Web Developer extension itself offers many tools for HTML, FORM, and CSS…, so you should install this and further if it is necessary. Moreover, if you need one more extension, please search it in the page: https://addons.mozilla.org/firefox/extensions/, use the key word SVN.

• Web Developer by Chris Pederick – Lots of tools
• CSSViewer 1.0.2 by Nicolas Huon – COOL
• FireBug by Joe Hewitt – Javascript debuger, cool
• JSView 1.2.5 by Ron Beckman
• Execute JS 0.1.1 by Rudolf Noe
• JavaScript Debugger 0.9.87 by James Ross, Robert Ginda
• XML Developer Toolbar 0.2 by Scott Root II
• Total Validator 3.4 by Andy Halford
• Relaxed the HTML Validator 0.9.1 by Jaroslav Hanslik
• Html Validator 0.7.9.5 by Marc Gueury
• HTML Validator (based on CSE HTML Validator) 1.2.3 by AI Internet Solutions
• CSS validator 0.3 by Michael Langley
• W3C CSS validator 0.1.4 by Mat
• FireColour 1.0 by Shivdeep
• ColorZilla 0.8.2 by Alex Sirota
• IE Tab 1.3.0.20070110 by PCMan (Hong Jen Yee), yuoo2k – view in Firefox, use render engine of IE
• IE View Lite 1.3 by Grayson Mixon – Open ra IE
• ScreenGrab! 0.93 by Andy M

In addition, it would be great to install some following extensions to enhance the ability of Firefox:

• Tab Mix Plus 0.3.5.2 by CPU, onemen
• Undo Closed Tabs Button 2.0.0 by Kurt Schultz
• HighlightAll 1.1 by Jérôme Goudey
• del.icio.us Bookmarks by Yahoo! Inc. – Sync bookmark between your computer at home and in the company.
• FireFTP by Mime Cuvalo – FTP available in the firefox
• Download Statusbar by Devon Jensen – Download progress in status bar.

Why i have to do master-slave replication using MySQL?

1. One of the biggest advantages to have master-slave set up in MySQL is to be able to use master for all of the inserts, update and delete queries and slave for select queries. This will most probably speed up your application without having to diving into optimizing all the queries or buying more hardware.

2. Do backups from slave: One of the advantages people overlook is that you can use MySQL slave to do backups from. That way site is not affected at all when doing backups.

Goal: Master DB – Use db only for insert,delete and updated queries
Slave DB – Use db only for select queries

There are several Master-Slave replication available in MySQL. Below is the one of the best Master-Slave replication.

Note:

1. Below configuration is only for a single database replication.
2. Do the step 1 and step 2 in your master server and step 3 and step 4 slave servers.
3. Before doing all steps, you must create database and repective tables in your master and slave server.

Step 1: (Activate binary(bin) log in MySQL)

vi /etc/my.cnf
===============
log-bin = mysql-bin
binlog-do-db = databasename // give your database name
server-id = 1 // unique id depend upon your servers

Step 2: (Creating a new user in Master)

In mysql… login as root user.

CREATE USER username;
GRANT replication SLAVE on *.* TO ‘username’@'%’ IDENTIFIED BY ‘password’;

Step 3:

vi /etc/my.cnf
==============

server-id = 2
master-host = master ip address
master-user = username
master-password = password
master-connect-retry = 60
replicate-do-db = databasename

Step 4:

In mysql console…

show slave status;
start slave;

Hope this will help you!!!